PREVIEW / etf_1hour / 2009-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-23.parquet
  size:    146 KB
  rows:    4,441

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2009-09-23 04:00:00	SPY	ETF	107.45	107.45	107.33	107.45	1800.0
2009-09-23 05:00:00	SPY	ETF	107.42	107.48	107.13	107.14	61200.0
2009-09-23 06:00:00	SPY	ETF	107.16	107.29	107.16	107.26	64400.0
2009-09-23 07:00:00	SPY	ETF	107.27	107.5	107.27	107.41	443349.0
2009-09-23 08:00:00	SPY	ETF	107.39	107.44	107.05	107.39	806787.0
2009-09-23 09:00:00	SPY	ETF	107.38	107.43	106.98	107.0199	16674674.0
2009-09-23 10:00:00	SPY	ETF	107.02	107.25	106.68	106.92	22683158.0
2009-09-23 11:00:00	SPY	ETF	106.92	107.12	106.74	107.1	10691655.0
2009-09-23 12:00:00	SPY	ETF	107.1	107.32	107.09	107.3	10157664.0
2009-09-23 13:00:00	SPY	ETF	107.3	107.41	107.15	107.3601	13819337.0
2009-09-23 14:00:00	SPY	ETF	107.36	108.03	107.18	107.39	52602800.0
2009-09-23 15:00:00	SPY	ETF	107.39	107.68	105.99	106.12	87289341.0
2009-09-23 16:00:00	SPY	ETF	106.11	107.77	106.045	106.29	9326885.0
2009-09-23 17:00:00	SPY	ETF	106.29	106.29	106.16	106.23	198404.0
2009-09-23 18:00:00	SPY	ETF	106.21	106.24	106.14	106.17	92936.0
2009-09-23 19:00:00	SPY	ETF	106.17	106.21	106.1	106.21	75117.0
2009-09-23 04:00:00	QQQ	ETF	42.81	42.81	42.81	42.81	100.0
2009-09-23 05:00:00	QQQ	ETF	42.82	42.82	42.7	42.7	4000.0
2009-09-23 07:00:00	QQQ	ETF	42.78	42.84	42.78	42.82	82818.0
2009-09-23 08:00:00	QQQ	ETF	42.8	42.87	42.79	42.84	668619.0
2009-09-23 09:00:00	QQQ	ETF	42.83	42.86	42.7	42.72	14949895.0
2009-09-23 10:00:00	QQQ	ETF	42.72	42.84	42.61	42.71	16313303.0
2009-09-23 11:00:00	QQQ	ETF	42.7	42.81	42.63	42.8	5093194.0
2009-09-23 12:00:00	QQQ	ETF	42.8	42.88	42.77	42.84	6052105.0
2009-09-23 13:00:00	QQQ	ETF	42.83	42.89	42.782	42.8649	5809035.0
2009-09-23 14:00:00	QQQ	ETF	42.86	43.17	42.8	42.9	38237216.0
2009-09-23 15:00:00	QQQ	ETF	42.89	43.02	42.377	42.42	40219651.0
2009-09-23 16:00:00	QQQ	ETF	42.42	42.6958	42.39	42.45	3854720.0
2009-09-23 17:00:00	QQQ	ETF	42.45	42.46	42.38	42.4	120684.0
2009-09-23 18:00:00	QQQ	ETF	42.41	42.43	42.38	42.42	54973.0
2009-09-23 19:00:00	QQQ	ETF	42.42	42.42	42.37	42.42	25559.0
2009-09-23 07:00:00	IWM	ETF	62.15	62.25	62.15	62.2	19037.0
2009-09-23 08:00:00	IWM	ETF	62.2	62.25	62.16	62.2	291554.0
2009-09-23 09:00:00	IWM	ETF	62.19	62.22	61.77	61.81	4336422.0
2009-09-23 10:00:00	IWM	ETF	61.8	62.02	61.67	61.82	6330241.0
2009-09-23 11:00:00	IWM	ETF	61.82	61.97	61.68	61.96	2911814.0
2009-09-23 12:00:00	IWM	ETF	61.95	62.07	61.938	62.06	2234262.0
2009-09-23 13:00:00	IWM	ETF	62.06	62.15	61.99	62.11	2893687.0
2009-09-23 14:00:00	IWM	ETF	62.11	62.61	61.99	62.13	12121891.0
2009-09-23 15:00:00	IWM	ETF	62.14	62.33	61.315	61.41	17426469.0
2009-09-23 16:00:00	IWM	ETF	61.41	62.039	61.3088	61.53	1949942.0
2009-09-23 17:00:00	IWM	ETF	61.45	61.48	61.39	61.4	5468.0
2009-09-23 18:00:00	IWM	ETF	61.35	61.35	61.3	61.31	5700.0
2009-09-23 19:00:00	IWM	ETF	61.34	61.38	61.33	61.38	3900.0
2009-09-23 08:00:00	DIA	ETF	98.46	98.48	98.38	98.44	5374.0
2009-09-23 09:00:00	DIA	ETF	98.42	98.46	98.14	98.17	768161.0
2009-09-23 10:00:00	DIA	ETF	98.1506	98.35	97.96	98.13	1552984.0
2009-09-23 11:00:00	DIA	ETF	98.1378	98.31	98.02	98.3	483600.0
2009-09-23 12:00:00	DIA	ETF	98.29	98.46	98.29	98.46	539724.0
2009-09-23 13:00:00	DIA	ETF	98.451	98.61	98.38	98.5975	662066.0

> showing 50 of 4,441 rows — these rows as CSV

> unlock the full archive -- $79 one-time