PREVIEW / etf_1hour / 2009-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-20.parquet
  size:    146 KB
  rows:    4,492

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-10-20 04:00:00	SPY	ETF	109.54	109.61	109.44	109.61	7600.0
2009-10-20 05:00:00	SPY	ETF	109.79	109.81	109.71	109.81	900.0
2009-10-20 06:00:00	SPY	ETF	109.86	109.86	109.68	109.68	14100.0
2009-10-20 07:00:00	SPY	ETF	109.71	110.36	109.71	110.17	870069.0
2009-10-20 08:00:00	SPY	ETF	110.14	110.19	109.45	109.89	4990489.0
2009-10-20 09:00:00	SPY	ETF	109.88	110.05	109.32	109.64	26824378.0
2009-10-20 10:00:00	SPY	ETF	109.64	109.77	109.21	109.6	28815837.0
2009-10-20 11:00:00	SPY	ETF	109.59	109.63	108.82	109.0008	21597784.0
2009-10-20 12:00:00	SPY	ETF	109.0099	109.1	108.68	108.91	21062568.0
2009-10-20 13:00:00	SPY	ETF	108.91	109.12	108.83	108.89	13957180.0
2009-10-20 14:00:00	SPY	ETF	108.88	109.8888	108.83	109.179	21095525.0
2009-10-20 15:00:00	SPY	ETF	109.18	109.5154	108.91	109.22	30881349.0
2009-10-20 16:00:00	SPY	ETF	109.22	109.8888	108.95	109.27	8629045.0
2009-10-20 17:00:00	SPY	ETF	109.27	109.8888	109.13	109.22	1623123.0
2009-10-20 18:00:00	SPY	ETF	109.25	109.35	109.24	109.25	20762.0
2009-10-20 19:00:00	SPY	ETF	109.25	109.35	109.22	109.3	76973.0
2009-10-20 04:00:00	QQQ	ETF	43.36	43.37	43.36	43.37	300.0
2009-10-20 05:00:00	QQQ	ETF	43.34	43.43	43.34	43.43	2100.0
2009-10-20 06:00:00	QQQ	ETF	43.46	43.46	43.4	43.41	2800.0
2009-10-20 07:00:00	QQQ	ETF	43.42	43.6	43.42	43.54	100432.0
2009-10-20 08:00:00	QQQ	ETF	43.54	43.58	43.21	43.21	1465991.0
2009-10-20 09:00:00	QQQ	ETF	43.47	43.55	43.16	43.32	20701250.0
2009-10-20 10:00:00	QQQ	ETF	43.32	43.4	43.13	43.3501	13864327.0
2009-10-20 11:00:00	QQQ	ETF	43.35	43.37	43.05	43.1	9770374.0
2009-10-20 12:00:00	QQQ	ETF	43.11	43.13	42.94	43.03	11311405.0
2009-10-20 13:00:00	QQQ	ETF	43.02	43.16	43.02	43.0676	5716623.0
2009-10-20 14:00:00	QQQ	ETF	43.06	43.2325	43.042	43.1801	8542142.0
2009-10-20 15:00:00	QQQ	ETF	43.19	43.24	43.09	43.22	13235644.0
2009-10-20 16:00:00	QQQ	ETF	43.22	43.32	43.1325	43.26	3669760.0
2009-10-20 17:00:00	QQQ	ETF	43.25	43.26	43.19	43.22	104849.0
2009-10-20 18:00:00	QQQ	ETF	43.23	43.26	43.23	43.25	46139.0
2009-10-20 19:00:00	QQQ	ETF	43.24	43.27	43.23	43.27	22984.0
2009-10-20 04:00:00	IWM	ETF	62.4	62.4	62.4	62.4	1000.0
2009-10-20 06:00:00	IWM	ETF	62.1	62.1	62.1	62.1	700.0
2009-10-20 07:00:00	IWM	ETF	62.07	62.59	62.07	62.42	37300.0
2009-10-20 08:00:00	IWM	ETF	61.86	62.47	61.86	62.25	534033.0
2009-10-20 09:00:00	IWM	ETF	62.24	62.39	61.61	61.86	7551410.0
2009-10-20 10:00:00	IWM	ETF	61.86	62.02	61.54	61.76	8478218.0
2009-10-20 11:00:00	IWM	ETF	61.76	61.82	61.25	61.32	4371558.0
2009-10-20 12:00:00	IWM	ETF	61.32	61.35	60.99	61.11	5335747.0
2009-10-20 13:00:00	IWM	ETF	61.115	61.37	61.11	61.18	2811904.0
2009-10-20 14:00:00	IWM	ETF	61.18	61.479	61.14	61.3625	4535430.0
2009-10-20 15:00:00	IWM	ETF	61.36	61.49	61.21	61.33	7067418.0
2009-10-20 16:00:00	IWM	ETF	61.33	62.2641	61.33	62.2641	1933216.0
2009-10-20 17:00:00	IWM	ETF	61.46	61.48	61.35	61.35	21484.0
2009-10-20 18:00:00	IWM	ETF	61.44	61.45	61.44	61.45	400.0
2009-10-20 19:00:00	IWM	ETF	61.43	61.43	61.34	61.34	1300.0
2009-10-20 06:00:00	DIA	ETF	100.8	100.8	100.75	100.75	200.0
2009-10-20 07:00:00	DIA	ETF	100.98	101.2	100.98	101.08	8200.0
2009-10-20 08:00:00	DIA	ETF	101.08	101.18	100.75	100.91	100894.0

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

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