PREVIEW / etf_1hour / 2015-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-05-19.parquet
  size:    243 KB
  rows:    7,763

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-19 04:00:00	SPY	ETF	213.55	213.76	213.51	213.69	13035.0
2015-05-19 05:00:00	SPY	ETF	213.68	213.81	213.67	213.75	41282.0
2015-05-19 06:00:00	SPY	ETF	213.77	213.79	213.67	213.67	33856.0
2015-05-19 07:00:00	SPY	ETF	213.71	213.72	213.55	213.66	202345.0
2015-05-19 08:00:00	SPY	ETF	213.66	213.72	213.1	213.42	774456.0
2015-05-19 09:00:00	SPY	ETF	213.4	213.46	212.8	213.07	10796655.0
2015-05-19 10:00:00	SPY	ETF	213.07	213.31	212.86	213.08	9640986.0
2015-05-19 11:00:00	SPY	ETF	213.08	213.36	212.93	213.19	6822367.0
2015-05-19 12:00:00	SPY	ETF	213.19	213.3	213.08	213.2	3892458.0
2015-05-19 13:00:00	SPY	ETF	213.2	213.57	213.15	213.45	4960165.0
2015-05-19 14:00:00	SPY	ETF	213.455	213.49	212.97	213.18	6711741.0
2015-05-19 15:00:00	SPY	ETF	213.18	213.19	212.69	213.01	19840123.0
2015-05-19 16:00:00	SPY	ETF	213.02	213.0932	212.91	212.98	7923355.0
2015-05-19 17:00:00	SPY	ETF	212.97	212.99	212.93	212.96	47567.0
2015-05-19 18:00:00	SPY	ETF	212.95	212.99	212.93	212.98	40266.0
2015-05-19 19:00:00	SPY	ETF	212.98	212.99	212.95	212.98	12154.0
2015-05-19 04:00:00	QQQ	ETF	110.38	110.38	110.38	110.38	1000.0
2015-05-19 05:00:00	QQQ	ETF	110.41	110.42	110.41	110.42	18200.0
2015-05-19 06:00:00	QQQ	ETF	110.38	110.48	110.38	110.48	7100.0
2015-05-19 07:00:00	QQQ	ETF	110.42	110.46	110.36	110.46	55928.0
2015-05-19 08:00:00	QQQ	ETF	110.45	110.47	110.24	110.28	83438.0
2015-05-19 09:00:00	QQQ	ETF	110.28	110.35	110.04	110.21	2703213.0
2015-05-19 10:00:00	QQQ	ETF	110.205	110.28	109.92	110.0	2245199.0
2015-05-19 11:00:00	QQQ	ETF	110.0	110.11	109.8899	110.02	1264353.0
2015-05-19 12:00:00	QQQ	ETF	110.0199	110.08	109.93	110.04	657700.0
2015-05-19 13:00:00	QQQ	ETF	110.05	110.22	109.97	110.155	849007.0
2015-05-19 14:00:00	QQQ	ETF	110.15	110.21	109.93	110.04	1429726.0
2015-05-19 15:00:00	QQQ	ETF	110.0469	110.05	109.76	109.91	2807462.0
2015-05-19 16:00:00	QQQ	ETF	109.91	109.94	109.83	109.88	227634.0
2015-05-19 17:00:00	QQQ	ETF	109.87	109.88	109.86	109.87	9371.0
2015-05-19 18:00:00	QQQ	ETF	109.84	109.87	109.83	109.87	20563.0
2015-05-19 19:00:00	QQQ	ETF	109.86	109.86	109.83	109.83	2100.0
2015-05-19 04:00:00	IWM	ETF	125.26	125.26	125.26	125.26	100.0
2015-05-19 06:00:00	IWM	ETF	125.31	125.31	125.31	125.31	200.0
2015-05-19 07:00:00	IWM	ETF	125.11	125.25	124.99	125.25	6000.0
2015-05-19 08:00:00	IWM	ETF	125.231	125.37	125.04	125.07	120231.0
2015-05-19 09:00:00	IWM	ETF	125.08	125.1	124.5	124.67	3045637.0
2015-05-19 10:00:00	IWM	ETF	124.66	124.82	124.31	124.441	3042695.0
2015-05-19 11:00:00	IWM	ETF	124.441	124.8	124.42	124.71	2124333.0
2015-05-19 12:00:00	IWM	ETF	124.7	124.79	124.64	124.78	618869.0
2015-05-19 13:00:00	IWM	ETF	124.77	125.05	124.73	124.94	1081624.0
2015-05-19 14:00:00	IWM	ETF	124.95	124.99	124.74	124.84	1394392.0
2015-05-19 15:00:00	IWM	ETF	124.84	124.9	124.57	124.89	3045922.0
2015-05-19 16:00:00	IWM	ETF	124.9	124.98	124.8	124.97	2972332.0
2015-05-19 17:00:00	IWM	ETF	124.96	124.96	124.94	124.94	680.0
2015-05-19 18:00:00	IWM	ETF	124.8	124.86	124.8	124.86	800.0
2015-05-19 19:00:00	IWM	ETF	124.86	124.86	124.85	124.85	5600.0
2015-05-19 04:00:00	DIA	ETF	182.89	182.89	182.89	182.89	710.0
2015-05-19 06:00:00	DIA	ETF	183.28	183.29	183.06	183.06	1980.0
2015-05-19 08:00:00	DIA	ETF	183.29	183.29	182.88	183.02	13199.0

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

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