PREVIEW / etf_1hour / 2009-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-05.parquet
  size:    137 KB
  rows:    4,238

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-05 04:00:00	SPY	ETF	94.99	94.99	94.79	94.79	1300.0
2009-06-05 05:00:00	SPY	ETF	94.78	94.95	94.75	94.95	3370.0
2009-06-05 06:00:00	SPY	ETF	94.93	94.98	94.8	94.93	57900.0
2009-06-05 07:00:00	SPY	ETF	94.92	95.15	94.9	95.04	542082.0
2009-06-05 08:00:00	SPY	ETF	95.03	96.2	94.45	95.65	19534622.0
2009-06-05 09:00:00	SPY	ETF	95.66	95.99	94.42	94.67	49859984.0
2009-06-05 10:00:00	SPY	ETF	94.67	95.61	93.8	94.85	65601267.0
2009-06-05 11:00:00	SPY	ETF	94.84	95.16	94.55	94.88	27910586.0
2009-06-05 12:00:00	SPY	ETF	94.88	95.07	94.66	95.02	17883939.0
2009-06-05 13:00:00	SPY	ETF	95.02	95.03	94.54	94.65	15938394.0
2009-06-05 14:00:00	SPY	ETF	94.64	94.71	93.94	94.35	33399809.0
2009-06-05 15:00:00	SPY	ETF	94.34	94.79	94.19	94.53	38684047.0
2009-06-05 16:00:00	SPY	ETF	94.54	95.35	93.9	94.38	9278323.0
2009-06-05 17:00:00	SPY	ETF	94.38	94.6549	94.33	94.42	1070178.0
2009-06-05 18:00:00	SPY	ETF	94.45	94.46	94.33	94.45	14057.0
2009-06-05 19:00:00	SPY	ETF	94.44	94.46	94.36	94.41	25777.0
2009-06-05 04:00:00	QQQ	ETF	36.85	36.85	36.85	36.85	500.0
2009-06-05 06:00:00	QQQ	ETF	36.85	36.85	36.85	36.85	200.0
2009-06-05 07:00:00	QQQ	ETF	36.83	36.92	36.83	36.88	193309.0
2009-06-05 08:00:00	QQQ	ETF	36.88	37.22	36.84	37.05	4991857.0
2009-06-05 09:00:00	QQQ	ETF	37.05	37.15	36.56	36.69	26536166.0
2009-06-05 10:00:00	QQQ	ETF	36.7	36.8101	36.42	36.74	25926240.0
2009-06-05 11:00:00	QQQ	ETF	36.74	36.88	36.63	36.7695	9898590.0
2009-06-05 12:00:00	QQQ	ETF	36.77	36.91	36.71	36.89	8873902.0
2009-06-05 13:00:00	QQQ	ETF	36.88	36.89	36.7405	36.77	7044224.0
2009-06-05 14:00:00	QQQ	ETF	36.77	36.78	36.5	36.64	11368204.0
2009-06-05 15:00:00	QQQ	ETF	36.64	36.86	36.59	36.79	19421381.0
2009-06-05 16:00:00	QQQ	ETF	36.78	36.87	36.69	36.8	3986325.0
2009-06-05 17:00:00	QQQ	ETF	36.77	36.84	36.75	36.81	35664.0
2009-06-05 18:00:00	QQQ	ETF	36.81	36.82	36.8	36.8	4270.0
2009-06-05 19:00:00	QQQ	ETF	36.8	36.8	36.79	36.79	2300.0
2009-06-05 07:00:00	IWM	ETF	53.4	53.46	53.36	53.37	177751.0
2009-06-05 08:00:00	IWM	ETF	53.38	54.3	53.36	53.96	1662373.0
2009-06-05 09:00:00	IWM	ETF	53.94	54.13	53.15	53.4	10053663.0
2009-06-05 10:00:00	IWM	ETF	53.4	53.42	52.76	53.24	10647085.0
2009-06-05 11:00:00	IWM	ETF	53.24	53.47	53.13	53.332	5468990.0
2009-06-05 12:00:00	IWM	ETF	53.33	53.48	53.23	53.445	3119607.0
2009-06-05 13:00:00	IWM	ETF	53.44	53.45	53.12	53.16	2950581.0
2009-06-05 14:00:00	IWM	ETF	53.16	53.2	52.68	52.9	5948238.0
2009-06-05 15:00:00	IWM	ETF	52.9	53.3	52.8	53.14	8210446.0
2009-06-05 16:00:00	IWM	ETF	53.14	53.26	53.07	53.11	810484.0
2009-06-05 17:00:00	IWM	ETF	53.15	53.15	53.15	53.15	100.0
2009-06-05 18:00:00	IWM	ETF	53.15	53.15	53.12	53.12	400.0
2009-06-05 19:00:00	IWM	ETF	53.1	53.16	53.1	53.15	2900.0
2009-06-05 06:00:00	DIA	ETF	87.86	87.86	87.75	87.75	1100.0
2009-06-05 07:00:00	DIA	ETF	87.94	88.14	87.88	88.0	69996.0
2009-06-05 08:00:00	DIA	ETF	88.0	88.9	87.83	88.41	919504.0
2009-06-05 09:00:00	DIA	ETF	88.47	88.71	87.67	87.86	2365035.0
2009-06-05 10:00:00	DIA	ETF	87.86	88.19	87.12	88.14	4135479.0
2009-06-05 11:00:00	DIA	ETF	88.16	88.37	87.84	88.14	1484354.0

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

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