PREVIEW / etf_1hour / 2015-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-17.parquet
  size:    240 KB
  rows:    7,565

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-17 04:00:00	SPY	ETF	210.77	211.13	210.77	211.06	12796.0
2015-06-17 05:00:00	SPY	ETF	211.07	211.07	210.82	210.98	20322.0
2015-06-17 06:00:00	SPY	ETF	210.96	210.98	210.64	210.69	35773.0
2015-06-17 07:00:00	SPY	ETF	210.66	210.82	210.41	210.47	383156.0
2015-06-17 08:00:00	SPY	ETF	210.47	210.75	210.44	210.65	445540.0
2015-06-17 09:00:00	SPY	ETF	210.65	210.99	210.25	210.71	10089237.0
2015-06-17 10:00:00	SPY	ETF	210.71	210.835	210.48	210.707	10017313.0
2015-06-17 11:00:00	SPY	ETF	210.71	210.76	210.13	210.33	19819097.0
2015-06-17 12:00:00	SPY	ETF	210.32	210.35	209.49	209.645	8916794.0
2015-06-17 13:00:00	SPY	ETF	209.645	210.03	209.55	209.92	8711673.0
2015-06-17 14:00:00	SPY	ETF	209.93	211.32	209.36	211.07	37954611.0
2015-06-17 15:00:00	SPY	ETF	211.07	211.17	210.58	210.62	23770201.0
2015-06-17 16:00:00	SPY	ETF	210.63	210.8912	210.14	210.263	5466510.0
2015-06-17 17:00:00	SPY	ETF	210.26	210.34	210.253	210.31	91130.0
2015-06-17 18:00:00	SPY	ETF	210.32	210.32	210.26	210.31	23050.0
2015-06-17 19:00:00	SPY	ETF	210.33	210.41	210.33	210.4	12194.0
2015-06-17 04:00:00	QQQ	ETF	109.09	109.17	109.09	109.17	6450.0
2015-06-17 06:00:00	QQQ	ETF	109.01	109.03	108.98	109.0	19999.0
2015-06-17 07:00:00	QQQ	ETF	108.96	109.04	108.83	108.83	79100.0
2015-06-17 08:00:00	QQQ	ETF	108.86	109.01	108.85	108.99	74192.0
2015-06-17 09:00:00	QQQ	ETF	108.97	109.21	108.8	109.1	1740973.0
2015-06-17 10:00:00	QQQ	ETF	109.11	109.18	109.03	109.17	1544578.0
2015-06-17 11:00:00	QQQ	ETF	109.17	109.2	108.7599	108.89	2213795.0
2015-06-17 12:00:00	QQQ	ETF	108.89	108.91	108.43	108.5	2115461.0
2015-06-17 13:00:00	QQQ	ETF	108.49	108.74	108.46	108.66	1567267.0
2015-06-17 14:00:00	QQQ	ETF	108.66	109.45	108.43	109.37	6743437.0
2015-06-17 15:00:00	QQQ	ETF	109.39	109.43	109.1	109.1	3159737.0
2015-06-17 16:00:00	QQQ	ETF	109.08	109.15	108.84	108.88	879377.0
2015-06-17 17:00:00	QQQ	ETF	108.89	108.94	108.87	108.94	12250.0
2015-06-17 18:00:00	QQQ	ETF	108.87	108.9	108.84	108.88	3400.0
2015-06-17 19:00:00	QQQ	ETF	108.89	108.94	108.89	108.91	13525.0
2015-06-17 04:00:00	IWM	ETF	126.65	126.65	126.65	126.65	100.0
2015-06-17 07:00:00	IWM	ETF	126.57	126.62	126.46	126.51	16599.0
2015-06-17 08:00:00	IWM	ETF	126.53	126.74	126.42	126.74	71408.0
2015-06-17 09:00:00	IWM	ETF	126.63	126.96	126.42	126.91	1518363.0
2015-06-17 10:00:00	IWM	ETF	126.91	126.95	126.54	126.74	1681816.0
2015-06-17 11:00:00	IWM	ETF	126.74	126.77	126.31	126.44	1624253.0
2015-06-17 12:00:00	IWM	ETF	126.45	126.47	125.98	126.16	2185885.0
2015-06-17 13:00:00	IWM	ETF	126.16	126.39	126.085	126.32	2414622.0
2015-06-17 14:00:00	IWM	ETF	126.23	126.84	125.97	126.56	6068791.0
2015-06-17 15:00:00	IWM	ETF	126.57	126.61	126.18	126.22	4252145.0
2015-06-17 16:00:00	IWM	ETF	126.23	126.31	126.04	126.08	2259601.0
2015-06-17 17:00:00	IWM	ETF	126.09	126.09	126.02	126.02	17418.0
2015-06-17 18:00:00	IWM	ETF	126.06	126.06	126.0	126.0	3000.0
2015-06-17 19:00:00	IWM	ETF	126.11	126.11	126.11	126.11	100.0
2015-06-17 08:00:00	DIA	ETF	179.25	179.59	179.25	179.59	430.0
2015-06-17 09:00:00	DIA	ETF	179.6	179.9	179.46	179.59	396969.0
2015-06-17 10:00:00	DIA	ETF	179.59	179.685	179.36	179.63	279368.0
2015-06-17 11:00:00	DIA	ETF	179.63	179.67	179.21	179.42	347412.0
2015-06-17 12:00:00	DIA	ETF	179.41	179.41	178.65	178.77	454504.0

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

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