PREVIEW / etf_30min / 2016-11-03

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-11-03.parquet
  size:    407 KB
  rows:    13,748

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-11-03 04:00:00	SPY	ETF	209.23	209.52	209.12	209.51	32500.0
2016-11-03 04:30:00	SPY	ETF	209.51	209.6	209.42	209.48	47227.0
2016-11-03 05:00:00	SPY	ETF	209.5	209.69	209.4	209.55	31084.0
2016-11-03 05:30:00	SPY	ETF	209.59	209.75	209.57	209.75	14565.0
2016-11-03 06:00:00	SPY	ETF	209.75	210.1	209.65	209.79	40265.0
2016-11-03 06:30:00	SPY	ETF	209.83	209.84	209.56	209.76	29849.0
2016-11-03 07:00:00	SPY	ETF	209.75	210.34	209.7	210.1	191935.0
2016-11-03 07:30:00	SPY	ETF	210.05	210.29	210.04	210.13	383787.0
2016-11-03 08:00:00	SPY	ETF	210.13	210.35	209.152	210.27	628930.0
2016-11-03 08:30:00	SPY	ETF	210.26	210.35	209.99	210.24	533317.0
2016-11-03 09:00:00	SPY	ETF	210.24	210.24	209.88	210.0	656641.0
2016-11-03 09:30:00	SPY	ETF	209.99	210.24	209.8	209.86	8690764.0
2016-11-03 10:00:00	SPY	ETF	209.855	210.22	209.64	210.0411	7876685.0
2016-11-03 10:30:00	SPY	ETF	210.05	210.2	209.81	209.915	4555093.0
2016-11-03 11:00:00	SPY	ETF	209.92	210.06	209.76	210.02	4090939.0
2016-11-03 11:30:00	SPY	ETF	210.03	210.11	209.78	209.84	2679750.0
2016-11-03 12:00:00	SPY	ETF	209.83	209.8707	209.34	209.42	3809865.0
2016-11-03 12:30:00	SPY	ETF	209.425	209.4455	209.04	209.29	6174387.0
2016-11-03 13:00:00	SPY	ETF	209.3	209.51	209.11	209.39	3570505.0
2016-11-03 13:30:00	SPY	ETF	209.38	209.4	209.1	209.17	2882655.0
2016-11-03 14:00:00	SPY	ETF	209.18	209.485	209.09	209.245	3787469.0
2016-11-03 14:30:00	SPY	ETF	209.245	209.3	209.01	209.29	5562953.0
2016-11-03 15:00:00	SPY	ETF	209.285	209.29	208.84	208.92	6560259.0
2016-11-03 15:30:00	SPY	ETF	208.92	208.95	208.46	208.84	19748756.0
2016-11-03 16:00:00	SPY	ETF	208.82	209.15	208.68	208.8	3725915.0
2016-11-03 16:30:00	SPY	ETF	208.8	208.95	208.72	208.8	427630.0
2016-11-03 17:00:00	SPY	ETF	208.81	208.81	208.66	208.74	90759.0
2016-11-03 17:30:00	SPY	ETF	208.75	208.87	208.73	208.87	70208.0
2016-11-03 18:00:00	SPY	ETF	208.88	208.96	208.87	208.88	110775.0
2016-11-03 18:30:00	SPY	ETF	208.88	208.96	208.87	208.94	23976.0
2016-11-03 19:00:00	SPY	ETF	208.92	209.08	208.91	209.05	22471.0
2016-11-03 19:30:00	SPY	ETF	209.08	209.09	208.94	208.96	14206.0
2016-11-03 04:00:00	QQQ	ETF	114.67	114.7	114.55	114.7	3898.0
2016-11-03 04:30:00	QQQ	ETF	114.7	114.7	114.7	114.7	250.0
2016-11-03 05:00:00	QQQ	ETF	114.7	114.7	114.7	114.7	598.0
2016-11-03 05:30:00	QQQ	ETF	114.72	114.72	114.68	114.68	625.0
2016-11-03 06:00:00	QQQ	ETF	114.96	114.96	114.96	114.96	1979.0
2016-11-03 06:30:00	QQQ	ETF	114.81	114.81	114.71	114.76	9248.0
2016-11-03 07:00:00	QQQ	ETF	114.93	115.13	114.89	115.01	14037.0
2016-11-03 07:30:00	QQQ	ETF	115.06	115.11	115.05	115.08	74830.0
2016-11-03 08:00:00	QQQ	ETF	115.09	115.15	115.02	115.15	97993.0
2016-11-03 08:30:00	QQQ	ETF	115.13	115.21	115.03	115.16	21438.0
2016-11-03 09:00:00	QQQ	ETF	115.14	115.17	114.99	115.02	166086.0
2016-11-03 09:30:00	QQQ	ETF	115.02	115.37	114.85	114.86	2301279.0
2016-11-03 10:00:00	QQQ	ETF	114.86	115.07	114.77	115.05	2821597.0
2016-11-03 10:30:00	QQQ	ETF	115.05	115.18	114.83	114.8855	1299027.0
2016-11-03 11:00:00	QQQ	ETF	114.89	115.03	114.7774	115.02	826262.0
2016-11-03 11:30:00	QQQ	ETF	115.02	115.06	114.83	114.859	522054.0
2016-11-03 12:00:00	QQQ	ETF	114.851	114.875	114.49	114.54	1164079.0
2016-11-03 12:30:00	QQQ	ETF	114.52	114.55	114.34	114.5	1073462.0

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

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