PREVIEW / etf_1hour / 2014-01-15

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-15.parquet
  size:    217 KB
  rows:    6,838

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
2014-01-15 04:00:00	SPY	ETF	183.93	183.99	183.89	183.9	15509.0
2014-01-15 05:00:00	SPY	ETF	183.9	183.95	183.86	183.91	4512.0
2014-01-15 06:00:00	SPY	ETF	183.99	184.13	183.96	184.01	97142.0
2014-01-15 07:00:00	SPY	ETF	184.04	184.1	183.99	183.99	494993.0
2014-01-15 08:00:00	SPY	ETF	184.08	184.08	183.8	184.0	1388212.0
2014-01-15 09:00:00	SPY	ETF	184.01	184.32	183.98	184.25	10429112.0
2014-01-15 10:00:00	SPY	ETF	184.24	184.69	184.23	184.52	15244987.0
2014-01-15 11:00:00	SPY	ETF	184.53	184.94	184.44	184.6	12188395.0
2014-01-15 12:00:00	SPY	ETF	184.61	184.83	184.52	184.66	6821225.0
2014-01-15 13:00:00	SPY	ETF	184.66	184.7599	184.4	184.45	11182988.0
2014-01-15 14:00:00	SPY	ETF	184.45	184.82	184.36	184.79	7826527.0
2014-01-15 15:00:00	SPY	ETF	184.8	184.86	184.48	184.67	21033428.0
2014-01-15 16:00:00	SPY	ETF	184.67	184.69	183.7102	184.54	8302459.0
2014-01-15 17:00:00	SPY	ETF	184.54	184.57	184.49	184.51	1073472.0
2014-01-15 18:00:00	SPY	ETF	184.55	184.6	184.48	184.6	65916.0
2014-01-15 19:00:00	SPY	ETF	184.62	184.71	184.62	184.7	88311.0
2014-01-15 04:00:00	QQQ	ETF	87.76	87.93	87.76	87.89	1660.0
2014-01-15 06:00:00	QQQ	ETF	87.95	88.01	87.95	87.95	13540.0
2014-01-15 07:00:00	QQQ	ETF	87.95	87.99	87.95	87.97	22300.0
2014-01-15 08:00:00	QQQ	ETF	87.97	87.99	87.9	87.98	400478.0
2014-01-15 09:00:00	QQQ	ETF	87.97	88.238	87.94	88.195	6296143.0
2014-01-15 10:00:00	QQQ	ETF	88.199	88.38	88.145	88.225	7569275.0
2014-01-15 11:00:00	QQQ	ETF	88.23	88.49	88.17	88.32	2766878.0
2014-01-15 12:00:00	QQQ	ETF	88.32	88.469	88.32	88.3601	1657621.0
2014-01-15 13:00:00	QQQ	ETF	88.365	88.436	88.26	88.32	1892432.0
2014-01-15 14:00:00	QQQ	ETF	88.3199	88.51	88.2851	88.5	2913045.0
2014-01-15 15:00:00	QQQ	ETF	88.495	88.54	88.32	88.36	6686809.0
2014-01-15 16:00:00	QQQ	ETF	88.36	88.37	87.6795	88.28	5138817.0
2014-01-15 17:00:00	QQQ	ETF	88.32	88.32	88.28	88.28	6171.0
2014-01-15 18:00:00	QQQ	ETF	88.3	88.31	88.26	88.3	17403.0
2014-01-15 19:00:00	QQQ	ETF	88.32	88.37	88.32	88.37	4000.0
2014-01-15 04:00:00	IWM	ETF	115.41	115.7	115.41	115.65	970.0
2014-01-15 06:00:00	IWM	ETF	115.75	115.75	115.71	115.71	200.0
2014-01-15 07:00:00	IWM	ETF	115.53	115.7	115.53	115.68	129900.0
2014-01-15 08:00:00	IWM	ETF	115.66	115.72	115.52	115.59	134649.0
2014-01-15 09:00:00	IWM	ETF	115.61	116.07	115.56	116.02	4044532.0
2014-01-15 10:00:00	IWM	ETF	116.02	116.21	115.73	115.85	5625102.0
2014-01-15 11:00:00	IWM	ETF	115.85	116.15	115.83	116.04	2080222.0
2014-01-15 12:00:00	IWM	ETF	116.05	116.14	115.86	115.95	1275413.0
2014-01-15 13:00:00	IWM	ETF	115.95	116.05	115.88	116.02	1488002.0
2014-01-15 14:00:00	IWM	ETF	116.02	116.27	115.92	116.24	2171919.0
2014-01-15 15:00:00	IWM	ETF	116.24	116.29	116.06	116.2	4627181.0
2014-01-15 16:00:00	IWM	ETF	116.2	116.24	115.4445	116.23	1677715.0
2014-01-15 17:00:00	IWM	ETF	116.24	116.29	116.22	116.29	34200.0
2014-01-15 18:00:00	IWM	ETF	116.28	116.29	116.28	116.29	200.0
2014-01-15 19:00:00	IWM	ETF	116.24	116.24	116.24	116.24	101.0
2014-01-15 06:00:00	DIA	ETF	163.67	163.67	163.67	163.67	100.0
2014-01-15 07:00:00	DIA	ETF	163.78	163.79	163.78	163.79	550.0
2014-01-15 08:00:00	DIA	ETF	163.78	163.8	163.53	163.62	2800.0
2014-01-15 09:00:00	DIA	ETF	163.63	164.05	163.59	164.0	638574.0

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

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