PREVIEW / etf_1hour / 2011-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-05.parquet
  size:    179 KB
  rows:    5,476

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
2011-04-05 04:00:00	SPY	ETF	133.18	133.18	132.76	132.89	4625.0
2011-04-05 05:00:00	SPY	ETF	132.98	132.98	132.82	132.82	30125.0
2011-04-05 06:00:00	SPY	ETF	132.8	132.91	132.77	132.85	86000.0
2011-04-05 07:00:00	SPY	ETF	132.87	133.08	132.84	132.96	249625.0
2011-04-05 08:00:00	SPY	ETF	132.99	133.04	132.73	132.89	1115142.0
2011-04-05 09:00:00	SPY	ETF	132.9	133.27	132.88	133.19	13431491.0
2011-04-05 10:00:00	SPY	ETF	133.18	133.6	132.97	133.41	21107945.0
2011-04-05 11:00:00	SPY	ETF	133.42	133.76	133.35	133.7	15141894.0
2011-04-05 12:00:00	SPY	ETF	133.7	133.77	133.57	133.695	12563632.0
2011-04-05 13:00:00	SPY	ETF	133.7	133.83	133.64	133.65	10263873.0
2011-04-05 14:00:00	SPY	ETF	133.65	133.73	133.36	133.479	14716873.0
2011-04-05 15:00:00	SPY	ETF	133.48	133.51	133.11	133.22	21495110.0
2011-04-05 16:00:00	SPY	ETF	133.21	133.578	133.05	133.06	10113481.0
2011-04-05 17:00:00	SPY	ETF	133.07	133.12	133.07	133.1	225357.0
2011-04-05 18:00:00	SPY	ETF	133.1	133.24	133.1	133.21	263755.0
2011-04-05 19:00:00	SPY	ETF	133.2	133.22	133.16	133.19	40831.0
2011-04-05 04:00:00	QQQ	ETF	57.31	57.31	57.02	57.02	2073.0
2011-04-05 05:00:00	QQQ	ETF	57.05	57.07	57.01	57.06	31300.0
2011-04-05 06:00:00	QQQ	ETF	56.98	57.02	56.9	57.01	11060.0
2011-04-05 07:00:00	QQQ	ETF	57.03	57.13	57.01	57.09	353162.0
2011-04-05 08:00:00	QQQ	ETF	57.09	57.16	57.06	57.13	1336425.0
2011-04-05 09:00:00	QQQ	ETF	57.13	57.28	57.07	57.19	7978574.0
2011-04-05 10:00:00	QQQ	ETF	57.19	57.46	57.06	57.41	9609891.0
2011-04-05 11:00:00	QQQ	ETF	57.42	57.4538	57.31	57.429	4152394.0
2011-04-05 12:00:00	QQQ	ETF	57.4299	57.46	57.36	57.44	3972103.0
2011-04-05 13:00:00	QQQ	ETF	57.44	57.49	57.4	57.4201	2686784.0
2011-04-05 14:00:00	QQQ	ETF	57.425	57.46	57.14	57.191	5741659.0
2011-04-05 15:00:00	QQQ	ETF	57.2	57.22	57.0	57.12	8559753.0
2011-04-05 16:00:00	QQQ	ETF	57.09	57.1447	57.07	57.1	1852339.0
2011-04-05 17:00:00	QQQ	ETF	57.1	57.11	57.08	57.11	6114.0
2011-04-05 18:00:00	QQQ	ETF	57.11	57.18	57.11	57.17	45886.0
2011-04-05 19:00:00	QQQ	ETF	57.17	57.17	57.15	57.15	3900.0
2011-04-05 05:00:00	IWM	ETF	84.63	84.63	84.61	84.61	2800.0
2011-04-05 06:00:00	IWM	ETF	84.58	84.67	84.58	84.64	8400.0
2011-04-05 07:00:00	IWM	ETF	84.62	84.71	84.6	84.66	62307.0
2011-04-05 08:00:00	IWM	ETF	84.66	84.73	84.44	84.63	336922.0
2011-04-05 09:00:00	IWM	ETF	84.63	84.8799	84.521	84.76	4682941.0
2011-04-05 10:00:00	IWM	ETF	84.76	85.26	84.57	85.0825	7961940.0
2011-04-05 11:00:00	IWM	ETF	85.09	85.6	85.07	85.54	5140180.0
2011-04-05 12:00:00	IWM	ETF	85.54	85.73	85.49	85.65	4908154.0
2011-04-05 13:00:00	IWM	ETF	85.66	85.745	85.54	85.56	2396307.0
2011-04-05 14:00:00	IWM	ETF	85.555	85.6	85.29	85.42	4752462.0
2011-04-05 15:00:00	IWM	ETF	85.41	85.42	85.06	85.155	8765438.0
2011-04-05 16:00:00	IWM	ETF	85.15	85.65	84.99	85.01	1381331.0
2011-04-05 17:00:00	IWM	ETF	85.02	85.03	85.01	85.03	1700.0
2011-04-05 18:00:00	IWM	ETF	85.04	85.1	84.94	85.09	7080.0
2011-04-05 19:00:00	IWM	ETF	85.09	85.09	85.08	85.08	3900.0
2011-04-05 04:00:00	DIA	ETF	123.4	123.4	123.4	123.4	100.0
2011-04-05 05:00:00	DIA	ETF	123.49	123.58	123.49	123.58	300.0
2011-04-05 06:00:00	DIA	ETF	123.49	123.49	123.49	123.49	100.0

> showing 50 of 5,476 rows — these rows as CSV

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