PREVIEW / etf_1hour / 2009-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-15.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-15 04:00:00	SPY	ETF	109.2	109.2	109.2	109.2	100.0
2009-10-15 05:00:00	SPY	ETF	109.28	109.28	109.28	109.28	2000.0
2009-10-15 06:00:00	SPY	ETF	109.3	109.3	109.19	109.22	13200.0
2009-10-15 07:00:00	SPY	ETF	109.3	109.45	108.69	108.72	1772826.0
2009-10-15 08:00:00	SPY	ETF	108.8	108.92	108.49	108.68	4818183.0
2009-10-15 09:00:00	SPY	ETF	108.68	109.22	108.68	109.219	20331031.0
2009-10-15 10:00:00	SPY	ETF	109.21	109.22	108.73	108.97	28916869.0
2009-10-15 11:00:00	SPY	ETF	108.97	109.13	108.81	109.02	15333306.0
2009-10-15 12:00:00	SPY	ETF	109.03	109.26	109.02	109.04	16365138.0
2009-10-15 13:00:00	SPY	ETF	109.04	109.24	108.98	109.168	9875859.0
2009-10-15 14:00:00	SPY	ETF	109.17	109.57	109.12	109.53	23354335.0
2009-10-15 15:00:00	SPY	ETF	109.52	109.7	109.28	109.63	32478240.0
2009-10-15 16:00:00	SPY	ETF	109.62	109.78	108.83	109.44	18403713.0
2009-10-15 17:00:00	SPY	ETF	109.43	109.63	109.43	109.51	124206.0
2009-10-15 18:00:00	SPY	ETF	109.5	109.6	109.5	109.51	16699.0
2009-10-15 19:00:00	SPY	ETF	109.51	109.6	109.51	109.59	63116.0
2009-10-15 04:00:00	QQQ	ETF	43.08	43.08	43.08	43.08	100.0
2009-10-15 06:00:00	QQQ	ETF	43.04	43.07	43.03	43.03	25390.0
2009-10-15 07:00:00	QQQ	ETF	43.04	43.07	42.84	42.86	244609.0
2009-10-15 08:00:00	QQQ	ETF	42.86	42.93	42.77	42.85	1424612.0
2009-10-15 09:00:00	QQQ	ETF	42.86	43.12	42.85	43.11	12009539.0
2009-10-15 10:00:00	QQQ	ETF	43.1101	43.12	42.87	42.94	15717831.0
2009-10-15 11:00:00	QQQ	ETF	42.94	42.99	42.88	42.979	9827663.0
2009-10-15 12:00:00	QQQ	ETF	42.97	43.05	42.93	42.9404	7038672.0
2009-10-15 13:00:00	QQQ	ETF	42.95	43.01	42.94	42.98	4790718.0
2009-10-15 14:00:00	QQQ	ETF	42.97	43.12	42.9079	43.085	9740636.0
2009-10-15 15:00:00	QQQ	ETF	43.09	43.12	42.98	43.08	14710422.0
2009-10-15 16:00:00	QQQ	ETF	43.08	43.21	42.95	43.07	8293757.0
2009-10-15 17:00:00	QQQ	ETF	43.06	43.13	43.04	43.08	359333.0
2009-10-15 18:00:00	QQQ	ETF	43.1	43.13	43.09	43.1	37404.0
2009-10-15 19:00:00	QQQ	ETF	43.09	43.17	43.09	43.17	56888.0
2009-10-15 07:00:00	IWM	ETF	62.28	62.28	61.87	61.89	158048.0
2009-10-15 08:00:00	IWM	ETF	61.9	61.97	61.76	61.9	228109.0
2009-10-15 09:00:00	IWM	ETF	61.91	62.245	61.85	62.24	3774506.0
2009-10-15 10:00:00	IWM	ETF	62.24	62.24	61.83	61.98	5456032.0
2009-10-15 11:00:00	IWM	ETF	61.99	62.08	61.87	62.04	2931086.0
2009-10-15 12:00:00	IWM	ETF	62.03	62.16	62.0	62.03	2798547.0
2009-10-15 13:00:00	IWM	ETF	62.03	62.17	61.95	62.11	2152343.0
2009-10-15 14:00:00	IWM	ETF	62.1	62.37	62.08	62.34	2776616.0
2009-10-15 15:00:00	IWM	ETF	62.35	62.45	62.0	62.34	7209184.0
2009-10-15 16:00:00	IWM	ETF	62.32	62.44	62.21	62.25	996492.0
2009-10-15 17:00:00	IWM	ETF	62.26	62.36	62.22	62.24	7713.0
2009-10-15 18:00:00	IWM	ETF	62.26	62.26	62.26	62.26	200.0
2009-10-15 19:00:00	IWM	ETF	62.3	62.3	62.3	62.3	100.0
2009-10-15 06:00:00	DIA	ETF	100.22	100.22	100.22	100.22	200.0
2009-10-15 07:00:00	DIA	ETF	100.17	100.17	99.83	99.83	23800.0
2009-10-15 08:00:00	DIA	ETF	99.88	99.98	99.69	99.78	65684.0
2009-10-15 09:00:00	DIA	ETF	99.8	100.2487	99.8	100.2487	776324.0
2009-10-15 10:00:00	DIA	ETF	100.23	100.23	99.84	100.02	1497594.0
2009-10-15 11:00:00	DIA	ETF	100.02	100.14	99.88	100.06	714967.0

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

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