PREVIEW / etf_1hour / 2010-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-29.parquet
  size:    161 KB
  rows:    4,951

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
2010-04-29 04:00:00	SPY	ETF	119.76	119.98	119.76	119.8	5000.0
2010-04-29 05:00:00	SPY	ETF	119.73	120.0	119.7	120.0	7600.0
2010-04-29 06:00:00	SPY	ETF	120.05	120.19	120.05	120.14	27591.0
2010-04-29 07:00:00	SPY	ETF	120.1	120.17	120.01	120.15	458500.0
2010-04-29 08:00:00	SPY	ETF	120.15	120.33	120.08	120.19	3182848.0
2010-04-29 09:00:00	SPY	ETF	120.18	120.44	119.95	120.18	29518761.0
2010-04-29 10:00:00	SPY	ETF	120.18	120.92	120.08	120.8	33166994.0
2010-04-29 11:00:00	SPY	ETF	120.8	120.9301	120.46	120.83	26318766.0
2010-04-29 12:00:00	SPY	ETF	120.84	121.06	120.69	120.88	22501685.0
2010-04-29 13:00:00	SPY	ETF	120.89	121.04	120.81	121.0299	13852481.0
2010-04-29 14:00:00	SPY	ETF	121.03	121.11	120.71	120.8	20275645.0
2010-04-29 15:00:00	SPY	ETF	120.8	120.93	120.64	120.84	31538545.0
2010-04-29 16:00:00	SPY	ETF	120.83	121.09	120.17	120.97	10624329.0
2010-04-29 17:00:00	SPY	ETF	120.97	121.06	120.96	121.05	53732.0
2010-04-29 18:00:00	SPY	ETF	121.04	121.06	120.85	121.01	54168.0
2010-04-29 19:00:00	SPY	ETF	121.03	121.03	120.79	120.8	122031.0
2010-04-29 04:00:00	QQQ	ETF	49.55	49.55	49.55	49.55	500.0
2010-04-29 05:00:00	QQQ	ETF	49.49	49.58	49.49	49.58	1100.0
2010-04-29 06:00:00	QQQ	ETF	49.57	49.64	49.57	49.62	13983.0
2010-04-29 07:00:00	QQQ	ETF	49.63	49.67	49.6	49.65	45434.0
2010-04-29 08:00:00	QQQ	ETF	49.65	49.74	49.63	49.7	1243327.0
2010-04-29 09:00:00	QQQ	ETF	49.7	49.86	49.61	49.79	10715398.0
2010-04-29 10:00:00	QQQ	ETF	49.785	50.08	49.72	50.03	17957493.0
2010-04-29 11:00:00	QQQ	ETF	50.03	50.18	49.95	50.1401	10898437.0
2010-04-29 12:00:00	QQQ	ETF	50.145	50.29	50.1	50.2681	7120428.0
2010-04-29 13:00:00	QQQ	ETF	50.265	50.33	50.2	50.29	4882429.0
2010-04-29 14:00:00	QQQ	ETF	50.2826	50.31	50.16	50.2	6735446.0
2010-04-29 15:00:00	QQQ	ETF	50.2	50.32	50.16	50.23	15230514.0
2010-04-29 16:00:00	QQQ	ETF	50.24	50.3038	50.1283	50.23	6696552.0
2010-04-29 17:00:00	QQQ	ETF	50.23	50.29	50.23	50.28	115080.0
2010-04-29 18:00:00	QQQ	ETF	50.27	50.29	50.26	50.28	17700.0
2010-04-29 19:00:00	QQQ	ETF	50.27	50.28	50.16	50.17	25868.0
2010-04-29 06:00:00	IWM	ETF	72.83	72.83	72.81	72.81	5300.0
2010-04-29 07:00:00	IWM	ETF	72.79	72.84	72.74	72.84	78403.0
2010-04-29 08:00:00	IWM	ETF	72.83	72.92	72.79	72.85	249600.0
2010-04-29 09:00:00	IWM	ETF	72.84	72.87	72.57	72.59	9234448.0
2010-04-29 10:00:00	IWM	ETF	72.58	73.0406	72.38	72.9401	10168429.0
2010-04-29 11:00:00	IWM	ETF	72.95	72.98	72.705	72.89	5720730.0
2010-04-29 12:00:00	IWM	ETF	72.89	73.28	72.79	73.26	6483719.0
2010-04-29 13:00:00	IWM	ETF	73.26	73.5	73.25	73.48	6952995.0
2010-04-29 14:00:00	IWM	ETF	73.48	73.699	73.37	73.442	9780022.0
2010-04-29 15:00:00	IWM	ETF	73.46	73.84	73.26	73.83	15854151.0
2010-04-29 16:00:00	IWM	ETF	73.82	73.89	72.4382	73.87	2629969.0
2010-04-29 17:00:00	IWM	ETF	73.85	73.97	73.84	73.89	42847.0
2010-04-29 18:00:00	IWM	ETF	73.99	74.0	73.99	74.0	752.0
2010-04-29 19:00:00	IWM	ETF	73.87	73.99	73.7	73.99	11639.0
2010-04-29 06:00:00	DIA	ETF	111.03	111.03	111.03	111.03	100.0
2010-04-29 08:00:00	DIA	ETF	111.05	111.15	110.96	110.97	27670.0
2010-04-29 09:00:00	DIA	ETF	110.98	111.33	110.89	111.12	1300761.0
2010-04-29 10:00:00	DIA	ETF	111.11	111.72	111.04	111.6236	1306927.0

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

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