PREVIEW / etf_30min / 2016-08-03

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-03.parquet
  size:    392 KB
  rows:    13,232

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-08-03 04:00:00	SPY	ETF	215.3	215.3	215.05	215.28	37375.0
2016-08-03 04:30:00	SPY	ETF	215.29	215.33	215.13	215.2	9365.0
2016-08-03 05:00:00	SPY	ETF	215.2	215.31	215.1	215.26	37854.0
2016-08-03 05:30:00	SPY	ETF	215.33	215.36	215.25	215.32	15211.0
2016-08-03 06:00:00	SPY	ETF	215.27	215.33	215.23	215.26	25110.0
2016-08-03 06:30:00	SPY	ETF	215.25	215.32	215.24	215.24	50385.0
2016-08-03 07:00:00	SPY	ETF	215.29	215.31	215.18	215.22	204027.0
2016-08-03 07:30:00	SPY	ETF	215.2	215.37	215.19	215.35	67141.0
2016-08-03 08:00:00	SPY	ETF	215.35	215.49	215.08	215.41	326168.0
2016-08-03 08:30:00	SPY	ETF	215.41	215.42	215.28	215.34	229583.0
2016-08-03 09:00:00	SPY	ETF	215.35	215.5	215.29	215.47	237452.0
2016-08-03 09:30:00	SPY	ETF	215.48	215.74	215.13	215.58	7355263.0
2016-08-03 10:00:00	SPY	ETF	215.58	215.915	215.48	215.69	4639314.0
2016-08-03 10:30:00	SPY	ETF	215.69	215.96	215.47	215.66	4920723.0
2016-08-03 11:00:00	SPY	ETF	215.65	215.92	215.53	215.755	2544146.0
2016-08-03 11:30:00	SPY	ETF	215.76	215.89	215.62	215.87	2101731.0
2016-08-03 12:00:00	SPY	ETF	215.86	215.91	215.76	215.84	1647234.0
2016-08-03 12:30:00	SPY	ETF	215.8399	216.04	215.76	215.95	2386650.0
2016-08-03 13:00:00	SPY	ETF	215.9501	216.04	215.89	215.98	1506236.0
2016-08-03 13:30:00	SPY	ETF	215.98	216.015	215.76	215.86	3086243.0
2016-08-03 14:00:00	SPY	ETF	215.8611	215.94	215.6301	215.6363	2210746.0
2016-08-03 14:30:00	SPY	ETF	215.63	215.81	215.57	215.73	2077137.0
2016-08-03 15:00:00	SPY	ETF	215.73	216.02	215.68	215.99	3876185.0
2016-08-03 15:30:00	SPY	ETF	216.0	216.245	215.87	216.21	7153458.0
2016-08-03 16:00:00	SPY	ETF	216.21	216.2631	215.94	216.1	4713809.0
2016-08-03 16:30:00	SPY	ETF	216.1	216.23	216.1	216.12	322762.0
2016-08-03 17:00:00	SPY	ETF	216.11	216.13	216.0	216.01	1165306.0
2016-08-03 17:30:00	SPY	ETF	216.01	216.18	215.98	216.05	95599.0
2016-08-03 18:00:00	SPY	ETF	216.05	216.18	216.02	216.15	199351.0
2016-08-03 18:30:00	SPY	ETF	216.12	216.13	216.08	216.08	10419.0
2016-08-03 19:00:00	SPY	ETF	216.09	216.14	216.09	216.14	552.0
2016-08-03 19:30:00	SPY	ETF	216.14	216.2628	216.14	216.23	1530359.0
2016-08-03 04:00:00	QQQ	ETF	114.81	114.81	114.69	114.74	2700.0
2016-08-03 04:30:00	QQQ	ETF	114.74	114.74	114.7	114.7	3500.0
2016-08-03 05:30:00	QQQ	ETF	114.77	114.79	114.76	114.79	2599.0
2016-08-03 06:00:00	QQQ	ETF	114.78	114.82	114.78	114.82	2450.0
2016-08-03 06:30:00	QQQ	ETF	114.77	114.77	114.73	114.73	1150.0
2016-08-03 07:00:00	QQQ	ETF	114.77	114.77	114.71	114.74	76188.0
2016-08-03 07:30:00	QQQ	ETF	114.74	114.79	114.72	114.79	3300.0
2016-08-03 08:00:00	QQQ	ETF	114.79	114.96	114.73	114.84	15703.0
2016-08-03 08:30:00	QQQ	ETF	114.82	114.83	114.78	114.79	42078.0
2016-08-03 09:00:00	QQQ	ETF	114.8	114.87	114.79	114.87	98450.0
2016-08-03 09:30:00	QQQ	ETF	114.87	115.175	114.8005	115.1	2716352.0
2016-08-03 10:00:00	QQQ	ETF	115.09	115.27	114.97	115.1	886507.0
2016-08-03 10:30:00	QQQ	ETF	115.095	115.22	114.94	114.96	915313.0
2016-08-03 11:00:00	QQQ	ETF	114.97	115.09	114.941	114.98	370572.0
2016-08-03 11:30:00	QQQ	ETF	114.975	115.09	114.9	115.07	485106.0
2016-08-03 12:00:00	QQQ	ETF	115.0799	115.08	114.92	114.94	550236.0
2016-08-03 12:30:00	QQQ	ETF	114.95	115.11	114.9	115.03	502157.0
2016-08-03 13:00:00	QQQ	ETF	115.03	115.13	114.9901	115.12	277776.0

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

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