PREVIEW / etf_1hour / 2007-05-10

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-10.parquet
  size:    76 KB
  rows:    2,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
2007-05-10 06:00:00	SPY	ETF	150.94	151.01	150.94	150.99	2500.0
2007-05-10 07:00:00	SPY	ETF	150.96	151.0	150.76	150.81	307500.0
2007-05-10 08:00:00	SPY	ETF	150.83	150.97	150.73	150.93	1430000.0
2007-05-10 09:00:00	SPY	ETF	150.93	150.93	150.55	150.79	13526626.0
2007-05-10 10:00:00	SPY	ETF	150.78	151.02	150.66	150.89	17181484.0
2007-05-10 11:00:00	SPY	ETF	150.89	150.89	149.96	149.97	23117430.0
2007-05-10 12:00:00	SPY	ETF	149.98	150.13	149.69	149.98	22151173.0
2007-05-10 13:00:00	SPY	ETF	149.98	150.0	149.44	149.79	23368202.0
2007-05-10 14:00:00	SPY	ETF	149.79	150.1	149.76	149.83	16544952.0
2007-05-10 15:00:00	SPY	ETF	149.84	149.84	149.27	149.33	25387963.0
2007-05-10 16:00:00	SPY	ETF	149.34	150.14	149.27	149.56	6080000.0
2007-05-10 17:00:00	SPY	ETF	149.53	149.6	149.47	149.58	1193500.0
2007-05-10 18:00:00	SPY	ETF	149.55	149.55	149.48	149.48	47000.0
2007-05-10 19:00:00	SPY	ETF	149.48	149.56	149.48	149.5	3900.0
2007-05-10 07:00:00	QQQ	ETF	46.69	46.73	46.65	46.66	173058.0
2007-05-10 08:00:00	QQQ	ETF	46.68	46.72	46.63	46.7	1573992.0
2007-05-10 09:00:00	QQQ	ETF	46.71	46.74	46.6	46.72	12267482.0
2007-05-10 10:00:00	QQQ	ETF	46.72	46.78	46.63	46.73	13741463.0
2007-05-10 11:00:00	QQQ	ETF	46.73	46.74	46.28	46.28	24956321.0
2007-05-10 12:00:00	QQQ	ETF	46.28	46.37	46.12	46.27	27723714.0
2007-05-10 13:00:00	QQQ	ETF	46.27	46.32	46.11	46.265	29152146.0
2007-05-10 14:00:00	QQQ	ETF	46.2699	46.42	46.26	46.29	16470905.0
2007-05-10 15:00:00	QQQ	ETF	46.29	46.29	46.07	46.11	25747333.0
2007-05-10 16:00:00	QQQ	ETF	46.12	46.24	46.11	46.18	13636893.0
2007-05-10 17:00:00	QQQ	ETF	46.18	46.26	46.17	46.22	202145.0
2007-05-10 18:00:00	QQQ	ETF	46.22	46.22	46.16	46.16	49460.0
2007-05-10 19:00:00	QQQ	ETF	46.18	46.21	46.15	46.21	15621.0
2007-05-10 07:00:00	IWM	ETF	82.55	82.55	82.43	82.43	4400.0
2007-05-10 08:00:00	IWM	ETF	82.35	82.46	82.3	82.45	420800.0
2007-05-10 09:00:00	IWM	ETF	82.41	82.41	81.93	82.19	9542400.0
2007-05-10 10:00:00	IWM	ETF	82.18	82.42	82.07	82.34	9232700.0
2007-05-10 11:00:00	IWM	ETF	82.34	82.34	81.59	81.64	16546739.0
2007-05-10 12:00:00	IWM	ETF	81.64	81.81	81.36	81.7	12958684.0
2007-05-10 13:00:00	IWM	ETF	81.7	81.8	81.35	81.71	9237276.0
2007-05-10 14:00:00	IWM	ETF	81.71	81.96	81.68	81.7	7744873.0
2007-05-10 15:00:00	IWM	ETF	81.7	81.71	81.25	81.38	17266895.0
2007-05-10 16:00:00	IWM	ETF	81.37	81.62	81.36	81.54	3156000.0
2007-05-10 17:00:00	IWM	ETF	81.59	81.62	81.5	81.58	25000.0
2007-05-10 18:00:00	IWM	ETF	81.57	81.58	81.56	81.56	13500.0
2007-05-10 19:00:00	IWM	ETF	81.56	81.56	81.56	81.56	100.0
2007-05-10 07:00:00	DIA	ETF	133.3	133.36	133.2	133.26	21500.0
2007-05-10 08:00:00	DIA	ETF	133.25	133.3	133.16	133.27	55900.0
2007-05-10 09:00:00	DIA	ETF	133.27	133.32	132.96	133.14	1489618.0
2007-05-10 10:00:00	DIA	ETF	133.13	133.39	133.08	133.32	1214807.0
2007-05-10 11:00:00	DIA	ETF	133.31	133.33	132.56	132.56	2189018.0
2007-05-10 12:00:00	DIA	ETF	132.56	132.71	132.33	132.63	2465699.0
2007-05-10 13:00:00	DIA	ETF	132.62	132.63	132.21	132.47	1854800.0
2007-05-10 14:00:00	DIA	ETF	132.47	132.79	132.47	132.63	1491300.0
2007-05-10 15:00:00	DIA	ETF	132.62	133.43	132.21	132.28	2173150.0
2007-05-10 16:00:00	DIA	ETF	132.28	132.5	132.28	132.45	146600.0

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

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