PREVIEW / etf_1hour / 2009-02-10

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-10.parquet
  size:    128 KB
  rows:    3,937

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-10 04:00:00	SPY	ETF	85.87	85.93	85.8	85.8	5400.0
2009-02-10 05:00:00	SPY	ETF	85.91	86.06	85.9	85.99	7100.0
2009-02-10 06:00:00	SPY	ETF	85.98	86.24	85.95	86.15	40500.0
2009-02-10 07:00:00	SPY	ETF	86.14	86.78	86.08	86.72	734149.0
2009-02-10 08:00:00	SPY	ETF	86.71	86.76	85.63	86.11	3592285.0
2009-02-10 09:00:00	SPY	ETF	86.11	87.03	86.05	86.62	27894435.0
2009-02-10 10:00:00	SPY	ETF	86.62	86.83	85.78	86.15	46011085.0
2009-02-10 11:00:00	SPY	ETF	86.14	86.7	83.66	84.18	146059921.0
2009-02-10 12:00:00	SPY	ETF	84.19	84.49	83.87	84.31	50227716.0
2009-02-10 13:00:00	SPY	ETF	84.31	84.33	83.12	83.4192	60344635.0
2009-02-10 14:00:00	SPY	ETF	83.41	83.69	82.77	82.84	49821553.0
2009-02-10 15:00:00	SPY	ETF	82.84	84.8	82.45	82.96	103521001.0
2009-02-10 16:00:00	SPY	ETF	82.97	87.1818	82.73	83.14	26866779.0
2009-02-10 17:00:00	SPY	ETF	83.12	87.1795	83.1	83.18	19775006.0
2009-02-10 18:00:00	SPY	ETF	83.17	83.4	83.16	83.36	124191.0
2009-02-10 19:00:00	SPY	ETF	83.35	83.6	83.32	83.45	148172.0
2009-02-10 04:00:00	QQQ	ETF	31.12	31.16	31.12	31.16	1093.0
2009-02-10 05:00:00	QQQ	ETF	31.14	31.14	31.14	31.14	300.0
2009-02-10 06:00:00	QQQ	ETF	31.18	31.22	31.18	31.22	1193.0
2009-02-10 07:00:00	QQQ	ETF	31.26	31.45	31.26	31.41	92376.0
2009-02-10 08:00:00	QQQ	ETF	31.4	31.43	31.17	31.17	1016278.0
2009-02-10 09:00:00	QQQ	ETF	31.17	31.68	31.16	31.53	14937685.0
2009-02-10 10:00:00	QQQ	ETF	31.54	31.6	31.19	31.24	27305896.0
2009-02-10 11:00:00	QQQ	ETF	31.24	31.34	30.36	30.62	77314985.0
2009-02-10 12:00:00	QQQ	ETF	30.63	30.7899	30.53	30.68	18756535.0
2009-02-10 13:00:00	QQQ	ETF	30.68	30.69	30.29	30.3711	17978742.0
2009-02-10 14:00:00	QQQ	ETF	30.37	30.48	30.12	30.18	19794707.0
2009-02-10 15:00:00	QQQ	ETF	30.18	30.42	30.1	30.33	36313753.0
2009-02-10 16:00:00	QQQ	ETF	30.3399	30.45	30.1	30.33	5715789.0
2009-02-10 17:00:00	QQQ	ETF	30.33	30.35	30.3	30.33	149286.0
2009-02-10 18:00:00	QQQ	ETF	30.34	30.4	30.33	30.37	69231.0
2009-02-10 19:00:00	QQQ	ETF	30.37	30.47	30.37	30.43	74692.0
2009-02-10 07:00:00	IWM	ETF	46.44	46.69	46.35	46.69	6032.0
2009-02-10 08:00:00	IWM	ETF	46.25	46.68	46.25	46.36	40304.0
2009-02-10 09:00:00	IWM	ETF	46.37	47.1	46.35	46.88	4358709.0
2009-02-10 10:00:00	IWM	ETF	46.89	46.98	46.26	46.58	8967603.0
2009-02-10 11:00:00	IWM	ETF	46.58	46.87	45.02	45.44	23984682.0
2009-02-10 12:00:00	IWM	ETF	45.45	45.65	45.25	45.5225	5130521.0
2009-02-10 13:00:00	IWM	ETF	45.52	45.53	44.98	45.11	9510404.0
2009-02-10 14:00:00	IWM	ETF	45.11	45.31	44.51	44.54	8463277.0
2009-02-10 15:00:00	IWM	ETF	44.54	47.0	44.45	44.58	18487587.0
2009-02-10 16:00:00	IWM	ETF	44.59	45.82	44.59	44.84	851004.0
2009-02-10 17:00:00	IWM	ETF	44.82	46.7499	44.8	44.8	1009141.0
2009-02-10 18:00:00	IWM	ETF	44.82	44.82	44.74	44.74	600.0
2009-02-10 07:00:00	DIA	ETF	82.28	82.62	82.28	82.62	8676.0
2009-02-10 08:00:00	DIA	ETF	82.53	82.53	82.09	82.09	28067.0
2009-02-10 09:00:00	DIA	ETF	82.13	82.73	82.05	82.35	2674962.0
2009-02-10 10:00:00	DIA	ETF	82.34	82.51	81.66	81.96	5058987.0
2009-02-10 11:00:00	DIA	ETF	81.96	82.44	79.65	80.04	13786635.0
2009-02-10 12:00:00	DIA	ETF	80.04	80.28	79.82	80.13	3664381.0

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

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