PREVIEW / etf_1hour / 2009-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-30.parquet
  size:    138 KB
  rows:    4,322

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-04-30 04:00:00	SPY	ETF	88.65	88.8	88.52	88.75	34700.0
2009-04-30 05:00:00	SPY	ETF	88.65	88.87	88.65	88.85	33253.0
2009-04-30 06:00:00	SPY	ETF	88.83	89.14	88.77	88.85	190806.0
2009-04-30 07:00:00	SPY	ETF	88.89	88.92	88.66	88.75	1160442.0
2009-04-30 08:00:00	SPY	ETF	88.76	88.86	88.51	88.63	3927691.0
2009-04-30 09:00:00	SPY	ETF	88.63	88.79	88.16	88.48	36954570.0
2009-04-30 10:00:00	SPY	ETF	88.47	88.91	88.45	88.835	34643038.0
2009-04-30 11:00:00	SPY	ETF	88.83	89.02	88.298	88.33	29732843.0
2009-04-30 12:00:00	SPY	ETF	88.33	88.42	87.47	87.66	37349288.0
2009-04-30 13:00:00	SPY	ETF	87.66	88.62	87.15	87.65	35179490.0
2009-04-30 14:00:00	SPY	ETF	87.65	88.15	87.48	87.83	31459374.0
2009-04-30 15:00:00	SPY	ETF	87.83	88.25	86.92	87.44	70674332.0
2009-04-30 16:00:00	SPY	ETF	87.43	87.8	86.97	87.13	18159088.0
2009-04-30 17:00:00	SPY	ETF	87.14	87.14	86.86	86.99	605964.0
2009-04-30 18:00:00	SPY	ETF	86.95	87.23	86.9	87.21	191860.0
2009-04-30 19:00:00	SPY	ETF	87.21	87.26	87.18	87.24	60956.0
2009-04-30 04:00:00	QQQ	ETF	34.49	34.5	34.44	34.5	5090.0
2009-04-30 05:00:00	QQQ	ETF	34.52	34.54	34.47	34.51	1800.0
2009-04-30 06:00:00	QQQ	ETF	34.5	34.61	34.5	34.54	30333.0
2009-04-30 07:00:00	QQQ	ETF	34.56	34.58	34.5	34.52	467232.0
2009-04-30 08:00:00	QQQ	ETF	34.51	34.56	34.36	34.43	1507402.0
2009-04-30 09:00:00	QQQ	ETF	34.43	34.66	34.29	34.62	18579160.0
2009-04-30 10:00:00	QQQ	ETF	34.63	34.86	34.615	34.8001	19028515.0
2009-04-30 11:00:00	QQQ	ETF	34.8022	34.9	34.69	34.71	15196931.0
2009-04-30 12:00:00	QQQ	ETF	34.71	34.75	34.38	34.46	16524131.0
2009-04-30 13:00:00	QQQ	ETF	34.46	34.53	34.16	34.32	19706951.0
2009-04-30 14:00:00	QQQ	ETF	34.3101	34.47	34.235	34.3522	13865257.0
2009-04-30 15:00:00	QQQ	ETF	34.36	34.38	34.04	34.29	29113663.0
2009-04-30 16:00:00	QQQ	ETF	34.29	34.7824	34.0038	34.24	5034313.0
2009-04-30 17:00:00	QQQ	ETF	34.23	34.23	34.13	34.16	99002.0
2009-04-30 18:00:00	QQQ	ETF	34.16	34.24	34.16	34.24	15320.0
2009-04-30 19:00:00	QQQ	ETF	34.25	34.27	34.24	34.26	38537.0
2009-04-30 06:00:00	IWM	ETF	50.06	50.06	49.91	49.91	3300.0
2009-04-30 07:00:00	IWM	ETF	50.0	50.0	49.84	49.9	42648.0
2009-04-30 08:00:00	IWM	ETF	49.83	50.09	49.72	49.87	152072.0
2009-04-30 09:00:00	IWM	ETF	49.88	49.91	49.4	49.86	6522949.0
2009-04-30 10:00:00	IWM	ETF	49.87	50.2	49.81	50.07	9040624.0
2009-04-30 11:00:00	IWM	ETF	50.07	50.24	49.89	49.928	6578460.0
2009-04-30 12:00:00	IWM	ETF	49.93	50.0	49.25	49.43	5735225.0
2009-04-30 13:00:00	IWM	ETF	49.43	49.8	48.97	49.2826	8295684.0
2009-04-30 14:00:00	IWM	ETF	49.29	50.15	49.06	49.37	8001418.0
2009-04-30 15:00:00	IWM	ETF	49.365	49.51	48.54	48.59	17155344.0
2009-04-30 16:00:00	IWM	ETF	48.59	49.3497	48.32	48.43	5802272.0
2009-04-30 17:00:00	IWM	ETF	48.4	48.4	48.27	48.31	57588.0
2009-04-30 18:00:00	IWM	ETF	48.35	48.4	48.3	48.3	2700.0
2009-04-30 19:00:00	IWM	ETF	48.42	48.45	48.37	48.37	1000.0
2009-04-30 04:00:00	DIA	ETF	81.84	81.84	81.84	81.84	200.0
2009-04-30 06:00:00	DIA	ETF	82.99	83.26	82.96	83.08	2600.0
2009-04-30 07:00:00	DIA	ETF	83.09	83.12	82.92	82.95	5775.0
2009-04-30 08:00:00	DIA	ETF	82.94	82.95	82.77	82.8	71230.0

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

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