PREVIEW / etf_30min / 2016-11-10

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-11-10.parquet
  size:    458 KB
  rows:    15,383

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-10 04:00:00	SPY	ETF	218.02	218.1	217.64	217.64	28685.0
2016-11-10 04:30:00	SPY	ETF	217.6	217.91	217.58	217.88	22548.0
2016-11-10 05:00:00	SPY	ETF	217.9	218.37	217.9	218.19	149205.0
2016-11-10 05:30:00	SPY	ETF	218.2	218.32	218.07	218.08	65349.0
2016-11-10 06:00:00	SPY	ETF	218.1	218.1	217.9	217.9	69126.0
2016-11-10 06:30:00	SPY	ETF	217.9	217.93	217.7	217.93	175315.0
2016-11-10 07:00:00	SPY	ETF	217.95	218.0	217.38	217.39	273906.0
2016-11-10 07:30:00	SPY	ETF	217.38	217.61	216.98	217.59	734416.0
2016-11-10 08:00:00	SPY	ETF	217.59	217.95	217.05	217.71	1465558.0
2016-11-10 08:30:00	SPY	ETF	217.71	217.72	217.21	217.58	763459.0
2016-11-10 09:00:00	SPY	ETF	217.58	217.61	217.22	217.33	1162904.0
2016-11-10 09:30:00	SPY	ETF	217.3	218.31	217.25	217.5	19898640.0
2016-11-10 10:00:00	SPY	ETF	217.5	217.71	215.94	215.99	20022487.0
2016-11-10 10:30:00	SPY	ETF	215.99	217.35	215.22	215.49	23667020.0
2016-11-10 11:00:00	SPY	ETF	215.48	216.38	215.25	216.08	15327516.0
2016-11-10 11:30:00	SPY	ETF	216.08	216.88	215.8707	216.06	12699837.0
2016-11-10 12:00:00	SPY	ETF	216.07	216.725	216.02	216.56	8390884.0
2016-11-10 12:30:00	SPY	ETF	216.555	217.14	216.17	217.08	8812132.0
2016-11-10 13:00:00	SPY	ETF	217.09	217.48	216.89	217.21	7892546.0
2016-11-10 13:30:00	SPY	ETF	217.225	217.96	217.1	217.63	7684302.0
2016-11-10 14:00:00	SPY	ETF	217.635	217.85	217.3	217.48	5529634.0
2016-11-10 14:30:00	SPY	ETF	217.47	217.62	217.1	217.495	5851489.0
2016-11-10 15:00:00	SPY	ETF	217.5	217.67	217.1	217.22	6936050.0
2016-11-10 15:30:00	SPY	ETF	217.21	217.215	216.67	216.87	15706744.0
2016-11-10 16:00:00	SPY	ETF	216.88	217.2	216.71	217.09	4086110.0
2016-11-10 16:30:00	SPY	ETF	217.11	217.119	216.8262	216.87	2328797.0
2016-11-10 17:00:00	SPY	ETF	216.9	217.01	216.85	216.92	521704.0
2016-11-10 17:30:00	SPY	ETF	216.94	217.01	216.9	216.95	156940.0
2016-11-10 18:00:00	SPY	ETF	216.95	217.02	216.83	217.0	114113.0
2016-11-10 18:30:00	SPY	ETF	217.0	217.03	216.85	216.97	115114.0
2016-11-10 19:00:00	SPY	ETF	216.94	217.15	216.9	217.13	27287.0
2016-11-10 19:30:00	SPY	ETF	217.06	217.1	216.79	216.86	1252862.0
2016-11-10 04:00:00	QQQ	ETF	118.77	118.85	118.57	118.57	31129.0
2016-11-10 04:30:00	QQQ	ETF	118.49	118.69	118.49	118.69	19500.0
2016-11-10 05:00:00	QQQ	ETF	118.69	118.88	118.69	118.86	7515.0
2016-11-10 05:30:00	QQQ	ETF	118.84	118.86	118.74	118.75	400.0
2016-11-10 06:00:00	QQQ	ETF	118.69	118.73	118.62	118.62	15600.0
2016-11-10 06:30:00	QQQ	ETF	118.62	118.65	118.54	118.57	7689.0
2016-11-10 07:00:00	QQQ	ETF	118.63	118.63	118.37	118.37	35248.0
2016-11-10 07:30:00	QQQ	ETF	118.36	118.4	118.14	118.4	61171.0
2016-11-10 08:00:00	QQQ	ETF	118.37	118.51	118.26	118.43	214687.0
2016-11-10 08:30:00	QQQ	ETF	118.36	118.38	118.15	118.29	55195.0
2016-11-10 09:00:00	QQQ	ETF	118.31	118.31	118.12	118.12	323561.0
2016-11-10 09:30:00	QQQ	ETF	118.14	118.38	117.51	117.54	5627777.0
2016-11-10 10:00:00	QQQ	ETF	117.53	117.67	115.24	115.26	8330614.0
2016-11-10 10:30:00	QQQ	ETF	115.26	115.75	114.195	114.8	11659815.0
2016-11-10 11:00:00	QQQ	ETF	114.8	115.77	114.67	115.54	6815745.0
2016-11-10 11:30:00	QQQ	ETF	115.54	115.693	114.85	115.01	4452100.0
2016-11-10 12:00:00	QQQ	ETF	115.01	115.33	114.91	115.07	3463294.0
2016-11-10 12:30:00	QQQ	ETF	115.07	115.7618	114.8684	115.75	3538003.0

> showing 50 of 15,383 rows — these rows as CSV

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