PREVIEW / etf_1hour / 2013-11-25

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-25.parquet
  size:    211 KB
  rows:    6,682

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
2013-11-25 04:00:00	SPY	ETF	180.97	181.26	180.97	181.24	452894.0
2013-11-25 05:00:00	SPY	ETF	181.11	181.21	181.11	181.21	67558.0
2013-11-25 06:00:00	SPY	ETF	181.17	181.28	181.17	181.28	153800.0
2013-11-25 07:00:00	SPY	ETF	181.24	181.26	181.15	181.24	134377.0
2013-11-25 08:00:00	SPY	ETF	181.21	181.29	181.18	181.22	613343.0
2013-11-25 09:00:00	SPY	ETF	181.18	181.25	180.84	180.86	10224778.0
2013-11-25 10:00:00	SPY	ETF	180.85	181.03	180.711	180.86	10159281.0
2013-11-25 11:00:00	SPY	ETF	180.86	181.01	180.83	180.93	5144557.0
2013-11-25 12:00:00	SPY	ETF	180.9201	181.0	180.8078	180.89	7692209.0
2013-11-25 13:00:00	SPY	ETF	180.89	181.04	180.81	181.005	4933796.0
2013-11-25 14:00:00	SPY	ETF	181.005	181.09	180.9	180.92	4775237.0
2013-11-25 15:00:00	SPY	ETF	180.91	181.05	180.37	180.655	24957698.0
2013-11-25 16:00:00	SPY	ETF	180.65	181.7	180.43	180.72	6206665.0
2013-11-25 17:00:00	SPY	ETF	180.73	180.8078	180.65	180.67	602462.0
2013-11-25 18:00:00	SPY	ETF	180.65	180.73	180.63	180.73	115292.0
2013-11-25 19:00:00	SPY	ETF	180.73	180.85	180.69	180.83	128042.0
2013-11-25 04:00:00	QQQ	ETF	84.07	84.28	84.07	84.26	18939.0
2013-11-25 05:00:00	QQQ	ETF	84.23	84.26	84.23	84.26	3000.0
2013-11-25 06:00:00	QQQ	ETF	84.28	84.29	84.28	84.29	2000.0
2013-11-25 07:00:00	QQQ	ETF	84.26	84.3	84.26	84.3	21990.0
2013-11-25 08:00:00	QQQ	ETF	84.28	84.31	84.27	84.31	45530.0
2013-11-25 09:00:00	QQQ	ETF	84.31	84.38	84.1199	84.13	3462740.0
2013-11-25 10:00:00	QQQ	ETF	84.12	84.18	83.98	84.08	3383212.0
2013-11-25 11:00:00	QQQ	ETF	84.08	84.26	84.07	84.2001	3015394.0
2013-11-25 12:00:00	QQQ	ETF	84.21	84.28	84.16	84.17	1458363.0
2013-11-25 13:00:00	QQQ	ETF	84.175	84.34	84.16	84.32	987761.0
2013-11-25 14:00:00	QQQ	ETF	84.3201	84.37	84.295	84.3	1552001.0
2013-11-25 15:00:00	QQQ	ETF	84.3	84.3	84.0699	84.17	4537093.0
2013-11-25 16:00:00	QQQ	ETF	84.18	84.286	84.14	84.18	506042.0
2013-11-25 17:00:00	QQQ	ETF	84.18	84.18	84.15	84.15	5600.0
2013-11-25 18:00:00	QQQ	ETF	84.14	84.19	84.14	84.16	1150.0
2013-11-25 19:00:00	QQQ	ETF	84.18	84.2	84.18	84.2	4400.0
2013-11-25 04:00:00	IWM	ETF	112.0	112.5	112.0	112.2	1401.0
2013-11-25 06:00:00	IWM	ETF	111.65	112.16	111.65	112.16	2400.0
2013-11-25 07:00:00	IWM	ETF	112.18	112.2	112.13	112.2	102159.0
2013-11-25 08:00:00	IWM	ETF	112.17	112.21	112.12	112.15	38550.0
2013-11-25 09:00:00	IWM	ETF	112.16	112.21	111.9	111.96	2526456.0
2013-11-25 10:00:00	IWM	ETF	111.95	111.98	111.67	111.85	3981611.0
2013-11-25 11:00:00	IWM	ETF	111.86	112.1	111.83	112.03	2064229.0
2013-11-25 12:00:00	IWM	ETF	112.04	112.13	111.98	112.08	1368669.0
2013-11-25 13:00:00	IWM	ETF	112.09	112.23	112.0	112.195	1446149.0
2013-11-25 14:00:00	IWM	ETF	112.195	112.275	112.05	112.09	1636747.0
2013-11-25 15:00:00	IWM	ETF	112.089	112.089	111.6297	111.895	6254961.0
2013-11-25 16:00:00	IWM	ETF	111.9	112.01	111.7295	111.8118	2303014.0
2013-11-25 17:00:00	IWM	ETF	111.985	112.01	111.985	112.01	10360.0
2013-11-25 07:00:00	DIA	ETF	160.86	160.86	160.86	160.86	100.0
2013-11-25 08:00:00	DIA	ETF	160.74	160.97	160.74	160.88	8100.0
2013-11-25 09:00:00	DIA	ETF	160.9	160.94	160.33	160.53	797371.0
2013-11-25 10:00:00	DIA	ETF	160.52	160.83	160.43	160.69	654233.0
2013-11-25 11:00:00	DIA	ETF	160.7	160.7976	160.63	160.69	491041.0

> showing 50 of 6,682 rows — these rows as CSV

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