PREVIEW / etf_1hour / 2008-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-17.parquet
  size:    105 KB
  rows:    3,378

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-06-17 04:00:00	SPY	ETF	136.61	136.66	136.61	136.66	1200.0
2008-06-17 05:00:00	SPY	ETF	136.77	136.92	136.77	136.92	5200.0
2008-06-17 06:00:00	SPY	ETF	136.88	136.9	136.8	136.9	71600.0
2008-06-17 07:00:00	SPY	ETF	136.86	137.01	136.86	136.98	1009100.0
2008-06-17 08:00:00	SPY	ETF	136.98	137.38	136.81	137.28	8202862.0
2008-06-17 09:00:00	SPY	ETF	137.3	137.35	135.91	136.69	30151145.0
2008-06-17 10:00:00	SPY	ETF	136.69	136.91	136.26	136.57	27770636.0
2008-06-17 11:00:00	SPY	ETF	136.57	136.78	135.93	136.03	29286270.0
2008-06-17 12:00:00	SPY	ETF	136.03	136.34	135.7	135.9	19596575.0
2008-06-17 13:00:00	SPY	ETF	135.91	136.36	135.79	136.2	17207807.0
2008-06-17 14:00:00	SPY	ETF	136.2	136.4417	135.82	136.03	17652792.0
2008-06-17 15:00:00	SPY	ETF	136.04	136.11	135.45	135.5	32925356.0
2008-06-17 16:00:00	SPY	ETF	135.44	136.92	135.37	135.55	4455592.0
2008-06-17 17:00:00	SPY	ETF	135.55	135.57	135.42	135.44	138068.0
2008-06-17 18:00:00	SPY	ETF	135.44	135.5	135.37	135.38	45875.0
2008-06-17 19:00:00	SPY	ETF	135.36	135.49	135.33	135.49	14955.0
2008-06-17 04:00:00	QQQ	ETF	48.85	48.86	48.85	48.85	800.0
2008-06-17 06:00:00	QQQ	ETF	48.94	48.94	48.94	48.94	5000.0
2008-06-17 07:00:00	QQQ	ETF	48.92	48.96	48.9	48.92	485624.0
2008-06-17 08:00:00	QQQ	ETF	48.91	49.1	48.91	49.06	3572973.0
2008-06-17 09:00:00	QQQ	ETF	49.06	49.06	48.61	48.82	18450476.0
2008-06-17 10:00:00	QQQ	ETF	48.82	49.03	48.69	48.96	21990865.0
2008-06-17 11:00:00	QQQ	ETF	48.97	49.06	48.71	48.76	19248375.0
2008-06-17 12:00:00	QQQ	ETF	48.76	48.86	48.61	48.7	11537419.0
2008-06-17 13:00:00	QQQ	ETF	48.7	48.87	48.64	48.8399	7914176.0
2008-06-17 14:00:00	QQQ	ETF	48.84	48.89	48.7	48.78	7575253.0
2008-06-17 15:00:00	QQQ	ETF	48.78	48.8	48.47	48.55	21513205.0
2008-06-17 16:00:00	QQQ	ETF	48.55	48.7795	48.49	48.59	4039677.0
2008-06-17 17:00:00	QQQ	ETF	48.61	48.61	48.57	48.59	5049.0
2008-06-17 18:00:00	QQQ	ETF	48.56	48.61	48.56	48.56	12313.0
2008-06-17 19:00:00	QQQ	ETF	48.55	48.6	48.55	48.6	12807.0
2008-06-17 05:00:00	IWM	ETF	74.05	74.05	74.05	74.05	100.0
2008-06-17 06:00:00	IWM	ETF	74.12	74.15	74.08	74.15	22200.0
2008-06-17 07:00:00	IWM	ETF	74.11	74.23	74.1	74.21	68194.0
2008-06-17 08:00:00	IWM	ETF	74.21	74.4	74.02	74.28	1066697.0
2008-06-17 09:00:00	IWM	ETF	74.27	74.33	73.62	73.75	7392386.0
2008-06-17 10:00:00	IWM	ETF	73.75	73.97	73.62	73.9	7934738.0
2008-06-17 11:00:00	IWM	ETF	73.9	74.02	73.71	73.79	6176169.0
2008-06-17 12:00:00	IWM	ETF	73.79	73.94	73.63	73.79	4802803.0
2008-06-17 13:00:00	IWM	ETF	73.78	74.11	73.7	74.07	3316107.0
2008-06-17 14:00:00	IWM	ETF	74.07	74.1	73.78	73.93	5265721.0
2008-06-17 15:00:00	IWM	ETF	73.93	73.98	73.55	73.64	10252748.0
2008-06-17 16:00:00	IWM	ETF	73.63	73.8	73.57	73.78	3316474.0
2008-06-17 17:00:00	IWM	ETF	73.73	73.73	73.68	73.68	1060.0
2008-06-17 19:00:00	IWM	ETF	73.65	73.65	73.65	73.65	200.0
2008-06-17 07:00:00	DIA	ETF	123.27	123.38	123.27	123.34	5862.0
2008-06-17 08:00:00	DIA	ETF	123.34	123.62	123.3	123.47	90200.0
2008-06-17 09:00:00	DIA	ETF	123.54	123.61	122.82	122.93	1941105.0
2008-06-17 10:00:00	DIA	ETF	122.94	123.11	122.5	122.69	3546394.0
2008-06-17 11:00:00	DIA	ETF	122.69	122.86	122.04	122.14	2057564.0

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

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