PREVIEW / etf_1hour / 2009-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-20.parquet
  size:    139 KB
  rows:    4,274

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
2009-08-20 04:00:00	SPY	ETF	100.67	100.77	100.67	100.76	2575.0
2009-08-20 05:00:00	SPY	ETF	100.71	100.71	100.65	100.65	2800.0
2009-08-20 06:00:00	SPY	ETF	100.63	100.63	100.45	100.54	77400.0
2009-08-20 07:00:00	SPY	ETF	100.56	100.59	100.28	100.59	778332.0
2009-08-20 08:00:00	SPY	ETF	100.57	100.75	100.05	100.14	8174696.0
2009-08-20 09:00:00	SPY	ETF	100.14	100.71	99.87	100.7	27938484.0
2009-08-20 10:00:00	SPY	ETF	100.7	100.93	100.39	100.79	32498851.0
2009-08-20 11:00:00	SPY	ETF	100.79	100.84	100.58	100.69	14736904.0
2009-08-20 12:00:00	SPY	ETF	100.69	100.88	100.62	100.78	13479443.0
2009-08-20 13:00:00	SPY	ETF	100.79	100.905	100.7	100.79	9200177.0
2009-08-20 14:00:00	SPY	ETF	100.79	100.88	100.67	100.79	18527757.0
2009-08-20 15:00:00	SPY	ETF	100.78	101.22	100.78	101.02	39977669.0
2009-08-20 16:00:00	SPY	ETF	101.02	101.117	99.99	100.91	7917251.0
2009-08-20 17:00:00	SPY	ETF	100.91	100.94	100.8	100.84	211375.0
2009-08-20 18:00:00	SPY	ETF	100.84	100.86	100.83	100.84	42468.0
2009-08-20 19:00:00	SPY	ETF	100.86	100.88	100.83	100.84	69044.0
2009-08-20 06:00:00	QQQ	ETF	39.45	39.48	39.45	39.48	7600.0
2009-08-20 07:00:00	QQQ	ETF	39.46	39.46	39.33	39.44	1284947.0
2009-08-20 08:00:00	QQQ	ETF	39.45	39.56	39.26	39.29	6246677.0
2009-08-20 09:00:00	QQQ	ETF	39.29	39.71	39.17	39.6996	13252576.0
2009-08-20 10:00:00	QQQ	ETF	39.7	39.75	39.52	39.63	12798909.0
2009-08-20 11:00:00	QQQ	ETF	39.64	39.67	39.54	39.559	6495958.0
2009-08-20 12:00:00	QQQ	ETF	39.56	39.68	39.55	39.65	5129437.0
2009-08-20 13:00:00	QQQ	ETF	39.65	39.71	39.62	39.66	3451467.0
2009-08-20 14:00:00	QQQ	ETF	39.65	39.6972	39.6	39.65	4647344.0
2009-08-20 15:00:00	QQQ	ETF	39.65	39.84	39.64	39.75	20176976.0
2009-08-20 16:00:00	QQQ	ETF	39.75	39.82	39.3014	39.73	5598719.0
2009-08-20 17:00:00	QQQ	ETF	39.72	39.73	39.71	39.72	21768.0
2009-08-20 18:00:00	QQQ	ETF	39.71	39.73	39.71	39.72	45706.0
2009-08-20 19:00:00	QQQ	ETF	39.72	39.72	39.7	39.71	15450.0
2009-08-20 06:00:00	IWM	ETF	56.46	56.52	56.46	56.52	4200.0
2009-08-20 07:00:00	IWM	ETF	56.5	56.55	56.33	56.52	39166.0
2009-08-20 08:00:00	IWM	ETF	56.51	56.6	56.14	56.17	820630.0
2009-08-20 09:00:00	IWM	ETF	56.17	56.68	55.86	56.63	4574863.0
2009-08-20 10:00:00	IWM	ETF	56.63	56.85	56.44	56.6	5404777.0
2009-08-20 11:00:00	IWM	ETF	56.61	56.64	56.35	56.39	4901286.0
2009-08-20 12:00:00	IWM	ETF	56.39	56.71	56.37	56.63	3569504.0
2009-08-20 13:00:00	IWM	ETF	56.6299	56.745	56.5	56.62	2847593.0
2009-08-20 14:00:00	IWM	ETF	56.62	56.73	56.56	56.67	3459467.0
2009-08-20 15:00:00	IWM	ETF	56.68	56.97	56.67	56.85	8353617.0
2009-08-20 16:00:00	IWM	ETF	56.85	56.94	56.81	56.83	2324763.0
2009-08-20 17:00:00	IWM	ETF	56.83	56.85	56.77	56.8	12061.0
2009-08-20 18:00:00	IWM	ETF	56.79	56.79	56.72	56.72	4100.0
2009-08-20 19:00:00	IWM	ETF	56.77	56.78	56.75	56.78	1700.0
2009-08-20 06:00:00	DIA	ETF	93.58	93.58	93.58	93.58	3000.0
2009-08-20 07:00:00	DIA	ETF	93.4	93.51	93.33	93.51	5300.0
2009-08-20 08:00:00	DIA	ETF	93.53	93.6	93.09	93.15	228954.0
2009-08-20 09:00:00	DIA	ETF	93.12	93.56	92.93	93.53	1620512.0
2009-08-20 10:00:00	DIA	ETF	93.54	93.65	93.23	93.5	1739360.0
2009-08-20 11:00:00	DIA	ETF	93.51	93.53	93.34	93.44	865968.0

> showing 50 of 4,274 rows — these rows as CSV

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