PREVIEW / etf_1hour / 2015-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-04.parquet
  size:    244 KB
  rows:    7,770

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-06-04 04:00:00	SPY	ETF	211.23	211.23	210.6	211.05	79833.0
2015-06-04 05:00:00	SPY	ETF	210.95	211.16	210.78	210.94	319333.0
2015-06-04 06:00:00	SPY	ETF	210.94	211.07	210.75	211.01	186146.0
2015-06-04 07:00:00	SPY	ETF	211.01	211.3	210.75	211.28	489267.0
2015-06-04 08:00:00	SPY	ETF	211.27	211.48	210.76	211.31	1170420.0
2015-06-04 09:00:00	SPY	ETF	211.3	211.44	210.6	211.34	16767143.0
2015-06-04 10:00:00	SPY	ETF	211.34	211.78	210.8	210.88	14609462.0
2015-06-04 11:00:00	SPY	ETF	210.88	211.1	210.36	210.59	20288757.0
2015-06-04 12:00:00	SPY	ETF	210.58	210.81	210.47	210.5	10743210.0
2015-06-04 13:00:00	SPY	ETF	210.5	210.501	209.76	209.93	28293561.0
2015-06-04 14:00:00	SPY	ETF	209.91	210.35	209.78	210.13	11514708.0
2015-06-04 15:00:00	SPY	ETF	210.13	211.859	209.75	210.22	32115528.0
2015-06-04 16:00:00	SPY	ETF	210.21	211.859	209.95	210.49	13808834.0
2015-06-04 17:00:00	SPY	ETF	210.5	210.55	210.27	210.46	205162.0
2015-06-04 18:00:00	SPY	ETF	210.47	210.56	210.47	210.53	84987.0
2015-06-04 19:00:00	SPY	ETF	210.53	210.53	210.41	210.5	41547.0
2015-06-04 04:00:00	QQQ	ETF	109.72	109.72	109.44	109.62	18694.0
2015-06-04 05:00:00	QQQ	ETF	109.58	109.66	109.5	109.5	38300.0
2015-06-04 06:00:00	QQQ	ETF	109.49	109.62	109.49	109.6	11800.0
2015-06-04 07:00:00	QQQ	ETF	109.61	109.83	109.53	109.82	42299.0
2015-06-04 08:00:00	QQQ	ETF	109.62	109.95	109.62	109.84	153807.0
2015-06-04 09:00:00	QQQ	ETF	109.84	110.33	109.7	110.27	3885169.0
2015-06-04 10:00:00	QQQ	ETF	110.26	110.48	109.97	110.0	2902916.0
2015-06-04 11:00:00	QQQ	ETF	110.0	110.12	109.71	109.8	3354797.0
2015-06-04 12:00:00	QQQ	ETF	109.81	109.9	109.73	109.75	1280689.0
2015-06-04 13:00:00	QQQ	ETF	109.74	109.74	109.25	109.31	4726896.0
2015-06-04 14:00:00	QQQ	ETF	109.31	109.56	109.21	109.47	2679683.0
2015-06-04 15:00:00	QQQ	ETF	109.46	109.61	109.315	109.58	4467448.0
2015-06-04 16:00:00	QQQ	ETF	109.58	110.3192	109.56	109.73	1721945.0
2015-06-04 17:00:00	QQQ	ETF	109.73	109.75	109.72	109.72	89500.0
2015-06-04 18:00:00	QQQ	ETF	109.73	109.781	109.72	109.74	97265.0
2015-06-04 19:00:00	QQQ	ETF	109.7	109.72	109.69	109.72	5500.0
2015-06-04 04:00:00	IWM	ETF	125.54	125.54	125.0	125.06	1350.0
2015-06-04 05:00:00	IWM	ETF	125.11	125.11	125.1	125.1	200.0
2015-06-04 06:00:00	IWM	ETF	125.03	125.34	125.02	125.34	1105.0
2015-06-04 07:00:00	IWM	ETF	125.19	125.33	125.07	125.33	18266.0
2015-06-04 08:00:00	IWM	ETF	125.43	125.48	125.21	125.23	155589.0
2015-06-04 09:00:00	IWM	ETF	125.2	125.48	124.93	125.42	3265935.0
2015-06-04 10:00:00	IWM	ETF	125.41	125.62	124.99	125.08	3084300.0
2015-06-04 11:00:00	IWM	ETF	125.06	125.29	124.84	125.06	2275091.0
2015-06-04 12:00:00	IWM	ETF	125.06	125.11	124.91	124.98	1359633.0
2015-06-04 13:00:00	IWM	ETF	124.98	124.99	124.139	124.3	4225520.0
2015-06-04 14:00:00	IWM	ETF	124.295	124.52	124.08	124.46	2515851.0
2015-06-04 15:00:00	IWM	ETF	124.46	124.56	124.33	124.54	3626923.0
2015-06-04 16:00:00	IWM	ETF	124.55	125.8012	124.5	124.61	1128068.0
2015-06-04 17:00:00	IWM	ETF	124.6	124.7	124.6	124.7	1219.0
2015-06-04 18:00:00	IWM	ETF	124.6	124.6	124.55	124.6	1025.0
2015-06-04 19:00:00	IWM	ETF	124.65	124.65	124.65	124.65	300.0
2015-06-04 04:00:00	DIA	ETF	179.88	179.88	179.88	179.88	100.0
2015-06-04 08:00:00	DIA	ETF	180.25	180.55	180.2	180.49	14746.0

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

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