PREVIEW / etf_30min / 2016-10-11

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-11.parquet
  size:    415 KB
  rows:    14,108

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-11 04:00:00	SPY	ETF	215.91	215.91	215.73	215.73	28172.0
2016-10-11 04:30:00	SPY	ETF	215.78	215.81	215.59	215.66	12830.0
2016-10-11 05:00:00	SPY	ETF	215.6	215.69	215.58	215.69	3304.0
2016-10-11 05:30:00	SPY	ETF	215.71	215.81	215.68	215.81	14034.0
2016-10-11 06:00:00	SPY	ETF	215.75	215.78	215.73	215.77	6153.0
2016-10-11 06:30:00	SPY	ETF	215.87	215.91	215.85	215.87	24431.0
2016-10-11 07:00:00	SPY	ETF	215.97	216.02	215.78	215.78	64161.0
2016-10-11 07:30:00	SPY	ETF	215.84	215.92	215.64	215.67	164973.0
2016-10-11 08:00:00	SPY	ETF	215.69	215.94	215.55	215.64	408205.0
2016-10-11 08:30:00	SPY	ETF	215.64	215.74	215.58	215.65	124847.0
2016-10-11 09:00:00	SPY	ETF	215.68	215.7	215.5	215.65	369870.0
2016-10-11 09:30:00	SPY	ETF	215.66	215.74	214.75	214.91	11362672.0
2016-10-11 10:00:00	SPY	ETF	214.91	215.0	214.38	214.53	8067502.0
2016-10-11 10:30:00	SPY	ETF	214.53	214.69	214.1	214.125	7411606.0
2016-10-11 11:00:00	SPY	ETF	214.12	214.16	213.57	213.65	12607002.0
2016-10-11 11:30:00	SPY	ETF	213.64	214.03	213.61	213.91	6247195.0
2016-10-11 12:00:00	SPY	ETF	213.92	214.03	213.73	213.98	7360119.0
2016-10-11 12:30:00	SPY	ETF	213.98	214.33	213.77	214.05	4787268.0
2016-10-11 13:00:00	SPY	ETF	214.05	214.05	213.3	213.59	5468655.0
2016-10-11 13:30:00	SPY	ETF	213.59	213.64	212.9	212.97	7301907.0
2016-10-11 14:00:00	SPY	ETF	212.99	213.24	212.58	212.85	10450962.0
2016-10-11 14:30:00	SPY	ETF	212.85	213.18	212.72	212.991	6846858.0
2016-10-11 15:00:00	SPY	ETF	212.995	213.5	212.84	213.29	9476914.0
2016-10-11 15:30:00	SPY	ETF	213.28	213.66	213.21	213.45	17762246.0
2016-10-11 16:00:00	SPY	ETF	213.46	213.86	213.2526	213.75	9313977.0
2016-10-11 16:30:00	SPY	ETF	213.77	213.79	213.43	213.72	411441.0
2016-10-11 17:00:00	SPY	ETF	213.72	213.72	213.64	213.65	74531.0
2016-10-11 17:30:00	SPY	ETF	213.65	213.67	213.64	213.65	19160.0
2016-10-11 18:00:00	SPY	ETF	213.66	213.72	213.56	213.57	88975.0
2016-10-11 18:30:00	SPY	ETF	213.56	213.79	213.52	213.79	41292.0
2016-10-11 19:00:00	SPY	ETF	213.75	213.75	213.64	213.75	6988.0
2016-10-11 19:30:00	SPY	ETF	213.78	213.89	213.74	213.86	35151.0
2016-10-11 04:00:00	QQQ	ETF	119.11	119.11	119.03	119.1	9943.0
2016-10-11 04:30:00	QQQ	ETF	119.03	119.03	119.01	119.01	300.0
2016-10-11 05:00:00	QQQ	ETF	118.97	119.04	118.97	119.02	6917.0
2016-10-11 05:30:00	QQQ	ETF	119.04	119.12	119.04	119.12	4396.0
2016-10-11 06:00:00	QQQ	ETF	119.11	119.11	119.07	119.1	1484.0
2016-10-11 06:30:00	QQQ	ETF	119.18	119.18	119.16	119.18	10924.0
2016-10-11 07:00:00	QQQ	ETF	119.21	119.23	119.2	119.23	2700.0
2016-10-11 07:30:00	QQQ	ETF	119.24	119.28	119.16	119.16	21272.0
2016-10-11 08:00:00	QQQ	ETF	119.18	119.18	119.1	119.14	44292.0
2016-10-11 08:30:00	QQQ	ETF	119.11	119.15	119.11	119.12	15086.0
2016-10-11 09:00:00	QQQ	ETF	119.11	119.12	119.02	119.1	35548.0
2016-10-11 09:30:00	QQQ	ETF	119.1	119.14	118.44	118.54	2243399.0
2016-10-11 10:00:00	QQQ	ETF	118.55	118.575	118.24	118.35	2556754.0
2016-10-11 10:30:00	QQQ	ETF	118.34	118.4338	117.99	118.0	1459788.0
2016-10-11 11:00:00	QQQ	ETF	118.0	118.055	117.73	117.77	1920602.0
2016-10-11 11:30:00	QQQ	ETF	117.77	117.95	117.75	117.86	1154444.0
2016-10-11 12:00:00	QQQ	ETF	117.86	117.8863	117.705	117.83	804185.0
2016-10-11 12:30:00	QQQ	ETF	117.8399	118.0	117.67	117.8795	976433.0

> showing 50 of 14,108 rows — these rows as CSV

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