PREVIEW / etf_30min / 2016-02-18

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-18.parquet
  size:    392 KB
  rows:    13,178

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-02-18 04:00:00	SPY	ETF	192.56	192.9	192.47	192.88	12859.0
2016-02-18 04:30:00	SPY	ETF	192.93	193.0	192.71	192.74	4975.0
2016-02-18 05:00:00	SPY	ETF	192.77	193.02	192.71	192.83	9985.0
2016-02-18 05:30:00	SPY	ETF	192.96	193.41	192.96	193.32	21969.0
2016-02-18 06:00:00	SPY	ETF	193.35	193.92	193.35	193.88	69169.0
2016-02-18 06:30:00	SPY	ETF	193.84	193.84	193.51	193.54	51601.0
2016-02-18 07:00:00	SPY	ETF	193.54	193.71	193.4	193.43	185883.0
2016-02-18 07:30:00	SPY	ETF	193.42	193.46	193.19	193.44	269005.0
2016-02-18 08:00:00	SPY	ETF	193.42	193.65	193.22	193.32	321113.0
2016-02-18 08:30:00	SPY	ETF	193.34	193.5	193.22	193.42	528094.0
2016-02-18 09:00:00	SPY	ETF	193.45	193.48	193.12	193.2	661654.0
2016-02-18 09:30:00	SPY	ETF	193.2	193.27	192.43	192.72	12777078.0
2016-02-18 10:00:00	SPY	ETF	192.73	192.99	192.38	192.955	8457377.0
2016-02-18 10:30:00	SPY	ETF	192.9535	192.99	192.13	192.38	5392995.0
2016-02-18 11:00:00	SPY	ETF	192.37	193.19	191.8	192.21	11457562.0
2016-02-18 11:30:00	SPY	ETF	192.22	193.22	192.08	192.66	5918843.0
2016-02-18 12:00:00	SPY	ETF	192.66	192.82	192.47	192.65	5521509.0
2016-02-18 12:30:00	SPY	ETF	192.655	192.7	192.35	192.3668	3680869.0
2016-02-18 13:00:00	SPY	ETF	192.37	192.62	192.1	192.225	4550929.0
2016-02-18 13:30:00	SPY	ETF	192.225	192.32	191.75	192.05	4312645.0
2016-02-18 14:00:00	SPY	ETF	192.04	192.51	192.01	192.47	5290180.0
2016-02-18 14:30:00	SPY	ETF	192.46	192.79	192.435	192.58	5496412.0
2016-02-18 15:00:00	SPY	ETF	192.587	192.68	191.98	192.17	7913398.0
2016-02-18 15:30:00	SPY	ETF	192.1701	192.31	191.72	192.04	13667213.0
2016-02-18 16:00:00	SPY	ETF	192.04	192.6009	191.99	192.26	3991755.0
2016-02-18 16:30:00	SPY	ETF	192.24	192.4	192.05	192.4	490154.0
2016-02-18 17:00:00	SPY	ETF	192.4	192.4	192.2306	192.31	556412.0
2016-02-18 17:30:00	SPY	ETF	192.33	192.34	192.3	192.31	22982.0
2016-02-18 18:00:00	SPY	ETF	192.32	192.34	192.14	192.21	56230.0
2016-02-18 18:30:00	SPY	ETF	192.18	192.35	192.16	192.26	21016.0
2016-02-18 19:00:00	SPY	ETF	192.3	192.34	192.17	192.25	34476.0
2016-02-18 19:30:00	SPY	ETF	192.23	192.26	191.96	191.98	84634.0
2016-02-18 20:00:00	SPY	ETF	192.0172	192.0172	192.0172	192.0172	562000.0
2016-02-18 04:00:00	QQQ	ETF	102.49	102.54	102.49	102.54	700.0
2016-02-18 04:30:00	QQQ	ETF	102.57	102.57	102.57	102.57	200.0
2016-02-18 05:00:00	QQQ	ETF	102.54	102.66	102.54	102.66	1600.0
2016-02-18 05:30:00	QQQ	ETF	102.77	102.82	102.77	102.82	1400.0
2016-02-18 06:00:00	QQQ	ETF	102.96	103.16	102.96	103.16	1344.0
2016-02-18 06:30:00	QQQ	ETF	103.18	103.18	102.98	103.0	20955.0
2016-02-18 07:00:00	QQQ	ETF	103.03	103.11	102.95	102.95	42514.0
2016-02-18 07:30:00	QQQ	ETF	102.99	102.99	102.83	102.91	25860.0
2016-02-18 08:00:00	QQQ	ETF	102.95	103.01	102.86	102.89	75279.0
2016-02-18 08:30:00	QQQ	ETF	102.9	102.98	102.83	102.95	51203.0
2016-02-18 09:00:00	QQQ	ETF	102.95	102.95	102.75	102.8	107779.0
2016-02-18 09:30:00	QQQ	ETF	102.81	102.84	102.19	102.29	4951401.0
2016-02-18 10:00:00	QQQ	ETF	102.29	102.38	102.03	102.35	2990220.0
2016-02-18 10:30:00	QQQ	ETF	102.36	102.37	101.82	101.85	1813218.0
2016-02-18 11:00:00	QQQ	ETF	101.85	101.939	101.59	101.85	3765366.0
2016-02-18 11:30:00	QQQ	ETF	101.855	102.16	101.75	102.12	1460871.0
2016-02-18 12:00:00	QQQ	ETF	102.13	102.16	101.9489	102.07	1346461.0

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

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