PREVIEW / etf_1hour / 2015-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-07-15.parquet
  size:    245 KB
  rows:    7,820

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-07-15 04:00:00	SPY	ETF	210.79	210.95	210.77	210.92	14716.0
2015-07-15 05:00:00	SPY	ETF	210.92	210.95	210.85	210.87	13501.0
2015-07-15 06:00:00	SPY	ETF	210.84	210.89	210.79	210.8	10352.0
2015-07-15 07:00:00	SPY	ETF	210.85	210.98	210.85	210.92	119087.0
2015-07-15 08:00:00	SPY	ETF	210.92	210.93	210.74	210.77	419637.0
2015-07-15 09:00:00	SPY	ETF	210.77	210.97	210.51	210.82	9840317.0
2015-07-15 10:00:00	SPY	ETF	210.83	211.2	210.7	211.105	12105317.0
2015-07-15 11:00:00	SPY	ETF	211.1	211.28	210.81	210.895	9764691.0
2015-07-15 12:00:00	SPY	ETF	210.895	211.03	210.735	210.85	8014829.0
2015-07-15 13:00:00	SPY	ETF	210.85	211.08	210.75	210.915	5471205.0
2015-07-15 14:00:00	SPY	ETF	210.915	211.0	210.04	210.27	14006363.0
2015-07-15 15:00:00	SPY	ETF	210.27	210.66	210.17	210.63	24843356.0
2015-07-15 16:00:00	SPY	ETF	210.62	211.0206	210.51	210.94	4139390.0
2015-07-15 17:00:00	SPY	ETF	210.96	211.08	210.61	210.9	3007120.0
2015-07-15 18:00:00	SPY	ETF	210.9	211.3	210.8	211.21	179572.0
2015-07-15 19:00:00	SPY	ETF	211.21	211.35	211.17	211.2	167680.0
2015-07-15 05:00:00	QQQ	ETF	110.49	110.6	110.49	110.56	15100.0
2015-07-15 06:00:00	QQQ	ETF	110.47	110.5	110.45	110.45	18900.0
2015-07-15 07:00:00	QQQ	ETF	110.49	110.52	110.49	110.5	14800.0
2015-07-15 08:00:00	QQQ	ETF	110.58	110.58	110.45	110.46	151743.0
2015-07-15 09:00:00	QQQ	ETF	110.47	110.7	110.317	110.67	3366487.0
2015-07-15 10:00:00	QQQ	ETF	110.68	110.77	110.49	110.69	3615816.0
2015-07-15 11:00:00	QQQ	ETF	110.69	110.81	110.51	110.59	2654880.0
2015-07-15 12:00:00	QQQ	ETF	110.58	110.67	110.46	110.54	1955722.0
2015-07-15 13:00:00	QQQ	ETF	110.55	110.66	110.48	110.51	1527503.0
2015-07-15 14:00:00	QQQ	ETF	110.51	110.57	110.07	110.22	3907132.0
2015-07-15 15:00:00	QQQ	ETF	110.22	110.39	110.1159	110.37	4485506.0
2015-07-15 16:00:00	QQQ	ETF	110.39	110.8	110.33	110.71	2066628.0
2015-07-15 17:00:00	QQQ	ETF	110.72	110.77	110.68	110.7	48927.0
2015-07-15 18:00:00	QQQ	ETF	110.67	110.85	110.62	110.83	28557.0
2015-07-15 19:00:00	QQQ	ETF	110.81	110.86	110.8	110.81	16500.0
2015-07-15 07:00:00	IWM	ETF	126.4	126.45	126.38	126.38	2910.0
2015-07-15 08:00:00	IWM	ETF	126.32	126.37	126.27	126.27	50739.0
2015-07-15 09:00:00	IWM	ETF	126.34	126.47	125.99	126.16	2223311.0
2015-07-15 10:00:00	IWM	ETF	126.17	126.48	125.99	126.33	2458380.0
2015-07-15 11:00:00	IWM	ETF	126.33	126.41	125.9	125.98	2455951.0
2015-07-15 12:00:00	IWM	ETF	125.97	126.065	125.7	125.855	1738325.0
2015-07-15 13:00:00	IWM	ETF	125.85	125.98	125.75	125.8	1361372.0
2015-07-15 14:00:00	IWM	ETF	125.812	125.83	125.27	125.41	2898973.0
2015-07-15 15:00:00	IWM	ETF	125.42	125.62	125.34	125.57	4757039.0
2015-07-15 16:00:00	IWM	ETF	125.57	125.79	125.47	125.71	743399.0
2015-07-15 17:00:00	IWM	ETF	125.75	125.81	125.74	125.77	21000.0
2015-07-15 18:00:00	IWM	ETF	125.77	125.77	125.77	125.77	400.0
2015-07-15 19:00:00	IWM	ETF	125.8	125.83	125.7	125.83	28900.0
2015-07-15 08:00:00	DIA	ETF	180.37	180.37	180.27	180.35	7800.0
2015-07-15 09:00:00	DIA	ETF	180.35	180.45	180.03	180.25	367469.0
2015-07-15 10:00:00	DIA	ETF	180.23	180.7	180.19	180.62	421422.0
2015-07-15 11:00:00	DIA	ETF	180.63	180.72	180.35	180.4101	414842.0
2015-07-15 12:00:00	DIA	ETF	180.42	180.54	180.34	180.43	219725.0
2015-07-15 13:00:00	DIA	ETF	180.43	180.6	180.35	180.49	201438.0

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

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