PREVIEW / etf_1hour / 2009-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-13.parquet
  size:    132 KB
  rows:    4,061

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-13 04:00:00	SPY	ETF	85.13	85.13	85.05	85.05	1914.0
2009-04-13 05:00:00	SPY	ETF	85.0	85.01	84.88	84.88	3026.0
2009-04-13 06:00:00	SPY	ETF	84.93	85.08	84.9	85.02	13757.0
2009-04-13 07:00:00	SPY	ETF	85.05	85.22	84.93	84.97	422678.0
2009-04-13 08:00:00	SPY	ETF	84.98	85.25	84.96	85.16	1095501.0
2009-04-13 09:00:00	SPY	ETF	85.17	85.17	84.58	84.7	22584113.0
2009-04-13 10:00:00	SPY	ETF	84.7	85.49	84.66	85.09	32907330.0
2009-04-13 11:00:00	SPY	ETF	85.09	85.23	84.77	84.98	23877048.0
2009-04-13 12:00:00	SPY	ETF	84.98	85.45	84.94	85.4	13437569.0
2009-04-13 13:00:00	SPY	ETF	85.4	85.85	85.17	85.8301	21053844.0
2009-04-13 14:00:00	SPY	ETF	85.84	85.9	85.47	85.55	23930683.0
2009-04-13 15:00:00	SPY	ETF	85.55	86.54	85.1	85.85	57488091.0
2009-04-13 16:00:00	SPY	ETF	85.84	86.13	85.0	85.95	14960534.0
2009-04-13 17:00:00	SPY	ETF	85.93	85.93	85.83	85.83	324180.0
2009-04-13 18:00:00	SPY	ETF	85.8	85.83	85.65	85.66	111467.0
2009-04-13 19:00:00	SPY	ETF	85.66	85.81	85.64	85.79	19392.0
2009-04-13 04:00:00	QQQ	ETF	32.9	32.9	32.74	32.74	600.0
2009-04-13 05:00:00	QQQ	ETF	32.65	32.65	32.65	32.65	900.0
2009-04-13 06:00:00	QQQ	ETF	32.72	32.75	32.72	32.75	300.0
2009-04-13 07:00:00	QQQ	ETF	32.75	32.8	32.69	32.71	341850.0
2009-04-13 08:00:00	QQQ	ETF	32.72	32.83	32.7	32.79	509572.0
2009-04-13 09:00:00	QQQ	ETF	32.78	32.87	32.66	32.72	9613291.0
2009-04-13 10:00:00	QQQ	ETF	32.72	32.87	32.63	32.6499	16084218.0
2009-04-13 11:00:00	QQQ	ETF	32.64	32.7	32.53	32.63	13906963.0
2009-04-13 12:00:00	QQQ	ETF	32.64	32.77	32.63	32.76	4992622.0
2009-04-13 13:00:00	QQQ	ETF	32.76	32.88	32.69	32.86	8653944.0
2009-04-13 14:00:00	QQQ	ETF	32.86	32.88	32.72	32.77	10557051.0
2009-04-13 15:00:00	QQQ	ETF	32.77	33.07	32.73	32.88	27931426.0
2009-04-13 16:00:00	QQQ	ETF	32.89	32.9	32.77	32.88	21080875.0
2009-04-13 17:00:00	QQQ	ETF	32.85	32.89	32.82	32.83	79443.0
2009-04-13 18:00:00	QQQ	ETF	32.82	32.89	32.79	32.81	138423.0
2009-04-13 19:00:00	QQQ	ETF	32.82	32.85	32.8	32.85	32129.0
2009-04-13 07:00:00	IWM	ETF	46.3	46.4	46.3	46.33	5292.0
2009-04-13 08:00:00	IWM	ETF	46.24	46.41	46.24	46.3	89491.0
2009-04-13 09:00:00	IWM	ETF	46.3	46.3	45.72	45.78	4124340.0
2009-04-13 10:00:00	IWM	ETF	45.78	46.38	45.73	45.942	7336771.0
2009-04-13 11:00:00	IWM	ETF	45.95	46.02	45.67	45.85	5616616.0
2009-04-13 12:00:00	IWM	ETF	45.86	46.09	45.79	46.07	3873413.0
2009-04-13 13:00:00	IWM	ETF	46.069	46.37	45.85	46.37	4346182.0
2009-04-13 14:00:00	IWM	ETF	46.37	46.56	46.15	46.31	5649287.0
2009-04-13 15:00:00	IWM	ETF	46.31	47.0	46.25	46.66	14075553.0
2009-04-13 16:00:00	IWM	ETF	46.67	46.8048	46.1054	46.67	11223993.0
2009-04-13 17:00:00	IWM	ETF	46.63	46.8048	46.55	46.55	1504225.0
2009-04-13 18:00:00	IWM	ETF	46.61	46.61	46.57	46.57	801.0
2009-04-13 19:00:00	IWM	ETF	46.54	46.61	46.54	46.61	2100.0
2009-04-13 06:00:00	DIA	ETF	80.17	80.17	80.17	80.17	333.0
2009-04-13 07:00:00	DIA	ETF	80.23	80.32	80.1	80.13	16990.0
2009-04-13 08:00:00	DIA	ETF	80.8909	80.8909	80.1	80.19	566259.0
2009-04-13 09:00:00	DIA	ETF	80.17	80.17	79.75	79.78	1383411.0
2009-04-13 10:00:00	DIA	ETF	79.78	80.3	79.73	79.9187	2109361.0

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

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