PREVIEW / etf_1hour / 2007-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-14.parquet
  size:    86 KB
  rows:    2,818

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-08-14 04:00:00	SPY	ETF	145.38	145.38	145.38	145.38	2000.0
2007-08-14 06:00:00	SPY	ETF	145.56	145.56	145.27	145.36	93600.0
2007-08-14 07:00:00	SPY	ETF	145.22	145.47	145.09	145.46	352300.0
2007-08-14 08:00:00	SPY	ETF	145.45	145.92	145.15	145.78	3980200.0
2007-08-14 09:00:00	SPY	ETF	145.78	146.06	145.1	145.44	25903512.0
2007-08-14 10:00:00	SPY	ETF	145.44	145.5	143.82	144.03	49012016.0
2007-08-14 11:00:00	SPY	ETF	144.03	144.8	143.3	144.53	37428925.0
2007-08-14 12:00:00	SPY	ETF	144.53	144.66	144.05	144.38	17441545.0
2007-08-14 13:00:00	SPY	ETF	144.38	144.44	143.45	143.68	18273840.0
2007-08-14 14:00:00	SPY	ETF	143.69	144.33	143.02	143.38	39791459.0
2007-08-14 15:00:00	SPY	ETF	143.38	144.14	142.75	142.77	58737395.0
2007-08-14 16:00:00	SPY	ETF	142.74	143.14	142.73	142.92	6000700.0
2007-08-14 17:00:00	SPY	ETF	142.9	143.09	142.89	143.09	728800.0
2007-08-14 18:00:00	SPY	ETF	143.03	143.03	142.82	142.9	168900.0
2007-08-14 19:00:00	SPY	ETF	142.85	142.91	142.8	142.89	30100.0
2007-08-14 07:00:00	QQQ	ETF	47.48	47.55	47.46	47.53	65044.0
2007-08-14 08:00:00	QQQ	ETF	47.52	47.7	47.45	47.66	1720132.0
2007-08-14 09:00:00	QQQ	ETF	47.67	47.74	47.53	47.66	12730446.0
2007-08-14 10:00:00	QQQ	ETF	47.67	47.6701	47.16	47.22	25647251.0
2007-08-14 11:00:00	QQQ	ETF	47.22	47.48	47.02	47.419	24966000.0
2007-08-14 12:00:00	QQQ	ETF	47.42	47.43	47.18	47.28	14582493.0
2007-08-14 13:00:00	QQQ	ETF	47.2715	47.34	47.0	47.09	11602294.0
2007-08-14 14:00:00	QQQ	ETF	47.08	47.12	46.84	46.95	18598607.0
2007-08-14 15:00:00	QQQ	ETF	46.96	47.17	46.75	46.75	28693081.0
2007-08-14 16:00:00	QQQ	ETF	46.76	46.86	46.73	46.8	6279671.0
2007-08-14 17:00:00	QQQ	ETF	46.79	46.85	46.75	46.81	129790.0
2007-08-14 18:00:00	QQQ	ETF	46.83	46.85	46.78	46.78	12735.0
2007-08-14 19:00:00	QQQ	ETF	46.8	46.8	46.76	46.78	15833.0
2007-08-14 06:00:00	IWM	ETF	77.84	77.84	77.84	77.84	1000.0
2007-08-14 07:00:00	IWM	ETF	77.73	77.91	77.72	77.9	4000.0
2007-08-14 08:00:00	IWM	ETF	77.9	78.08	77.8	78.01	400000.0
2007-08-14 09:00:00	IWM	ETF	78.01	78.18	77.66	77.93	8821315.0
2007-08-14 10:00:00	IWM	ETF	77.94	77.96	76.83	76.95	27051087.0
2007-08-14 11:00:00	IWM	ETF	76.95	77.47	76.54	77.28	16894553.0
2007-08-14 12:00:00	IWM	ETF	77.28	77.33	76.88	77.08	7042006.0
2007-08-14 13:00:00	IWM	ETF	77.09	77.32	76.6	76.74	7504842.0
2007-08-14 14:00:00	IWM	ETF	76.74	76.77	76.17	76.41	15371691.0
2007-08-14 15:00:00	IWM	ETF	76.41	76.98	75.96	75.96	22504872.0
2007-08-14 16:00:00	IWM	ETF	75.96	76.38	75.94	76.21	2697900.0
2007-08-14 17:00:00	IWM	ETF	78.08	78.08	76.17	76.25	350800.0
2007-08-14 18:00:00	IWM	ETF	76.26	76.26	76.21	76.21	10100.0
2007-08-14 19:00:00	IWM	ETF	76.22	76.22	76.22	76.22	1000.0
2007-08-14 07:00:00	DIA	ETF	132.35	132.35	132.3	132.3	6600.0
2007-08-14 08:00:00	DIA	ETF	132.22	132.73	132.1	132.63	189300.0
2007-08-14 09:00:00	DIA	ETF	132.7	132.9	132.1	132.29	2354900.0
2007-08-14 10:00:00	DIA	ETF	132.29	132.32	131.12	131.22	3437400.0
2007-08-14 11:00:00	DIA	ETF	131.21	131.73	130.68	131.6	3624900.0
2007-08-14 12:00:00	DIA	ETF	131.56	131.67	131.25	131.42	1696600.0
2007-08-14 13:00:00	DIA	ETF	131.43	131.55	130.75	130.95	1400900.0
2007-08-14 14:00:00	DIA	ETF	130.94	131.14	130.45	130.77	3473500.0

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

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