PREVIEW / etf_1hour / 2011-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-15.parquet
  size:    187 KB
  rows:    5,719

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-08-15 04:00:00	SPY	ETF	119.0	119.07	118.77	119.07	16214.0
2011-08-15 05:00:00	SPY	ETF	119.11	119.11	118.62	118.74	8715.0
2011-08-15 06:00:00	SPY	ETF	118.69	118.84	118.42	118.82	24200.0
2011-08-15 07:00:00	SPY	ETF	118.78	118.9	118.63	118.85	238642.0
2011-08-15 08:00:00	SPY	ETF	118.87	119.04	118.49	118.68	2342517.0
2011-08-15 09:00:00	SPY	ETF	118.66	119.9	118.12	119.62	33090908.0
2011-08-15 10:00:00	SPY	ETF	119.62	120.25	119.5	119.68	40689413.0
2011-08-15 11:00:00	SPY	ETF	119.68	120.142	119.0	119.412	29567154.0
2011-08-15 12:00:00	SPY	ETF	119.43	120.0	119.36	119.91	17670954.0
2011-08-15 13:00:00	SPY	ETF	119.92	120.11	119.61	119.99	23590297.0
2011-08-15 14:00:00	SPY	ETF	119.99	120.42	119.95	120.36	27861078.0
2011-08-15 15:00:00	SPY	ETF	120.355	120.74	120.14	120.67	49392633.0
2011-08-15 16:00:00	SPY	ETF	120.66	120.7128	119.87	120.33	27726704.0
2011-08-15 17:00:00	SPY	ETF	120.32	120.35	120.27	120.31	218911.0
2011-08-15 18:00:00	SPY	ETF	120.27	120.55	120.12	120.17	236198.0
2011-08-15 19:00:00	SPY	ETF	120.2	120.24	120.1	120.15	271735.0
2011-08-15 04:00:00	QQQ	ETF	53.84	53.84	53.74	53.74	2196.0
2011-08-15 05:00:00	QQQ	ETF	53.84	53.85	53.71	53.71	4600.0
2011-08-15 06:00:00	QQQ	ETF	53.62	53.75	53.62	53.75	2200.0
2011-08-15 07:00:00	QQQ	ETF	53.76	53.79	53.65	53.7	107100.0
2011-08-15 08:00:00	QQQ	ETF	53.69	53.9	53.51	53.59	560109.0
2011-08-15 09:00:00	QQQ	ETF	53.59	54.21	53.59	54.01	10569035.0
2011-08-15 10:00:00	QQQ	ETF	54.02	54.28	53.95	54.04	12830598.0
2011-08-15 11:00:00	QQQ	ETF	54.03	54.09	53.53	53.74	8577601.0
2011-08-15 12:00:00	QQQ	ETF	53.75	53.98	53.7	53.94	4789110.0
2011-08-15 13:00:00	QQQ	ETF	53.94	54.02	53.77	53.95	5314894.0
2011-08-15 14:00:00	QQQ	ETF	53.95	54.15	53.94	54.14	8535876.0
2011-08-15 15:00:00	QQQ	ETF	54.14	54.35	54.04	54.3429	10867403.0
2011-08-15 16:00:00	QQQ	ETF	54.3318	54.39	54.16	54.26	2116231.0
2011-08-15 17:00:00	QQQ	ETF	54.25	54.26	54.22	54.26	14204.0
2011-08-15 18:00:00	QQQ	ETF	54.23	54.23	54.15	54.2	25025.0
2011-08-15 19:00:00	QQQ	ETF	54.19	54.19	54.13	54.15	10700.0
2011-08-15 04:00:00	IWM	ETF	70.31	70.32	70.31	70.32	612.0
2011-08-15 05:00:00	IWM	ETF	70.32	70.32	70.2	70.2	8300.0
2011-08-15 07:00:00	IWM	ETF	70.22	70.4	70.22	70.35	15600.0
2011-08-15 08:00:00	IWM	ETF	70.28	70.43	69.88	70.08	806066.0
2011-08-15 09:00:00	IWM	ETF	70.08	71.16	70.07	70.7825	9774138.0
2011-08-15 10:00:00	IWM	ETF	70.78	71.31	70.63	70.9	8332134.0
2011-08-15 11:00:00	IWM	ETF	70.9	71.02	70.38	70.75	7246861.0
2011-08-15 12:00:00	IWM	ETF	70.76	71.11	70.64	71.05	2837714.0
2011-08-15 13:00:00	IWM	ETF	71.0599	71.13	70.76	70.99	3130476.0
2011-08-15 14:00:00	IWM	ETF	71.01	71.42	70.97	71.4	5742079.0
2011-08-15 15:00:00	IWM	ETF	71.392	71.83	71.22	71.78	9819222.0
2011-08-15 16:00:00	IWM	ETF	71.78	71.8438	69.7313	71.56	6585432.0
2011-08-15 17:00:00	IWM	ETF	71.53	71.56	71.47	71.56	9890.0
2011-08-15 18:00:00	IWM	ETF	71.53	71.55	71.47	71.48	6700.0
2011-08-15 19:00:00	IWM	ETF	71.52	71.55	71.49	71.5	4813.0
2011-08-15 07:00:00	DIA	ETF	113.39	113.4	113.15	113.4	944.0
2011-08-15 08:00:00	DIA	ETF	113.42	113.5	113.11	113.29	22318.0
2011-08-15 09:00:00	DIA	ETF	113.33	114.28	113.33	113.96	2181207.0

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

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