PREVIEW / etf_1hour / 2009-06-11

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-11.parquet
  size:    139 KB
  rows:    4,242

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-06-11 04:00:00	SPY	ETF	94.74	94.8	94.74	94.8	4267.0
2009-06-11 05:00:00	SPY	ETF	94.86	94.86	94.79	94.8	17600.0
2009-06-11 06:00:00	SPY	ETF	94.83	94.83	94.75	94.76	35100.0
2009-06-11 07:00:00	SPY	ETF	94.75	94.75	94.61	94.63	631231.0
2009-06-11 08:00:00	SPY	ETF	94.63	95.05	94.15	94.19	8014242.0
2009-06-11 09:00:00	SPY	ETF	94.19	95.35	94.18	95.18	31422446.0
2009-06-11 10:00:00	SPY	ETF	95.18	95.53	95.03	95.05	30987217.0
2009-06-11 11:00:00	SPY	ETF	95.05	95.39	94.93	95.24	21467182.0
2009-06-11 12:00:00	SPY	ETF	95.24	95.69	95.0	95.65	27315105.0
2009-06-11 13:00:00	SPY	ETF	95.65	96.11	95.53	95.74	43868845.0
2009-06-11 14:00:00	SPY	ETF	95.74	95.88	94.95	95.75	34838848.0
2009-06-11 15:00:00	SPY	ETF	95.74	95.8869	94.81	94.88	47809976.0
2009-06-11 16:00:00	SPY	ETF	94.88	95.8869	94.3761	94.62	24732465.0
2009-06-11 17:00:00	SPY	ETF	94.64	94.68	94.6	94.62	1122107.0
2009-06-11 18:00:00	SPY	ETF	94.62	94.85	94.57	94.6	107163.0
2009-06-11 19:00:00	SPY	ETF	94.6	94.7	94.58	94.7	50610.0
2009-06-11 05:00:00	QQQ	ETF	36.98	36.98	36.98	36.98	700.0
2009-06-11 06:00:00	QQQ	ETF	36.98	36.98	36.98	36.98	200.0
2009-06-11 07:00:00	QQQ	ETF	36.94	36.95	36.89	36.9	354367.0
2009-06-11 08:00:00	QQQ	ETF	36.89	36.9	36.63	36.65	6061027.0
2009-06-11 09:00:00	QQQ	ETF	36.65	37.15	36.64	37.07	23303614.0
2009-06-11 10:00:00	QQQ	ETF	37.08	37.2	36.96	36.96	15897865.0
2009-06-11 11:00:00	QQQ	ETF	36.96	37.079	36.89	36.95	11684044.0
2009-06-11 12:00:00	QQQ	ETF	36.95	37.0701	36.77	37.05	17802972.0
2009-06-11 13:00:00	QQQ	ETF	37.06	37.23	37.01	37.12	16069491.0
2009-06-11 14:00:00	QQQ	ETF	37.128	37.17	37.02	37.13	17169480.0
2009-06-11 15:00:00	QQQ	ETF	37.13	37.18	36.81	36.82	21963797.0
2009-06-11 16:00:00	QQQ	ETF	36.81	36.9847	36.64	36.68	9919191.0
2009-06-11 17:00:00	QQQ	ETF	36.68	36.8235	36.66	36.66	1142190.0
2009-06-11 18:00:00	QQQ	ETF	36.69	36.69	36.67	36.68	55117.0
2009-06-11 19:00:00	QQQ	ETF	36.68	36.69	36.64	36.65	99870.0
2009-06-11 04:00:00	IWM	ETF	52.18	52.47	52.18	52.47	200.0
2009-06-11 06:00:00	IWM	ETF	52.79	52.82	52.79	52.82	225.0
2009-06-11 07:00:00	IWM	ETF	52.76	52.77	52.73	52.73	32968.0
2009-06-11 08:00:00	IWM	ETF	52.72	52.76	52.3	52.36	2043576.0
2009-06-11 09:00:00	IWM	ETF	52.36	53.27	52.36	53.06	8719939.0
2009-06-11 10:00:00	IWM	ETF	53.06	53.26	52.93	52.95	4085539.0
2009-06-11 11:00:00	IWM	ETF	52.942	53.02	52.83	52.92	3214262.0
2009-06-11 12:00:00	IWM	ETF	52.92	53.07	52.77	53.03	5008209.0
2009-06-11 13:00:00	IWM	ETF	53.04	53.46	53.01	53.33	9537573.0
2009-06-11 14:00:00	IWM	ETF	53.33	53.35	53.015	53.17	6271838.0
2009-06-11 15:00:00	IWM	ETF	53.17	53.23	52.61	52.62	11265307.0
2009-06-11 16:00:00	IWM	ETF	52.62	52.9	52.45	52.52	3227267.0
2009-06-11 17:00:00	IWM	ETF	52.54	52.55	52.5	52.5	2200.0
2009-06-11 18:00:00	IWM	ETF	52.53	52.61	52.53	52.53	600.0
2009-06-11 07:00:00	DIA	ETF	87.91	87.92	87.91	87.92	700.0
2009-06-11 08:00:00	DIA	ETF	87.87	88.05	87.5	87.5	102552.0
2009-06-11 09:00:00	DIA	ETF	87.51	88.52	87.51	88.38	2245952.0
2009-06-11 10:00:00	DIA	ETF	88.39	88.66	88.16	88.18	1946239.0
2009-06-11 11:00:00	DIA	ETF	88.16	88.46	88.06	88.31	2089213.0

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

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