PREVIEW / etf_30min / 2016-07-05

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-05.parquet
  size:    402 KB
  rows:    13,762

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
2016-07-05 04:00:00	SPY	ETF	209.21	209.21	208.74	208.74	79310.0
2016-07-05 04:30:00	SPY	ETF	208.76	208.78	208.64	208.67	21301.0
2016-07-05 05:00:00	SPY	ETF	208.75	208.89	208.74	208.78	19825.0
2016-07-05 05:30:00	SPY	ETF	208.83	208.93	208.68	208.88	7740.0
2016-07-05 06:00:00	SPY	ETF	208.84	208.95	208.83	208.92	23395.0
2016-07-05 06:30:00	SPY	ETF	209.0	209.18	208.99	209.15	23546.0
2016-07-05 07:00:00	SPY	ETF	209.15	209.2	208.86	208.95	72765.0
2016-07-05 07:30:00	SPY	ETF	208.98	209.01	208.61	208.63	266286.0
2016-07-05 08:00:00	SPY	ETF	208.63	209.15	208.55	208.72	325593.0
2016-07-05 08:30:00	SPY	ETF	208.74	209.02	208.66	208.98	292416.0
2016-07-05 09:00:00	SPY	ETF	208.99	209.01	208.79	208.96	865776.0
2016-07-05 09:30:00	SPY	ETF	208.95	209.08	208.2	208.4	13406224.0
2016-07-05 10:00:00	SPY	ETF	208.41	208.52	208.13	208.51	8329235.0
2016-07-05 10:30:00	SPY	ETF	208.51	208.77	208.28	208.375	5940555.0
2016-07-05 11:00:00	SPY	ETF	208.38	208.63	207.92	208.42	11126709.0
2016-07-05 11:30:00	SPY	ETF	208.43	208.46	208.04	208.19	4488435.0
2016-07-05 12:00:00	SPY	ETF	208.19	208.46	208.07	208.44	4650208.0
2016-07-05 12:30:00	SPY	ETF	208.43	208.449	208.06	208.2	4410724.0
2016-07-05 13:00:00	SPY	ETF	208.2	208.2816	207.98	208.0	2833954.0
2016-07-05 13:30:00	SPY	ETF	207.995	208.06	207.71	207.865	6140809.0
2016-07-05 14:00:00	SPY	ETF	207.87	208.35	207.82	208.055	8720983.0
2016-07-05 14:30:00	SPY	ETF	208.055	208.1523	207.72	208.0	4869151.0
2016-07-05 15:00:00	SPY	ETF	208.0	208.29	207.92	208.205	6530817.0
2016-07-05 15:30:00	SPY	ETF	208.2	208.8	208.15	208.43	15646141.0
2016-07-05 16:00:00	SPY	ETF	208.44	208.79	208.39	208.72	6914917.0
2016-07-05 16:30:00	SPY	ETF	208.73	208.87	208.39	208.86	666491.0
2016-07-05 17:00:00	SPY	ETF	208.83	208.85	208.41	208.66	191230.0
2016-07-05 17:30:00	SPY	ETF	208.66	208.82	208.65	208.8	51941.0
2016-07-05 18:00:00	SPY	ETF	208.8	208.84	208.52	208.56	99392.0
2016-07-05 18:30:00	SPY	ETF	208.56	208.64	208.56	208.58	48000.0
2016-07-05 19:00:00	SPY	ETF	208.6	208.7	208.46	208.47	22821.0
2016-07-05 19:30:00	SPY	ETF	208.46	208.54	208.33	208.45	153960.0
2016-07-05 04:00:00	QQQ	ETF	107.82	107.82	107.55	107.55	24444.0
2016-07-05 04:30:00	QQQ	ETF	107.51	107.51	107.45	107.45	1188.0
2016-07-05 05:00:00	QQQ	ETF	107.54	107.54	107.5	107.51	1936.0
2016-07-05 05:30:00	QQQ	ETF	107.53	107.53	107.51	107.51	399.0
2016-07-05 06:00:00	QQQ	ETF	107.52	107.59	107.52	107.59	800.0
2016-07-05 06:30:00	QQQ	ETF	107.63	107.67	107.63	107.65	700.0
2016-07-05 07:00:00	QQQ	ETF	107.67	107.7	107.55	107.57	24711.0
2016-07-05 07:30:00	QQQ	ETF	107.61	107.62	107.38	107.41	13188.0
2016-07-05 08:00:00	QQQ	ETF	107.44	107.47	107.41	107.47	27803.0
2016-07-05 08:30:00	QQQ	ETF	107.45	107.6	107.43	107.59	28223.0
2016-07-05 09:00:00	QQQ	ETF	107.59	107.59	107.46	107.58	72635.0
2016-07-05 09:30:00	QQQ	ETF	107.58	107.66	107.1	107.301	2961142.0
2016-07-05 10:00:00	QQQ	ETF	107.31	107.435	107.05	107.36	1698723.0
2016-07-05 10:30:00	QQQ	ETF	107.36	107.53	107.17	107.24	1227703.0
2016-07-05 11:00:00	QQQ	ETF	107.23	107.43	107.015	107.27	2080059.0
2016-07-05 11:30:00	QQQ	ETF	107.26	107.3	107.05	107.13	818376.0
2016-07-05 12:00:00	QQQ	ETF	107.14	107.35	107.1	107.34	588691.0
2016-07-05 12:30:00	QQQ	ETF	107.3415	107.349	107.12	107.19	383687.0

> showing 50 of 13,762 rows — these rows as CSV

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