PREVIEW / etf_30min / 2016-10-10

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-10.parquet
  size:    382 KB
  rows:    12,961

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-10-10 04:00:00	SPY	ETF	215.25	215.5	215.25	215.26	4799.0
2016-10-10 04:30:00	SPY	ETF	215.4	215.59	215.4	215.58	37173.0
2016-10-10 05:00:00	SPY	ETF	215.52	215.71	215.52	215.68	7321.0
2016-10-10 05:30:00	SPY	ETF	215.68	215.77	215.68	215.75	2635.0
2016-10-10 06:00:00	SPY	ETF	215.76	215.84	215.75	215.79	5858.0
2016-10-10 06:30:00	SPY	ETF	215.74	215.79	215.72	215.76	5487.0
2016-10-10 07:00:00	SPY	ETF	215.8	216.04	215.77	215.87	79463.0
2016-10-10 07:30:00	SPY	ETF	215.89	216.13	215.87	215.92	86399.0
2016-10-10 08:00:00	SPY	ETF	215.93	216.05	215.85	215.97	154441.0
2016-10-10 08:30:00	SPY	ETF	215.98	216.27	215.96	216.19	454519.0
2016-10-10 09:00:00	SPY	ETF	216.19	216.22	216.01	216.15	417436.0
2016-10-10 09:30:00	SPY	ETF	216.155	216.7	216.14	216.6	8450577.0
2016-10-10 10:00:00	SPY	ETF	216.6	216.68	216.48	216.53	4157727.0
2016-10-10 10:30:00	SPY	ETF	216.54	216.69	216.54	216.62	3309780.0
2016-10-10 11:00:00	SPY	ETF	216.615	216.66	216.45	216.5	3870070.0
2016-10-10 11:30:00	SPY	ETF	216.5	216.55	216.36	216.43	2235619.0
2016-10-10 12:00:00	SPY	ETF	216.43	216.46	216.07	216.2	2457704.0
2016-10-10 12:30:00	SPY	ETF	216.1959	216.3	216.17	216.25	2234974.0
2016-10-10 13:00:00	SPY	ETF	216.2499	216.45	216.21	216.36	1411110.0
2016-10-10 13:30:00	SPY	ETF	216.36	216.43	216.2	216.26	1268032.0
2016-10-10 14:00:00	SPY	ETF	216.265	216.33	216.16	216.25	1645775.0
2016-10-10 14:30:00	SPY	ETF	216.24	216.38	216.2	216.26	3656726.0
2016-10-10 15:00:00	SPY	ETF	216.255	216.32	216.13	216.19	2194833.0
2016-10-10 15:30:00	SPY	ETF	216.19	216.22	215.985	216.11	7027501.0
2016-10-10 16:00:00	SPY	ETF	216.11	216.29	215.98	216.26	3956141.0
2016-10-10 16:30:00	SPY	ETF	216.26	216.34	216.16	216.31	325146.0
2016-10-10 17:00:00	SPY	ETF	216.3	216.32	216.26	216.27	30947.0
2016-10-10 17:30:00	SPY	ETF	216.28	216.3	216.16	216.3	72107.0
2016-10-10 18:00:00	SPY	ETF	216.3	216.37	216.16	216.16	29983.0
2016-10-10 18:30:00	SPY	ETF	216.35	216.41	216.35	216.41	26276.0
2016-10-10 19:00:00	SPY	ETF	216.42	216.43	216.4	216.42	26231.0
2016-10-10 19:30:00	SPY	ETF	216.4	216.42	216.33	216.42	82474.0
2016-10-10 04:00:00	QQQ	ETF	118.65	118.66	118.59	118.59	5529.0
2016-10-10 04:30:00	QQQ	ETF	118.63	118.65	118.63	118.65	10200.0
2016-10-10 05:00:00	QQQ	ETF	118.79	118.79	118.77	118.77	700.0
2016-10-10 05:30:00	QQQ	ETF	118.78	118.8	118.78	118.8	405.0
2016-10-10 06:00:00	QQQ	ETF	118.87	118.87	118.87	118.87	1000.0
2016-10-10 07:00:00	QQQ	ETF	118.88	118.91	118.88	118.91	14381.0
2016-10-10 07:30:00	QQQ	ETF	118.89	118.99	118.89	118.92	32326.0
2016-10-10 08:00:00	QQQ	ETF	118.9	118.97	118.9	118.95	21155.0
2016-10-10 08:30:00	QQQ	ETF	118.96	119.08	118.96	119.03	48183.0
2016-10-10 09:00:00	QQQ	ETF	119.04	119.07	119.0	119.06	185110.0
2016-10-10 09:30:00	QQQ	ETF	119.06	119.42	119.03	119.38	2357412.0
2016-10-10 10:00:00	QQQ	ETF	119.385	119.43	119.32	119.34	1415630.0
2016-10-10 10:30:00	QQQ	ETF	119.35	119.48	119.35	119.455	1101948.0
2016-10-10 11:00:00	QQQ	ETF	119.455	119.475	119.32	119.3336	823341.0
2016-10-10 11:30:00	QQQ	ETF	119.335	119.44	119.3252	119.39	664759.0
2016-10-10 12:00:00	QQQ	ETF	119.39	119.4	119.22	119.27	701718.0
2016-10-10 12:30:00	QQQ	ETF	119.27	119.35	119.26	119.34	560199.0
2016-10-10 13:00:00	QQQ	ETF	119.34	119.44	119.32	119.35	840061.0

> showing 50 of 12,961 rows — these rows as CSV

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