PREVIEW / etf_1hour / 2008-04-15

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-15.parquet
  size:    103 KB
  rows:    3,306

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
2008-04-15 05:00:00	SPY	ETF	132.75	132.75	132.75	132.75	100.0
2008-04-15 06:00:00	SPY	ETF	132.71	132.71	132.67	132.7	18300.0
2008-04-15 07:00:00	SPY	ETF	132.53	133.2	132.51	133.13	1529290.0
2008-04-15 08:00:00	SPY	ETF	133.13	133.67	132.71	133.67	8229519.0
2008-04-15 09:00:00	SPY	ETF	133.65	133.7	133.17	133.18	16309874.0
2008-04-15 10:00:00	SPY	ETF	133.19	133.58	132.76	133.01	32769366.0
2008-04-15 11:00:00	SPY	ETF	133.01	133.04	132.33	132.55	25749381.0
2008-04-15 12:00:00	SPY	ETF	132.55	132.79	132.42	132.69	13461242.0
2008-04-15 13:00:00	SPY	ETF	132.68	133.28	132.63	133.19	20246528.0
2008-04-15 14:00:00	SPY	ETF	133.19	133.28	132.76	132.85	17136345.0
2008-04-15 15:00:00	SPY	ETF	132.84	133.56	132.79	133.5	27778792.0
2008-04-15 16:00:00	SPY	ETF	133.5101	134.27	132.5	134.01	6320718.0
2008-04-15 17:00:00	SPY	ETF	133.99	134.27	133.9	134.2	795419.0
2008-04-15 18:00:00	SPY	ETF	134.21	134.21	134.02	134.02	108274.0
2008-04-15 19:00:00	SPY	ETF	134.05	134.07	133.91	134.01	43969.0
2008-04-15 06:00:00	QQQ	ETF	44.0	44.0	43.95	43.97	1300.0
2008-04-15 07:00:00	QQQ	ETF	43.95	44.21	43.93	44.16	1041710.0
2008-04-15 08:00:00	QQQ	ETF	44.16	44.39	44.05	44.32	2665598.0
2008-04-15 09:00:00	QQQ	ETF	44.31	44.35	44.1	44.1	13758036.0
2008-04-15 10:00:00	QQQ	ETF	44.11	44.21	43.81	43.9	26644344.0
2008-04-15 11:00:00	QQQ	ETF	43.9	43.94	43.68	43.8	16209991.0
2008-04-15 12:00:00	QQQ	ETF	43.8	43.94	43.75	43.89	9759587.0
2008-04-15 13:00:00	QQQ	ETF	43.89	44.12	43.83	44.07	13860710.0
2008-04-15 14:00:00	QQQ	ETF	44.0799	44.13	43.9	43.94	11906468.0
2008-04-15 15:00:00	QQQ	ETF	43.93	44.2	43.91	44.14	15546670.0
2008-04-15 16:00:00	QQQ	ETF	44.15	44.81	43.75	44.61	10491532.0
2008-04-15 17:00:00	QQQ	ETF	44.61	44.71	44.58	44.68	591451.0
2008-04-15 18:00:00	QQQ	ETF	44.68	44.72	44.67	44.67	177667.0
2008-04-15 19:00:00	QQQ	ETF	44.67	44.68	44.63	44.68	48687.0
2008-04-15 07:00:00	IWM	ETF	68.42	68.69	68.42	68.69	161539.0
2008-04-15 08:00:00	IWM	ETF	68.66	68.93	68.4	68.92	554892.0
2008-04-15 09:00:00	IWM	ETF	68.89	69.08	68.47	68.66	5582686.0
2008-04-15 10:00:00	IWM	ETF	68.66	68.81	68.39	68.55	7150870.0
2008-04-15 11:00:00	IWM	ETF	68.55	68.6	68.27	68.4	5675663.0
2008-04-15 12:00:00	IWM	ETF	68.4	68.62	68.31	68.57	5146247.0
2008-04-15 13:00:00	IWM	ETF	68.57	69.01	68.53	68.97	6375526.0
2008-04-15 14:00:00	IWM	ETF	68.97	69.05	68.65	68.7	5704920.0
2008-04-15 15:00:00	IWM	ETF	68.69	69.08	68.66	69.01	7553429.0
2008-04-15 16:00:00	IWM	ETF	69.0	69.73	68.86	69.41	1635321.0
2008-04-15 17:00:00	IWM	ETF	69.5	69.63	69.47	69.63	45769.0
2008-04-15 18:00:00	IWM	ETF	69.53	69.53	69.5	69.5	900.0
2008-04-15 19:00:00	IWM	ETF	69.46	69.46	69.46	69.46	5000.0
2008-04-15 06:00:00	DIA	ETF	123.0	123.0	122.9	122.9	324.0
2008-04-15 07:00:00	DIA	ETF	123.16	123.32	123.16	123.32	1100.0
2008-04-15 08:00:00	DIA	ETF	123.38	123.87	123.27	123.82	138511.0
2008-04-15 09:00:00	DIA	ETF	123.8	123.84	123.48	123.48	1856882.0
2008-04-15 10:00:00	DIA	ETF	123.49	123.6	123.11	123.42	2783319.0
2008-04-15 11:00:00	DIA	ETF	123.41	123.42	122.7	122.83	1926673.0
2008-04-15 12:00:00	DIA	ETF	122.84	123.03	122.75	122.96	879021.0
2008-04-15 13:00:00	DIA	ETF	122.97	123.54	122.92	123.47	1103796.0

> showing 50 of 3,306 rows — these rows as CSV

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