PREVIEW / etf_1hour / 2007-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-28.parquet
  size:    83 KB
  rows:    2,824

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-28 07:00:00	SPY	ETF	152.59	152.79	152.59	152.69	246000.0
2007-09-28 08:00:00	SPY	ETF	152.67	152.89	152.53	152.78	2668800.0
2007-09-28 09:00:00	SPY	ETF	152.74	153.15	152.62	152.99	11872785.0
2007-09-28 10:00:00	SPY	ETF	152.99	153.19	152.22	152.52	31624500.0
2007-09-28 11:00:00	SPY	ETF	152.52	152.72	152.395	152.49	10593900.0
2007-09-28 12:00:00	SPY	ETF	152.49	152.59	152.35	152.54	7618400.0
2007-09-28 13:00:00	SPY	ETF	152.54	152.81	152.52	152.8	9551400.0
2007-09-28 14:00:00	SPY	ETF	152.8	152.93	152.34	152.45	15305200.0
2007-09-28 15:00:00	SPY	ETF	152.45	152.51	151.98	152.47	28997600.0
2007-09-28 16:00:00	SPY	ETF	152.55	152.78	152.33	152.65	12239600.0
2007-09-28 17:00:00	SPY	ETF	152.66	152.73	152.58	152.69	49300.0
2007-09-28 18:00:00	SPY	ETF	152.66	152.84	152.62	152.65	2600.0
2007-09-28 19:00:00	SPY	ETF	152.64	152.65	152.61	152.64	3400.0
2007-09-28 07:00:00	QQQ	ETF	51.41	51.47	51.39	51.47	338577.0
2007-09-28 08:00:00	QQQ	ETF	51.43	51.61	51.43	51.54	1517055.0
2007-09-28 09:00:00	QQQ	ETF	51.54	51.68	51.38	51.631	8166437.0
2007-09-28 10:00:00	QQQ	ETF	51.63	51.68	51.32	51.42	17203438.0
2007-09-28 11:00:00	QQQ	ETF	51.42	51.46	51.36	51.41	6441838.0
2007-09-28 12:00:00	QQQ	ETF	51.41	51.44	51.34	51.41	5894331.0
2007-09-28 13:00:00	QQQ	ETF	51.41	51.51	51.39	51.5	8851121.0
2007-09-28 14:00:00	QQQ	ETF	51.5	51.54	51.27	51.32	8739783.0
2007-09-28 15:00:00	QQQ	ETF	51.32	51.42	51.18	51.4	14516242.0
2007-09-28 16:00:00	QQQ	ETF	51.41	51.49	51.3967	51.46	3742392.0
2007-09-28 17:00:00	QQQ	ETF	51.46	51.51	51.43	51.51	91957.0
2007-09-28 18:00:00	QQQ	ETF	51.52	51.58	51.45	51.57	31860.0
2007-09-28 19:00:00	QQQ	ETF	51.57	51.58	51.54	51.56	90363.0
2007-09-28 07:00:00	IWM	ETF	80.8	80.8	80.8	80.8	500.0
2007-09-28 08:00:00	IWM	ETF	80.86	80.97	80.81	80.93	205600.0
2007-09-28 09:00:00	IWM	ETF	80.89	81.25	80.88	81.1	8331200.0
2007-09-28 10:00:00	IWM	ETF	81.1	81.21	80.2	80.47	23117000.0
2007-09-28 11:00:00	IWM	ETF	80.47	80.6	80.37	80.53	5803600.0
2007-09-28 12:00:00	IWM	ETF	80.53	80.59	80.41	80.55	3069000.0
2007-09-28 13:00:00	IWM	ETF	80.56	80.85	80.49	80.76	5341900.0
2007-09-28 14:00:00	IWM	ETF	80.77	80.92	80.27	80.37	12163400.0
2007-09-28 15:00:00	IWM	ETF	80.37	80.38	79.93	80.07	29104500.0
2007-09-28 16:00:00	IWM	ETF	80.06	80.27	80.0	80.16	5717500.0
2007-09-28 17:00:00	IWM	ETF	80.04	80.15	80.04	80.1	70600.0
2007-09-28 19:00:00	IWM	ETF	80.17	80.17	80.17	80.17	36000.0
2007-09-28 07:00:00	DIA	ETF	138.76	138.8	138.75	138.8	4100.0
2007-09-28 08:00:00	DIA	ETF	138.76	139.02	138.7	138.94	23400.0
2007-09-28 09:00:00	DIA	ETF	138.85	139.09	138.85	138.98	624300.0
2007-09-28 10:00:00	DIA	ETF	138.98	139.09	138.41	138.63	1348600.0
2007-09-28 11:00:00	DIA	ETF	138.65	138.94	138.55	138.78	993400.0
2007-09-28 12:00:00	DIA	ETF	138.77	138.88	138.65	138.88	637400.0
2007-09-28 13:00:00	DIA	ETF	138.88	139.04	138.85	139.0	1117800.0
2007-09-28 14:00:00	DIA	ETF	139.01	139.1	138.72	138.81	1210900.0
2007-09-28 15:00:00	DIA	ETF	138.81	138.85	138.36	138.82	2663300.0
2007-09-28 16:00:00	DIA	ETF	138.85	139.01	138.75	138.96	1505200.0
2007-09-28 18:00:00	DIA	ETF	138.91	138.95	138.91	138.95	200.0
2007-09-28 07:00:00	GLD	ETF	73.08	73.12	72.97	73.12	10300.0

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

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