PREVIEW / etf_30min / 2016-04-12

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-12.parquet
  size:    404 KB
  rows:    13,534

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-04-12 04:00:00	SPY	ETF	203.98	204.14	203.69	203.88	177599.0
2016-04-12 04:30:00	SPY	ETF	203.92	204.3	203.8	204.25	76701.0
2016-04-12 05:00:00	SPY	ETF	204.2	204.49	204.2	204.42	7412.0
2016-04-12 05:30:00	SPY	ETF	204.45	204.61	204.43	204.55	12185.0
2016-04-12 06:00:00	SPY	ETF	204.54	204.74	204.53	204.53	13750.0
2016-04-12 06:30:00	SPY	ETF	204.55	204.6	204.45	204.6	19405.0
2016-04-12 07:00:00	SPY	ETF	204.6	204.71	204.26	204.36	58438.0
2016-04-12 07:30:00	SPY	ETF	204.33	204.53	204.33	204.44	197828.0
2016-04-12 08:00:00	SPY	ETF	204.46	204.67	203.935	204.37	377077.0
2016-04-12 08:30:00	SPY	ETF	204.37	204.6	204.17	204.26	482131.0
2016-04-12 09:00:00	SPY	ETF	204.24	204.27	204.05	204.2	488068.0
2016-04-12 09:30:00	SPY	ETF	204.22	204.78	204.08	204.48	7644350.0
2016-04-12 10:00:00	SPY	ETF	204.5	204.65	203.7	203.86	8850216.0
2016-04-12 10:30:00	SPY	ETF	203.86	205.08	203.85	205.0	12736343.0
2016-04-12 11:00:00	SPY	ETF	205.0	205.57	204.8799	205.4	8846698.0
2016-04-12 11:30:00	SPY	ETF	205.41	205.57	205.27	205.29	6426746.0
2016-04-12 12:00:00	SPY	ETF	205.29	205.4	205.165	205.3838	2690042.0
2016-04-12 12:30:00	SPY	ETF	205.38	205.73	205.38	205.6	4489237.0
2016-04-12 13:00:00	SPY	ETF	205.61	205.66	205.35	205.445	4398517.0
2016-04-12 13:30:00	SPY	ETF	205.445	205.7	205.3	205.67	5494386.0
2016-04-12 14:00:00	SPY	ETF	205.66	205.92	205.56	205.72	5455227.0
2016-04-12 14:30:00	SPY	ETF	205.73	206.0	205.7	205.96	8385357.0
2016-04-12 15:00:00	SPY	ETF	205.96	206.25	205.87	205.99	9310382.0
2016-04-12 15:30:00	SPY	ETF	205.99	206.15	205.64	205.94	14656404.0
2016-04-12 16:00:00	SPY	ETF	205.97	206.07	205.75	206.05	6020474.0
2016-04-12 16:30:00	SPY	ETF	206.04	206.04	205.83	205.95	1631617.0
2016-04-12 17:00:00	SPY	ETF	205.97	206.01	203.8877	205.96	148985.0
2016-04-12 17:30:00	SPY	ETF	205.97	206.04	205.94	205.97	263397.0
2016-04-12 18:00:00	SPY	ETF	205.98	205.98	205.85	205.91	184493.0
2016-04-12 18:30:00	SPY	ETF	205.91	205.96	205.91	205.96	14950.0
2016-04-12 19:00:00	SPY	ETF	205.94	206.02	205.9	206.02	10010.0
2016-04-12 19:30:00	SPY	ETF	205.9094	206.08	205.9094	206.07	807080.0
2016-04-12 04:00:00	QQQ	ETF	108.65	108.65	108.45	108.45	3200.0
2016-04-12 04:30:00	QQQ	ETF	108.51	108.71	108.45	108.71	600.0
2016-04-12 05:00:00	QQQ	ETF	108.89	108.89	108.89	108.89	100.0
2016-04-12 05:30:00	QQQ	ETF	109.02	109.05	108.97	109.05	1500.0
2016-04-12 06:00:00	QQQ	ETF	109.09	109.1	109.09	109.1	800.0
2016-04-12 06:30:00	QQQ	ETF	108.98	108.99	108.98	108.99	2000.0
2016-04-12 07:00:00	QQQ	ETF	109.03	109.07	108.81	108.85	20976.0
2016-04-12 07:30:00	QQQ	ETF	108.89	108.93	108.86	108.92	70491.0
2016-04-12 08:00:00	QQQ	ETF	109.05	109.05	108.84	108.85	178387.0
2016-04-12 08:30:00	QQQ	ETF	108.83	108.95	108.72	108.76	32721.0
2016-04-12 09:00:00	QQQ	ETF	108.75	108.75	108.63	108.67	75243.0
2016-04-12 09:30:00	QQQ	ETF	108.66	108.82	108.42	108.4862	3253593.0
2016-04-12 10:00:00	QQQ	ETF	108.49	108.7	108.015	108.15	2338646.0
2016-04-12 10:30:00	QQQ	ETF	108.15	108.93	108.14	108.9	3042456.0
2016-04-12 11:00:00	QQQ	ETF	108.9	109.27	108.81	109.1105	2186473.0
2016-04-12 11:30:00	QQQ	ETF	109.12	109.23	108.91	108.95	1262595.0
2016-04-12 12:00:00	QQQ	ETF	108.96	109.09	108.9364	109.06	632119.0
2016-04-12 12:30:00	QQQ	ETF	109.06	109.3099	109.06	109.19	1059061.0

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

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