PREVIEW / etf_1hour / 2015-05-29

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-05-29.parquet
  size:    238 KB
  rows:    7,513

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
2015-05-29 04:00:00	SPY	ETF	211.89	212.4	211.76	212.08	12715.0
2015-05-29 05:00:00	SPY	ETF	212.06	212.06	211.88	212.04	56798.0
2015-05-29 06:00:00	SPY	ETF	212.15	212.75	212.13	212.56	76265.0
2015-05-29 07:00:00	SPY	ETF	212.57	212.63	212.36	212.42	150557.0
2015-05-29 08:00:00	SPY	ETF	212.45	212.66	212.15	212.19	875458.0
2015-05-29 09:00:00	SPY	ETF	212.2	212.43	211.82	212.065	9366787.0
2015-05-29 10:00:00	SPY	ETF	212.08	212.16	210.82	211.13	19488699.0
2015-05-29 11:00:00	SPY	ETF	211.12	211.58	210.86	211.48	15819760.0
2015-05-29 12:00:00	SPY	ETF	211.49	211.955	211.4	211.71	7874550.0
2015-05-29 13:00:00	SPY	ETF	211.71	212.1	211.63	211.79	6569243.0
2015-05-29 14:00:00	SPY	ETF	211.79	211.82	210.92	211.175	15429723.0
2015-05-29 15:00:00	SPY	ETF	211.17	211.66	211.09	211.1	27289628.0
2015-05-29 16:00:00	SPY	ETF	211.09	212.4558	210.93	211.31	18409588.0
2015-05-29 17:00:00	SPY	ETF	211.33	211.35	211.14	211.14	2188884.0
2015-05-29 18:00:00	SPY	ETF	211.16	211.18	211.12	211.18	22149.0
2015-05-29 19:00:00	SPY	ETF	211.18	211.21	211.16	211.19	17531.0
2015-05-29 04:00:00	QQQ	ETF	110.52	110.52	110.22	110.29	22200.0
2015-05-29 05:00:00	QQQ	ETF	110.28	110.38	110.28	110.38	4300.0
2015-05-29 06:00:00	QQQ	ETF	110.79	110.84	110.71	110.72	4600.0
2015-05-29 07:00:00	QQQ	ETF	110.73	110.73	110.63	110.63	8971.0
2015-05-29 08:00:00	QQQ	ETF	110.659	110.66	110.47	110.52	96233.0
2015-05-29 09:00:00	QQQ	ETF	110.51	110.79	110.47	110.63	2225110.0
2015-05-29 10:00:00	QQQ	ETF	110.631	110.71	109.79	109.99	3935283.0
2015-05-29 11:00:00	QQQ	ETF	109.99	110.34	109.94	110.27	2761303.0
2015-05-29 12:00:00	QQQ	ETF	110.28	110.6	110.27	110.47	1726175.0
2015-05-29 13:00:00	QQQ	ETF	110.49	110.65	110.4	110.43	1211759.0
2015-05-29 14:00:00	QQQ	ETF	110.43	110.44	109.86	110.04	2116408.0
2015-05-29 15:00:00	QQQ	ETF	110.035	110.3	110.0	110.06	4221611.0
2015-05-29 16:00:00	QQQ	ETF	110.06	110.27	109.96	110.24	732745.0
2015-05-29 17:00:00	QQQ	ETF	110.25	110.25	110.17	110.18	56383.0
2015-05-29 18:00:00	QQQ	ETF	110.18	110.18	110.05	110.09	1860842.0
2015-05-29 19:00:00	QQQ	ETF	110.12	110.14	110.12	110.14	2654.0
2015-05-29 06:00:00	IWM	ETF	124.91	124.91	124.85	124.89	10750.0
2015-05-29 07:00:00	IWM	ETF	124.8	124.86	124.73	124.73	75400.0
2015-05-29 08:00:00	IWM	ETF	124.73	124.75	124.34	124.35	142365.0
2015-05-29 09:00:00	IWM	ETF	124.34	124.73	124.07	124.16	3030201.0
2015-05-29 10:00:00	IWM	ETF	124.14	124.27	123.32	123.52	6070296.0
2015-05-29 11:00:00	IWM	ETF	123.53	124.1	123.325	124.0	3158920.0
2015-05-29 12:00:00	IWM	ETF	124.0	124.66	124.0	124.41	3032291.0
2015-05-29 13:00:00	IWM	ETF	124.4	124.65	124.36	124.46	1799949.0
2015-05-29 14:00:00	IWM	ETF	124.46	124.47	123.93	124.078	2737553.0
2015-05-29 15:00:00	IWM	ETF	124.07	124.28	123.87	123.88	5068797.0
2015-05-29 16:00:00	IWM	ETF	123.87	124.0521	123.87	123.99	1401033.0
2015-05-29 17:00:00	IWM	ETF	124.01	124.01	123.91	123.91	48541.0
2015-05-29 18:00:00	IWM	ETF	123.89	123.89	123.89	123.89	1502897.0
2015-05-29 19:00:00	IWM	ETF	123.93	123.93	123.93	123.93	100.0
2015-05-29 07:00:00	DIA	ETF	181.25	181.3	181.25	181.3	400.0
2015-05-29 08:00:00	DIA	ETF	181.28	181.32	180.98	180.98	3000.0
2015-05-29 09:00:00	DIA	ETF	180.98	181.19	180.51	180.77	444614.0
2015-05-29 10:00:00	DIA	ETF	180.77	180.85	179.69	179.93	1174299.0

> showing 50 of 7,513 rows — these rows as CSV

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