PREVIEW / etf_1hour / 2007-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-20.parquet
  size:    86 KB
  rows:    2,881

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
2007-09-20 04:00:00	SPY	ETF	152.93	152.93	152.9	152.9	3200.0
2007-09-20 06:00:00	SPY	ETF	152.75	152.8	152.72	152.77	23700.0
2007-09-20 07:00:00	SPY	ETF	152.85	152.88	152.6	152.85	2003200.0
2007-09-20 08:00:00	SPY	ETF	152.77	153.29	152.65	153.22	8618300.0
2007-09-20 09:00:00	SPY	ETF	153.21	153.36	152.77	153.01	18068077.0
2007-09-20 10:00:00	SPY	ETF	153.01	153.43	152.85	153.08	21257100.0
2007-09-20 11:00:00	SPY	ETF	153.08	153.31	152.89	153.06	14196900.0
2007-09-20 12:00:00	SPY	ETF	153.06	153.33	152.85	153.05	17450300.0
2007-09-20 13:00:00	SPY	ETF	153.05	153.09	152.6	152.87	15667901.0
2007-09-20 14:00:00	SPY	ETF	152.88	153.3955	152.22	152.35	32684400.0
2007-09-20 15:00:00	SPY	ETF	152.35	152.69	152.11	152.33	27101400.0
2007-09-20 16:00:00	SPY	ETF	152.33	152.65	152.23	152.37	7634800.0
2007-09-20 17:00:00	SPY	ETF	152.34	152.34	152.11	152.2	110600.0
2007-09-20 18:00:00	SPY	ETF	152.17	152.38	152.16	152.23	347900.0
2007-09-20 19:00:00	SPY	ETF	152.22	152.37	152.19	152.37	2900.0
2007-09-20 07:00:00	QQQ	ETF	50.01	50.01	49.91	49.95	1190737.0
2007-09-20 08:00:00	QQQ	ETF	49.94	50.09	49.94	50.08	6973301.0
2007-09-20 09:00:00	QQQ	ETF	50.07	50.18	49.97	50.12	13827029.0
2007-09-20 10:00:00	QQQ	ETF	50.12	50.26	50.09	50.14	13498364.0
2007-09-20 11:00:00	QQQ	ETF	50.15	50.26	50.06	50.132	9176997.0
2007-09-20 12:00:00	QQQ	ETF	50.1301	50.25	50.1	50.19	5917772.0
2007-09-20 13:00:00	QQQ	ETF	50.195	50.2	50.04	50.15	6970549.0
2007-09-20 14:00:00	QQQ	ETF	50.14	50.17	49.92	49.9801	13207796.0
2007-09-20 15:00:00	QQQ	ETF	49.982	50.11	49.92	49.98	15309946.0
2007-09-20 16:00:00	QQQ	ETF	49.99	50.09	49.98	50.05	8128966.0
2007-09-20 17:00:00	QQQ	ETF	50.04	50.05	49.96	49.96	171857.0
2007-09-20 18:00:00	QQQ	ETF	49.97	50.02	49.97	50.0	17081.0
2007-09-20 19:00:00	QQQ	ETF	50.0	50.02	50.0	50.02	12067.0
2007-09-20 07:00:00	IWM	ETF	81.2	81.2	81.11	81.2	270000.0
2007-09-20 08:00:00	IWM	ETF	81.2	81.46	81.1	81.4	3017100.0
2007-09-20 09:00:00	IWM	ETF	81.4	81.5	80.83	81.25	13529543.0
2007-09-20 10:00:00	IWM	ETF	81.25	81.54	81.03	81.19	14432000.0
2007-09-20 11:00:00	IWM	ETF	81.19	81.37	81.02	81.14	4936800.0
2007-09-20 12:00:00	IWM	ETF	81.14	81.29	80.89	81.1	7463200.0
2007-09-20 13:00:00	IWM	ETF	81.1	81.11	80.78	80.99	6491700.0
2007-09-20 14:00:00	IWM	ETF	80.99	81.03	80.3	80.43	12141500.0
2007-09-20 15:00:00	IWM	ETF	80.42	80.94	80.25	80.79	16791400.0
2007-09-20 16:00:00	IWM	ETF	80.79	80.83	80.69	80.79	17737100.0
2007-09-20 17:00:00	IWM	ETF	80.79	80.79	80.69	80.69	34000.0
2007-09-20 18:00:00	IWM	ETF	80.71	80.74	80.71	80.74	12700.0
2007-09-20 20:00:00	IWM	ETF	80.76	80.76	80.76	80.76	1500.0
2007-09-20 07:00:00	DIA	ETF	137.73	137.81	137.65	137.77	4600.0
2007-09-20 08:00:00	DIA	ETF	137.81	138.21	137.81	138.21	32100.0
2007-09-20 09:00:00	DIA	ETF	138.22	138.29	137.88	138.03	3684607.0
2007-09-20 10:00:00	DIA	ETF	138.01	138.29	137.97	138.09	1860300.0
2007-09-20 11:00:00	DIA	ETF	138.09	138.31	137.97	138.1	863800.0
2007-09-20 12:00:00	DIA	ETF	138.1	138.29	137.94	138.1	909400.0
2007-09-20 13:00:00	DIA	ETF	138.11	138.14	137.83	138.0	714100.0
2007-09-20 14:00:00	DIA	ETF	138.0	138.04	137.63	137.64	941600.0
2007-09-20 15:00:00	DIA	ETF	137.65	137.95	137.53	137.75	1363800.0

> showing 50 of 2,881 rows — these rows as CSV

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