PREVIEW / etf_1hour / 2009-10-19

all etf 1-hour files

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

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-19 04:00:00	SPY	ETF	109.28	109.28	109.23	109.23	2700.0
2009-10-19 05:00:00	SPY	ETF	109.25	109.3	109.25	109.25	30453.0
2009-10-19 06:00:00	SPY	ETF	109.25	109.27	109.2	109.27	32299.0
2009-10-19 07:00:00	SPY	ETF	109.27	109.37	109.22	109.28	468783.0
2009-10-19 08:00:00	SPY	ETF	109.28	109.43	108.0	109.2	1603054.0
2009-10-19 09:00:00	SPY	ETF	109.2	109.24	108.73	108.8284	16724526.0
2009-10-19 10:00:00	SPY	ETF	108.8299	109.75	108.78	109.59	29648059.0
2009-10-19 11:00:00	SPY	ETF	109.59	110.03	109.56	109.97	20295728.0
2009-10-19 12:00:00	SPY	ETF	109.97	109.99	109.83	109.91	9432102.0
2009-10-19 13:00:00	SPY	ETF	109.9	110.13	109.79	109.9617	16503493.0
2009-10-19 14:00:00	SPY	ETF	109.97	110.13	109.9	110.049	13280017.0
2009-10-19 15:00:00	SPY	ETF	110.05	110.07	109.78	109.84	24178926.0
2009-10-19 16:00:00	SPY	ETF	109.84	110.15	108.79	110.03	16025606.0
2009-10-19 17:00:00	SPY	ETF	110.02	110.1	109.93	110.0	849820.0
2009-10-19 18:00:00	SPY	ETF	109.98	110.03	109.9	109.94	89834.0
2009-10-19 19:00:00	SPY	ETF	109.93	110.06	109.93	110.06	93468.0
2009-10-19 04:00:00	QQQ	ETF	42.89	42.89	42.88	42.88	17578.0
2009-10-19 05:00:00	QQQ	ETF	42.9	42.93	42.9	42.91	4024.0
2009-10-19 06:00:00	QQQ	ETF	42.9	42.94	42.9	42.91	23004.0
2009-10-19 07:00:00	QQQ	ETF	42.9	42.95	42.9	42.93	298840.0
2009-10-19 08:00:00	QQQ	ETF	42.93	42.93	42.3	42.86	439811.0
2009-10-19 09:00:00	QQQ	ETF	42.87	42.9	42.63	42.67	10603025.0
2009-10-19 10:00:00	QQQ	ETF	42.67	43.04	42.59	42.98	16760054.0
2009-10-19 11:00:00	QQQ	ETF	42.98	43.26	42.95	43.2215	13761951.0
2009-10-19 12:00:00	QQQ	ETF	43.23	43.24	43.14	43.17	3834243.0
2009-10-19 13:00:00	QQQ	ETF	43.17	43.238	43.09	43.13	5697424.0
2009-10-19 14:00:00	QQQ	ETF	43.13	43.18	43.07	43.14	5749625.0
2009-10-19 15:00:00	QQQ	ETF	43.14	43.27	43.09	43.21	18020824.0
2009-10-19 16:00:00	QQQ	ETF	43.21	43.68	43.07	43.64	7309276.0
2009-10-19 17:00:00	QQQ	ETF	43.63	43.66	43.56	43.59	448227.0
2009-10-19 18:00:00	QQQ	ETF	43.58	43.58	43.21	43.54	153338.0
2009-10-19 19:00:00	QQQ	ETF	43.54	43.58	43.53	43.57	33897.0
2009-10-19 06:00:00	IWM	ETF	61.97	62.05	61.97	62.05	200.0
2009-10-19 07:00:00	IWM	ETF	62.04	62.15	62.02	62.07	7793.0
2009-10-19 08:00:00	IWM	ETF	61.84	62.18	61.0	61.97	347165.0
2009-10-19 09:00:00	IWM	ETF	61.98	62.0	61.38	61.44	4722960.0
2009-10-19 10:00:00	IWM	ETF	61.44	62.01	61.38	61.9	7079554.0
2009-10-19 11:00:00	IWM	ETF	61.91	62.52	61.65	62.47	5820397.0
2009-10-19 12:00:00	IWM	ETF	62.462	62.49	62.31	62.33	2381211.0
2009-10-19 13:00:00	IWM	ETF	62.34	62.49	62.23	62.32	4480020.0
2009-10-19 14:00:00	IWM	ETF	62.33	62.455	62.3	62.435	3052827.0
2009-10-19 15:00:00	IWM	ETF	62.43	62.46	62.15	62.19	7148116.0
2009-10-19 16:00:00	IWM	ETF	62.19	62.46	61.6479	62.44	2903436.0
2009-10-19 17:00:00	IWM	ETF	62.44	62.46	62.2	62.3	179742.0
2009-10-19 18:00:00	IWM	ETF	62.35	62.39	62.28	62.35	2700.0
2009-10-19 19:00:00	IWM	ETF	62.39	62.39	62.34	62.39	1100.0
2009-10-19 07:00:00	DIA	ETF	100.22	100.31	100.22	100.31	200.0
2009-10-19 08:00:00	DIA	ETF	100.2	100.3	100.16	100.18	12118.0
2009-10-19 09:00:00	DIA	ETF	100.16	100.25	99.93	100.02	1086772.0
2009-10-19 10:00:00	DIA	ETF	100.03	100.855	99.98	100.76	2475315.0

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

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