PREVIEW / etf_1hour / 2008-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-20.parquet
  size:    103 KB
  rows:    3,409

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-03-20 04:00:00	SPY	ETF	129.65	129.77	129.65	129.77	1000.0
2008-03-20 05:00:00	SPY	ETF	129.91	130.36	129.87	130.33	77200.0
2008-03-20 06:00:00	SPY	ETF	130.25	130.4	129.9	129.9	53900.0
2008-03-20 07:00:00	SPY	ETF	129.94	130.47	129.85	130.29	2783900.0
2008-03-20 08:00:00	SPY	ETF	130.32	130.37	128.55	129.42	7342650.0
2008-03-20 09:00:00	SPY	ETF	129.44	130.4	129.26	130.07	30190923.0
2008-03-20 10:00:00	SPY	ETF	130.0706	131.33	130.03	131.19	42388978.0
2008-03-20 11:00:00	SPY	ETF	131.19	131.39	130.51	130.6	28712577.0
2008-03-20 12:00:00	SPY	ETF	130.59	131.21	130.33	130.59	24076010.0
2008-03-20 13:00:00	SPY	ETF	130.59	131.62	130.58	131.54	17172353.0
2008-03-20 14:00:00	SPY	ETF	131.53	132.42	131.35	132.36	27738873.0
2008-03-20 15:00:00	SPY	ETF	132.35	132.91	132.12	132.73	42302438.0
2008-03-20 16:00:00	SPY	ETF	132.703	132.75	128.58	132.23	10116740.0
2008-03-20 17:00:00	SPY	ETF	132.23	132.28	132.08	132.1	2231700.0
2008-03-20 18:00:00	SPY	ETF	132.1	132.27	129.64	132.21	2048100.0
2008-03-20 19:00:00	SPY	ETF	132.2	132.2	132.12	132.2	9800.0
2008-03-20 04:00:00	QQQ	ETF	42.33	42.33	42.33	42.33	500.0
2008-03-20 05:00:00	QQQ	ETF	42.33	42.36	42.26	42.36	105100.0
2008-03-20 06:00:00	QQQ	ETF	42.4	42.42	42.35	42.35	20840.0
2008-03-20 07:00:00	QQQ	ETF	42.35	42.48	42.33	42.37	160303.0
2008-03-20 08:00:00	QQQ	ETF	42.41	42.5	42.13	42.21	3697471.0
2008-03-20 09:00:00	QQQ	ETF	42.22	42.4	42.1	42.36	16913377.0
2008-03-20 10:00:00	QQQ	ETF	42.3699	42.56	42.25	42.5381	22617941.0
2008-03-20 11:00:00	QQQ	ETF	42.53	42.58	42.29	42.34	13811881.0
2008-03-20 12:00:00	QQQ	ETF	42.33	42.55	42.27	42.32	11493154.0
2008-03-20 13:00:00	QQQ	ETF	42.32	42.78	42.31	42.7	13924199.0
2008-03-20 14:00:00	QQQ	ETF	42.71	42.92	42.57	42.9	17115191.0
2008-03-20 15:00:00	QQQ	ETF	42.89	43.1	42.81	43.09	21551411.0
2008-03-20 16:00:00	QQQ	ETF	43.0906	43.1	42.77	42.9	5588206.0
2008-03-20 17:00:00	QQQ	ETF	42.9	42.92	42.88	42.89	60630.0
2008-03-20 18:00:00	QQQ	ETF	42.9	42.93	42.89	42.92	28695.0
2008-03-20 19:00:00	QQQ	ETF	42.92	42.93	42.89	42.9	28154.0
2008-03-20 05:00:00	IWM	ETF	66.25	66.5	66.25	66.5	300.0
2008-03-20 06:00:00	IWM	ETF	66.63	66.65	66.5	66.5	70000.0
2008-03-20 07:00:00	IWM	ETF	66.52	66.55	66.4	66.55	142900.0
2008-03-20 08:00:00	IWM	ETF	66.6	66.6	66.09	66.1	559500.0
2008-03-20 09:00:00	IWM	ETF	66.11	67.3	66.08	67.16	13416089.0
2008-03-20 10:00:00	IWM	ETF	67.17	67.47	66.45	67.4	19793274.0
2008-03-20 11:00:00	IWM	ETF	67.39	67.64	66.98	67.2	10519072.0
2008-03-20 12:00:00	IWM	ETF	67.19	67.45	66.75	66.87	7305890.0
2008-03-20 13:00:00	IWM	ETF	66.87	67.55	66.86	67.49	6651489.0
2008-03-20 14:00:00	IWM	ETF	67.49	67.96	67.34	67.91	12166621.0
2008-03-20 15:00:00	IWM	ETF	67.89	68.1	67.61	67.95	19046312.0
2008-03-20 16:00:00	IWM	ETF	67.94	68.09	67.35	67.65	9776209.0
2008-03-20 17:00:00	IWM	ETF	67.6	67.65	67.52	67.64	4600.0
2008-03-20 18:00:00	IWM	ETF	67.64	67.7	67.6	67.7	800.0
2008-03-20 19:00:00	IWM	ETF	67.93	67.93	67.93	67.93	1000000.0
2008-03-20 07:00:00	DIA	ETF	121.63	121.67	121.63	121.67	1500.0
2008-03-20 08:00:00	DIA	ETF	121.62	121.63	120.92	120.98	68100.0
2008-03-20 09:00:00	DIA	ETF	120.95	121.68	120.9	121.45	1691580.0

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

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