PREVIEW / etf_1hour / 2015-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-12.parquet
  size:    230 KB
  rows:    7,331

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-12 04:00:00	SPY	ETF	211.21	211.21	210.9	211.03	33695.0
2015-06-12 05:00:00	SPY	ETF	210.95	211.45	210.95	211.45	43832.0
2015-06-12 06:00:00	SPY	ETF	211.28	211.48	211.03	211.13	49300.0
2015-06-12 07:00:00	SPY	ETF	211.16	211.19	210.62	210.85	488884.0
2015-06-12 08:00:00	SPY	ETF	210.86	210.99	210.68	210.77	766527.0
2015-06-12 09:00:00	SPY	ETF	210.77	210.84	210.13	210.41	18690983.0
2015-06-12 10:00:00	SPY	ETF	210.42	210.73	209.71	209.75	26114108.0
2015-06-12 11:00:00	SPY	ETF	209.75	210.54	209.68	210.07	20494066.0
2015-06-12 12:00:00	SPY	ETF	210.065	210.17	209.89	209.96	10264745.0
2015-06-12 13:00:00	SPY	ETF	209.9657	210.3	209.92	210.1887	8251960.0
2015-06-12 14:00:00	SPY	ETF	210.19	211.482	209.72	209.76	15415074.0
2015-06-12 15:00:00	SPY	ETF	209.76	210.2	209.72	210.0	19189797.0
2015-06-12 16:00:00	SPY	ETF	209.99	211.4734	209.83	210.01	13183876.0
2015-06-12 17:00:00	SPY	ETF	210.01	210.1389	209.96	210.0	162601.0
2015-06-12 18:00:00	SPY	ETF	209.97	210.05	209.97	209.99	26340.0
2015-06-12 19:00:00	SPY	ETF	210.0	210.0	209.95	209.99	13436.0
2015-06-12 04:00:00	QQQ	ETF	109.46	109.46	109.24	109.24	9750.0
2015-06-12 05:00:00	QQQ	ETF	109.23	109.53	109.22	109.53	2055.0
2015-06-12 06:00:00	QQQ	ETF	109.49	109.55	109.49	109.55	900.0
2015-06-12 07:00:00	QQQ	ETF	109.4	109.4	109.01	109.15	50322.0
2015-06-12 08:00:00	QQQ	ETF	109.08	109.21	109.05	109.05	282331.0
2015-06-12 09:00:00	QQQ	ETF	109.05	109.29	108.87	109.01	3945080.0
2015-06-12 10:00:00	QQQ	ETF	109.03	109.3	108.65	108.67	5136829.0
2015-06-12 11:00:00	QQQ	ETF	108.66	109.03	108.6	108.795	2858370.0
2015-06-12 12:00:00	QQQ	ETF	108.795	108.9099	108.68	108.8	3134558.0
2015-06-12 13:00:00	QQQ	ETF	108.805	108.95	108.77	108.91	1481714.0
2015-06-12 14:00:00	QQQ	ETF	108.915	108.93	108.66	108.67	1340060.0
2015-06-12 15:00:00	QQQ	ETF	108.66	108.915	108.65	108.75	3360152.0
2015-06-12 16:00:00	QQQ	ETF	108.76	108.81	108.67	108.79	483247.0
2015-06-12 17:00:00	QQQ	ETF	108.8	108.82	108.74	108.74	11455.0
2015-06-12 18:00:00	QQQ	ETF	108.85	108.85	108.85	108.85	200.0
2015-06-12 19:00:00	QQQ	ETF	108.74	108.74	108.74	108.74	400.0
2015-06-12 04:00:00	IWM	ETF	126.11	126.11	126.11	126.11	100.0
2015-06-12 07:00:00	IWM	ETF	125.89	125.98	125.87	125.98	3599.0
2015-06-12 08:00:00	IWM	ETF	125.98	126.08	125.84	125.93	98718.0
2015-06-12 09:00:00	IWM	ETF	125.92	126.04	125.43	125.76	2882273.0
2015-06-12 10:00:00	IWM	ETF	125.79	126.05	125.52	125.57	2925347.0
2015-06-12 11:00:00	IWM	ETF	125.57	126.15	125.51	125.93	2618017.0
2015-06-12 12:00:00	IWM	ETF	125.945	126.07	125.77	125.78	1884484.0
2015-06-12 13:00:00	IWM	ETF	125.79	125.98	125.73	125.9	1404648.0
2015-06-12 14:00:00	IWM	ETF	125.905	125.915	125.73	125.81	751787.0
2015-06-12 15:00:00	IWM	ETF	125.8	126.01	125.73	125.91	2626408.0
2015-06-12 16:00:00	IWM	ETF	125.92	126.01	125.84	126.0	1024640.0
2015-06-12 17:00:00	IWM	ETF	126.01	126.01	125.99	125.99	1000.0
2015-06-12 19:00:00	IWM	ETF	125.95	126.01	125.95	126.01	1000.0
2015-06-12 05:00:00	DIA	ETF	180.49	180.5	180.49	180.5	2000.0
2015-06-12 06:00:00	DIA	ETF	180.52	180.52	180.52	180.52	1000.0
2015-06-12 07:00:00	DIA	ETF	180.29	180.29	180.08	180.1	1700.0
2015-06-12 08:00:00	DIA	ETF	180.23	180.25	179.91	179.95	18470.0
2015-06-12 09:00:00	DIA	ETF	179.95	180.06	179.31	179.57	790499.0

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

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