PREVIEW / etf_1hour / 2007-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-12.parquet
  size:    96 KB
  rows:    3,202

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-11-12 04:00:00	SPY	ETF	145.42	145.42	145.42	145.42	200.0
2007-11-12 05:00:00	SPY	ETF	145.66	145.66	145.66	145.66	500.0
2007-11-12 06:00:00	SPY	ETF	145.22	145.55	145.04	145.44	253500.0
2007-11-12 07:00:00	SPY	ETF	145.34	145.59	144.82	145.33	2316700.0
2007-11-12 08:00:00	SPY	ETF	145.29	145.52	144.6	145.38	1278600.0
2007-11-12 09:00:00	SPY	ETF	145.38	145.98	144.74	145.63	40192849.0
2007-11-12 10:00:00	SPY	ETF	145.64	146.18	144.99	146.1	37253246.0
2007-11-12 11:00:00	SPY	ETF	146.09	146.57	145.37	145.91	34503203.0
2007-11-12 12:00:00	SPY	ETF	145.91	146.61	145.89	146.03	13764464.0
2007-11-12 13:00:00	SPY	ETF	146.04	146.22	145.17	145.41	26194156.0
2007-11-12 14:00:00	SPY	ETF	145.41	146.19	145.03	145.78	25237227.0
2007-11-12 15:00:00	SPY	ETF	145.78	145.79	143.93	143.99	49441825.0
2007-11-12 16:00:00	SPY	ETF	143.97	145.8618	143.44	143.5	8533200.0
2007-11-12 17:00:00	SPY	ETF	143.51	143.7	143.44	143.5	1144500.0
2007-11-12 18:00:00	SPY	ETF	143.54	143.73	143.5	143.73	78600.0
2007-11-12 19:00:00	SPY	ETF	143.65	143.93	143.56	143.9	47800.0
2007-11-12 05:00:00	QQQ	ETF	50.11	50.12	49.93	49.93	1297.0
2007-11-12 06:00:00	QQQ	ETF	49.95	50.18	49.92	50.15	489300.0
2007-11-12 07:00:00	QQQ	ETF	50.15	50.17	49.92	49.97	1595136.0
2007-11-12 08:00:00	QQQ	ETF	49.94	50.12	49.83	49.94	1924716.0
2007-11-12 09:00:00	QQQ	ETF	49.96	50.24	49.6	49.9985	33144978.0
2007-11-12 10:00:00	QQQ	ETF	50.0	50.09	49.6	50.02	38917809.0
2007-11-12 11:00:00	QQQ	ETF	50.02	50.24	49.8	49.8601	33716513.0
2007-11-12 12:00:00	QQQ	ETF	49.86	50.13	49.79	49.8	15661802.0
2007-11-12 13:00:00	QQQ	ETF	49.81	49.9	49.29	49.39	37359241.0
2007-11-12 14:00:00	QQQ	ETF	49.38	49.68	49.12	49.49	40673259.0
2007-11-12 15:00:00	QQQ	ETF	49.48	49.51	48.65	48.75	72367411.0
2007-11-12 16:00:00	QQQ	ETF	48.76	50.21	48.61	48.64	6467573.0
2007-11-12 17:00:00	QQQ	ETF	48.62	48.71	48.59	48.62	283094.0
2007-11-12 18:00:00	QQQ	ETF	48.63	48.72	48.63	48.66	569495.0
2007-11-12 19:00:00	QQQ	ETF	48.69	48.74	48.65	48.68	49402.0
2007-11-12 05:00:00	IWM	ETF	76.82	76.82	76.82	76.82	200.0
2007-11-12 06:00:00	IWM	ETF	76.83	77.03	76.83	77.03	400.0
2007-11-12 07:00:00	IWM	ETF	77.09	77.14	76.83	76.98	201800.0
2007-11-12 08:00:00	IWM	ETF	77.0	77.0	76.8	76.99	203700.0
2007-11-12 09:00:00	IWM	ETF	76.98	77.5	76.5	77.26	13305442.0
2007-11-12 10:00:00	IWM	ETF	77.26	77.68	76.78	77.65	24640340.0
2007-11-12 11:00:00	IWM	ETF	77.64	78.11	76.55	77.55	18273906.0
2007-11-12 12:00:00	IWM	ETF	77.55	77.97	77.47	77.69	8997429.0
2007-11-12 13:00:00	IWM	ETF	77.7	77.72	77.02	77.16	11184520.0
2007-11-12 14:00:00	IWM	ETF	77.16	77.48	76.89	77.23	10098735.0
2007-11-12 15:00:00	IWM	ETF	77.23	77.26	76.21	76.28	18225339.0
2007-11-12 16:00:00	IWM	ETF	76.28	77.22	75.9	75.95	3082300.0
2007-11-12 17:00:00	IWM	ETF	76.05	76.05	75.99	75.99	700.0
2007-11-12 18:00:00	IWM	ETF	76.0	76.0	75.92	75.92	53000.0
2007-11-12 19:00:00	IWM	ETF	75.92	76.1	75.92	76.1	1500.0
2007-11-12 07:00:00	DIA	ETF	130.6	130.6	130.33	130.39	53300.0
2007-11-12 08:00:00	DIA	ETF	130.49	130.59	130.33	130.5	77200.0
2007-11-12 09:00:00	DIA	ETF	130.51	131.07	130.14	130.88	2579561.0
2007-11-12 10:00:00	DIA	ETF	130.86	131.21	130.22	131.16	7455868.0

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

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