PREVIEW / etf_1hour / 2009-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-16.parquet
  size:    140 KB
  rows:    4,300

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-06-16 04:00:00	SPY	ETF	92.75	92.81	92.6	92.74	3800.0
2009-06-16 05:00:00	SPY	ETF	92.88	93.02	92.85	93.02	6700.0
2009-06-16 06:00:00	SPY	ETF	93.0	93.06	92.92	93.02	10029.0
2009-06-16 07:00:00	SPY	ETF	93.02	93.2	92.91	93.18	1055205.0
2009-06-16 08:00:00	SPY	ETF	93.055	93.34	93.02	93.17	4139922.0
2009-06-16 09:00:00	SPY	ETF	93.16	93.29	92.9	93.03	25207368.0
2009-06-16 10:00:00	SPY	ETF	93.03	93.28	92.83	93.09	26320380.0
2009-06-16 11:00:00	SPY	ETF	93.09	93.29	92.63	92.65	20460231.0
2009-06-16 12:00:00	SPY	ETF	92.6599	92.77	91.96	92.11	30231322.0
2009-06-16 13:00:00	SPY	ETF	92.11	92.12	91.75	91.95	24740322.0
2009-06-16 14:00:00	SPY	ETF	91.95	92.04	91.58	92.0	28161692.0
2009-06-16 15:00:00	SPY	ETF	92.01	92.29	91.61	91.66	44273406.0
2009-06-16 16:00:00	SPY	ETF	91.65	93.2	91.58	91.68	20824335.0
2009-06-16 17:00:00	SPY	ETF	91.66	91.68	91.53	91.65	177087.0
2009-06-16 18:00:00	SPY	ETF	91.6	91.66	91.53	91.61	198748.0
2009-06-16 19:00:00	SPY	ETF	91.61	91.64	91.53	91.63	125399.0
2009-06-16 04:00:00	QQQ	ETF	35.89	35.9	35.89	35.9	200.0
2009-06-16 05:00:00	QQQ	ETF	35.93	35.95	35.91	35.95	700.0
2009-06-16 06:00:00	QQQ	ETF	35.96	36.01	35.96	35.99	5200.0
2009-06-16 07:00:00	QQQ	ETF	36.04	36.09	36.02	36.09	469616.0
2009-06-16 08:00:00	QQQ	ETF	36.08	36.13	36.0	36.05	1593423.0
2009-06-16 09:00:00	QQQ	ETF	36.05	36.14	35.9	36.05	14082826.0
2009-06-16 10:00:00	QQQ	ETF	36.05	36.17	35.96	36.1115	13936403.0
2009-06-16 11:00:00	QQQ	ETF	36.12	36.19	35.96	35.9699	9145334.0
2009-06-16 12:00:00	QQQ	ETF	35.96	36.04	35.65	35.73	14694702.0
2009-06-16 13:00:00	QQQ	ETF	35.74	35.8	35.64	35.7199	14858227.0
2009-06-16 14:00:00	QQQ	ETF	35.72	35.75	35.55	35.74	14807769.0
2009-06-16 15:00:00	QQQ	ETF	35.732	35.79	35.52	35.54	21392006.0
2009-06-16 16:00:00	QQQ	ETF	35.55	36.11	35.53	35.59	4364732.0
2009-06-16 17:00:00	QQQ	ETF	35.59	35.59	35.55	35.55	175018.0
2009-06-16 18:00:00	QQQ	ETF	35.56	35.58	35.53	35.57	273930.0
2009-06-16 19:00:00	QQQ	ETF	35.57	35.59	35.53	35.57	17789.0
2009-06-16 06:00:00	IWM	ETF	51.61	51.66	51.61	51.66	2200.0
2009-06-16 07:00:00	IWM	ETF	51.66	51.72	51.56	51.71	2700.0
2009-06-16 08:00:00	IWM	ETF	51.71	51.8	51.56	51.7	453932.0
2009-06-16 09:00:00	IWM	ETF	51.72	51.84	51.5	51.61	4839506.0
2009-06-16 10:00:00	IWM	ETF	51.6	51.8	51.4	51.53	5947338.0
2009-06-16 11:00:00	IWM	ETF	51.54	51.66	51.2	51.22	4735258.0
2009-06-16 12:00:00	IWM	ETF	51.22	51.3	50.53	50.64	8615011.0
2009-06-16 13:00:00	IWM	ETF	50.63	51.45	50.48	50.63	3564264.0
2009-06-16 14:00:00	IWM	ETF	50.62	50.64	50.32	50.61	7114113.0
2009-06-16 15:00:00	IWM	ETF	50.61	50.82	50.47	50.47	9641454.0
2009-06-16 16:00:00	IWM	ETF	50.47	51.2974	50.47	50.55	2829665.0
2009-06-16 17:00:00	IWM	ETF	50.54	50.54	50.45	50.47	3600.0
2009-06-16 18:00:00	IWM	ETF	50.48	50.49	50.48	50.49	200.0
2009-06-16 19:00:00	IWM	ETF	50.48	50.48	50.46	50.46	200.0
2009-06-16 04:00:00	DIA	ETF	86.45	86.45	86.45	86.45	100.0
2009-06-16 07:00:00	DIA	ETF	86.6	86.62	86.53	86.53	1100.0
2009-06-16 08:00:00	DIA	ETF	86.67	86.79	86.56	86.64	33848.0
2009-06-16 09:00:00	DIA	ETF	86.67	86.76	86.3	86.4	1232861.0

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

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