PREVIEW / etf_1hour / 2009-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-06.parquet
  size:    127 KB
  rows:    3,871

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-02-06 04:00:00	SPY	ETF	84.25	84.52	84.25	84.5	2700.0
2009-02-06 05:00:00	SPY	ETF	84.5	84.5	84.5	84.5	2500.0
2009-02-06 06:00:00	SPY	ETF	84.62	84.78	84.49	84.73	38300.0
2009-02-06 07:00:00	SPY	ETF	84.7	84.8	84.42	84.62	593365.0
2009-02-06 08:00:00	SPY	ETF	84.62	85.26	84.1	85.08	12881387.0
2009-02-06 09:00:00	SPY	ETF	85.08	86.32	84.68	86.17	53938568.0
2009-02-06 10:00:00	SPY	ETF	86.18	87.0069	85.79	86.13	44259642.0
2009-02-06 11:00:00	SPY	ETF	86.14	86.65	86.13	86.52	31220670.0
2009-02-06 12:00:00	SPY	ETF	86.52	86.61	86.15	86.49	27494026.0
2009-02-06 13:00:00	SPY	ETF	86.4818	87.27	86.38	87.13	38041559.0
2009-02-06 14:00:00	SPY	ETF	87.13	87.28	86.66	86.86	45736537.0
2009-02-06 15:00:00	SPY	ETF	86.86	87.34	86.41	86.96	75633536.0
2009-02-06 16:00:00	SPY	ETF	86.99	87.32	86.89	87.2	15764593.0
2009-02-06 17:00:00	SPY	ETF	87.18	87.35	87.1	87.3	2536106.0
2009-02-06 18:00:00	SPY	ETF	87.33	87.74	87.2	87.67	207731.0
2009-02-06 19:00:00	SPY	ETF	87.65	87.68	87.55	87.59	62397.0
2009-02-06 06:00:00	QQQ	ETF	30.61	30.61	30.61	30.61	200.0
2009-02-06 07:00:00	QQQ	ETF	30.63	30.63	30.49	30.56	126117.0
2009-02-06 08:00:00	QQQ	ETF	30.55	30.74	30.41	30.69	3362399.0
2009-02-06 09:00:00	QQQ	ETF	30.68	31.22	30.58	31.159	36242276.0
2009-02-06 10:00:00	QQQ	ETF	31.16	31.21	30.96	31.1	18463979.0
2009-02-06 11:00:00	QQQ	ETF	31.1099	31.3	31.1	31.26	14421950.0
2009-02-06 12:00:00	QQQ	ETF	31.26	31.3	31.12	31.25	12938399.0
2009-02-06 13:00:00	QQQ	ETF	31.25	31.51	31.21	31.461	19174019.0
2009-02-06 14:00:00	QQQ	ETF	31.47	31.51	31.3	31.38	21426737.0
2009-02-06 15:00:00	QQQ	ETF	31.39	31.51	31.2	31.36	32233955.0
2009-02-06 16:00:00	QQQ	ETF	31.36	31.4712	31.33	31.37	3985666.0
2009-02-06 17:00:00	QQQ	ETF	31.37	31.42	31.36	31.41	57471.0
2009-02-06 18:00:00	QQQ	ETF	31.42	31.49	31.42	31.47	27792.0
2009-02-06 19:00:00	QQQ	ETF	31.48	31.5	31.45	31.5	26750.0
2009-02-06 06:00:00	IWM	ETF	45.38	45.38	45.38	45.38	1000.0
2009-02-06 07:00:00	IWM	ETF	45.35	45.41	45.21	45.22	32422.0
2009-02-06 08:00:00	IWM	ETF	45.28	45.55	45.04	45.52	1333711.0
2009-02-06 09:00:00	IWM	ETF	45.5	46.48	45.21	46.38	7738159.0
2009-02-06 10:00:00	IWM	ETF	46.38	46.47	45.99	46.17	5963879.0
2009-02-06 11:00:00	IWM	ETF	46.17	46.47	46.17	46.38	4954438.0
2009-02-06 12:00:00	IWM	ETF	46.382	46.65	46.23	46.59	4966890.0
2009-02-06 13:00:00	IWM	ETF	46.59	47.17	46.52	46.97	8783210.0
2009-02-06 14:00:00	IWM	ETF	46.99	47.11	46.74	46.89	5681249.0
2009-02-06 15:00:00	IWM	ETF	46.89	47.03	46.65	46.98	9710977.0
2009-02-06 16:00:00	IWM	ETF	46.97	47.09	45.466	45.466	3350001.0
2009-02-06 17:00:00	IWM	ETF	47.02	47.02	47.02	47.02	900.0
2009-02-06 18:00:00	IWM	ETF	47.19	47.81	47.19	47.81	710.0
2009-02-06 19:00:00	IWM	ETF	47.63	47.63	47.26	47.26	1300.0
2009-02-06 06:00:00	DIA	ETF	80.56	80.67	80.49	80.58	18853.0
2009-02-06 07:00:00	DIA	ETF	80.61	80.61	80.54	80.54	1100.0
2009-02-06 08:00:00	DIA	ETF	80.52	81.12	80.15	81.03	382081.0
2009-02-06 09:00:00	DIA	ETF	81.03	82.34	80.72	82.25	5215573.0
2009-02-06 10:00:00	DIA	ETF	82.24	82.46	81.93	82.28	4671793.0
2009-02-06 11:00:00	DIA	ETF	82.29	82.75	82.29	82.6407	2977244.0

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

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