PREVIEW / etf_30min / 2016-08-11

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-11.parquet
  size:    394 KB
  rows:    13,419

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-11 04:00:00	SPY	ETF	217.68	217.86	217.62	217.78	22600.0
2016-08-11 04:30:00	SPY	ETF	217.78	217.91	217.76	217.91	17955.0
2016-08-11 05:00:00	SPY	ETF	217.91	218.1	217.91	218.02	44699.0
2016-08-11 05:30:00	SPY	ETF	218.1	218.1	218.07	218.1	2286.0
2016-08-11 06:00:00	SPY	ETF	218.1	218.19	218.05	218.18	8385.0
2016-08-11 06:30:00	SPY	ETF	218.2	218.25	218.14	218.25	64568.0
2016-08-11 07:00:00	SPY	ETF	218.19	218.33	218.19	218.27	59220.0
2016-08-11 07:30:00	SPY	ETF	218.28	218.29	218.16	218.16	54643.0
2016-08-11 08:00:00	SPY	ETF	218.15	218.28	217.734	218.13	238508.0
2016-08-11 08:30:00	SPY	ETF	218.12	218.25	218.1	218.15	171091.0
2016-08-11 09:00:00	SPY	ETF	218.17	218.3	218.17	218.265	211769.0
2016-08-11 09:30:00	SPY	ETF	218.26	218.5	218.16	218.17	6528456.0
2016-08-11 10:00:00	SPY	ETF	218.17	218.24	217.95	218.2	3537273.0
2016-08-11 10:30:00	SPY	ETF	218.195	218.67	218.19	218.52	6641800.0
2016-08-11 11:00:00	SPY	ETF	218.53	218.63	218.465	218.62	3230881.0
2016-08-11 11:30:00	SPY	ETF	218.61	218.83	218.58	218.74	5729093.0
2016-08-11 12:00:00	SPY	ETF	218.75	218.77	218.64	218.69	2150580.0
2016-08-11 12:30:00	SPY	ETF	218.685	218.77	218.63	218.71	2828691.0
2016-08-11 13:00:00	SPY	ETF	218.71	218.83	218.67	218.69	4625378.0
2016-08-11 13:30:00	SPY	ETF	218.69	218.8	218.65	218.71	2144712.0
2016-08-11 14:00:00	SPY	ETF	218.71	218.91	218.7	218.85	4145970.0
2016-08-11 14:30:00	SPY	ETF	218.84	218.85	218.54	218.665	5319874.0
2016-08-11 15:00:00	SPY	ETF	218.665	218.76	218.64	218.67	4137147.0
2016-08-11 15:30:00	SPY	ETF	218.67	218.94	218.65	218.65	10127730.0
2016-08-11 16:00:00	SPY	ETF	218.65	218.68	218.44	218.58	5277146.0
2016-08-11 16:30:00	SPY	ETF	218.58	218.65	218.53	218.6	502934.0
2016-08-11 17:00:00	SPY	ETF	218.59	218.68	218.57	218.6	55968.0
2016-08-11 17:30:00	SPY	ETF	218.6	218.62	218.59	218.61	33338.0
2016-08-11 18:00:00	SPY	ETF	218.61	218.65	218.57	218.6	76343.0
2016-08-11 18:30:00	SPY	ETF	218.6	218.64	218.57	218.61	9250.0
2016-08-11 19:00:00	SPY	ETF	218.63	218.64	218.63	218.64	7310.0
2016-08-11 19:30:00	SPY	ETF	218.64	218.73	218.63	218.67	53383.0
2016-08-11 04:00:00	QQQ	ETF	116.73	116.73	116.73	116.73	100.0
2016-08-11 04:30:00	QQQ	ETF	116.77	116.79	116.74	116.79	600.0
2016-08-11 05:00:00	QQQ	ETF	116.85	116.94	116.85	116.94	15750.0
2016-08-11 05:30:00	QQQ	ETF	116.98	116.98	116.98	116.98	16000.0
2016-08-11 06:00:00	QQQ	ETF	116.96	116.96	116.96	116.96	500.0
2016-08-11 06:30:00	QQQ	ETF	116.97	117.02	116.95	117.0	2400.0
2016-08-11 07:00:00	QQQ	ETF	116.99	117.05	116.99	117.05	5300.0
2016-08-11 07:30:00	QQQ	ETF	116.98	117.0	116.98	116.98	17050.0
2016-08-11 08:00:00	QQQ	ETF	116.94	116.97	116.9	116.92	8216.0
2016-08-11 08:30:00	QQQ	ETF	116.93	116.98	116.93	116.95	27136.0
2016-08-11 09:00:00	QQQ	ETF	116.96	117.03	116.96	117.01	47299.0
2016-08-11 09:30:00	QQQ	ETF	117.01	117.37	116.99	117.1	2056262.0
2016-08-11 10:00:00	QQQ	ETF	117.09	117.11	116.78	116.94	810559.0
2016-08-11 10:30:00	QQQ	ETF	116.94	117.16	116.94	117.04	741181.0
2016-08-11 11:00:00	QQQ	ETF	117.05	117.12	116.97	117.05	264793.0
2016-08-11 11:30:00	QQQ	ETF	117.04	117.21	117.03	117.18	367612.0
2016-08-11 12:00:00	QQQ	ETF	117.19	117.2	117.1	117.12	239395.0
2016-08-11 12:30:00	QQQ	ETF	117.12	117.16	117.09	117.16	355401.0

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

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