PREVIEW / etf_1hour / 2009-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-09.parquet
  size:    136 KB
  rows:    4,203

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-09 04:00:00	SPY	ETF	94.28	94.28	94.28	94.28	100.0
2009-06-09 05:00:00	SPY	ETF	94.2	94.2	94.2	94.2	2000.0
2009-06-09 06:00:00	SPY	ETF	94.15	94.18	94.11	94.15	94100.0
2009-06-09 07:00:00	SPY	ETF	94.11	94.78	94.1	94.74	1189201.0
2009-06-09 08:00:00	SPY	ETF	94.73	94.7401	94.44	94.49	1892546.0
2009-06-09 09:00:00	SPY	ETF	94.49	94.99	94.35	94.44	31345547.0
2009-06-09 10:00:00	SPY	ETF	94.44	94.66	94.08	94.19	35227669.0
2009-06-09 11:00:00	SPY	ETF	94.19	94.3	94.02	94.2	17562085.0
2009-06-09 12:00:00	SPY	ETF	94.21	94.67	94.18	94.55	22400565.0
2009-06-09 13:00:00	SPY	ETF	94.55	94.83	94.38	94.8	21752310.0
2009-06-09 14:00:00	SPY	ETF	94.8	95.145	94.72	94.9	27785816.0
2009-06-09 15:00:00	SPY	ETF	94.9	95.01	94.6	94.67	41868046.0
2009-06-09 16:00:00	SPY	ETF	94.66	94.7796	94.25	94.43	22277624.0
2009-06-09 17:00:00	SPY	ETF	94.42	94.43	94.34	94.38	1051528.0
2009-06-09 18:00:00	SPY	ETF	94.38	94.62	94.26	94.27	97780.0
2009-06-09 19:00:00	SPY	ETF	94.29	94.3	94.23	94.25	106828.0
2009-06-09 04:00:00	QQQ	ETF	36.73	36.73	36.73	36.73	800.0
2009-06-09 06:00:00	QQQ	ETF	36.7	36.7	36.67	36.68	800.0
2009-06-09 07:00:00	QQQ	ETF	36.67	36.91	36.67	36.89	551547.0
2009-06-09 08:00:00	QQQ	ETF	36.89	36.91	36.81	36.84	490110.0
2009-06-09 09:00:00	QQQ	ETF	36.83	36.99	36.75	36.84	15980528.0
2009-06-09 10:00:00	QQQ	ETF	36.84	36.95	36.67	36.74	15472158.0
2009-06-09 11:00:00	QQQ	ETF	36.74	36.81	36.67	36.76	11170828.0
2009-06-09 12:00:00	QQQ	ETF	36.76	36.96	36.74	36.93	12381511.0
2009-06-09 13:00:00	QQQ	ETF	36.93	37.04	36.85	37.04	10575721.0
2009-06-09 14:00:00	QQQ	ETF	37.04	37.17	37.0	37.0601	17589565.0
2009-06-09 15:00:00	QQQ	ETF	37.07	37.1	36.93	36.95	19574381.0
2009-06-09 16:00:00	QQQ	ETF	36.94	37.059	36.7	36.94	2482993.0
2009-06-09 17:00:00	QQQ	ETF	36.93	36.93	36.9	36.92	28417.0
2009-06-09 18:00:00	QQQ	ETF	36.92	37.0	36.88	36.88	30881.0
2009-06-09 19:00:00	QQQ	ETF	36.89	36.9	36.86	36.9	15100.0
2009-06-09 07:00:00	IWM	ETF	52.6	52.93	52.59	52.93	83400.0
2009-06-09 08:00:00	IWM	ETF	52.92	52.92	52.7	52.76	136335.0
2009-06-09 09:00:00	IWM	ETF	52.77	53.0	52.62	52.65	4093007.0
2009-06-09 10:00:00	IWM	ETF	52.65	52.91	52.56	52.7	5114151.0
2009-06-09 11:00:00	IWM	ETF	52.69	52.78	52.6	52.73	1875850.0
2009-06-09 12:00:00	IWM	ETF	52.73	52.97	52.7	52.9399	2992939.0
2009-06-09 13:00:00	IWM	ETF	52.93	53.11	52.83	53.09	3729947.0
2009-06-09 14:00:00	IWM	ETF	53.09	53.27	52.99	53.07	4386852.0
2009-06-09 15:00:00	IWM	ETF	53.07	53.15	52.81	52.84	8769324.0
2009-06-09 16:00:00	IWM	ETF	52.85	52.9138	52.61	52.77	2341604.0
2009-06-09 17:00:00	IWM	ETF	52.74	52.74	52.69	52.69	47100.0
2009-06-09 18:00:00	IWM	ETF	52.69	52.69	52.69	52.69	200.0
2009-06-09 06:00:00	DIA	ETF	87.59	87.59	87.59	87.59	100.0
2009-06-09 07:00:00	DIA	ETF	87.67	88.11	87.67	88.11	6400.0
2009-06-09 08:00:00	DIA	ETF	87.99	88.04	87.83	87.89	58100.0
2009-06-09 09:00:00	DIA	ETF	87.88	88.23	87.75	87.8	2266270.0
2009-06-09 10:00:00	DIA	ETF	87.8	87.99	87.52	87.59	2727635.0
2009-06-09 11:00:00	DIA	ETF	87.59	87.63	87.44	87.55	1468698.0
2009-06-09 12:00:00	DIA	ETF	87.53	87.86	87.49	87.76	1689390.0

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

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