PREVIEW / etf_30min / 2017-12-18

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-18.parquet
  size:    462 KB
  rows:    16,297

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
2017-12-18 04:00:00	SPY	ETF	267.54	267.74	267.5	267.64	5691.0
2017-12-18 04:30:00	SPY	ETF	267.78	267.95	267.78	267.9	7325.0
2017-12-18 05:00:00	SPY	ETF	267.91	267.95	267.87	267.92	4090.0
2017-12-18 05:30:00	SPY	ETF	267.84	267.9	267.84	267.9	5100.0
2017-12-18 06:00:00	SPY	ETF	267.9	267.95	267.89	267.95	3540.0
2017-12-18 06:30:00	SPY	ETF	267.98	267.99	267.89	267.89	13715.0
2017-12-18 07:00:00	SPY	ETF	267.81	268.02	267.81	268.02	129710.0
2017-12-18 07:30:00	SPY	ETF	268.02	268.02	267.94	267.94	63831.0
2017-12-18 08:00:00	SPY	ETF	267.95	268.17	267.8	268.17	181340.0
2017-12-18 08:30:00	SPY	ETF	268.15	268.16	267.99	268.01	221209.0
2017-12-18 09:00:00	SPY	ETF	268.0	268.1	267.94	268.08	429251.0
2017-12-18 09:30:00	SPY	ETF	268.1	268.6	267.98	268.44	8591220.0
2017-12-18 10:00:00	SPY	ETF	268.445	268.52	268.305	268.33	4310240.0
2017-12-18 10:30:00	SPY	ETF	268.34	268.35	268.15	268.26	3327255.0
2017-12-18 11:00:00	SPY	ETF	268.26	268.33	268.1025	268.21	2685747.0
2017-12-18 11:30:00	SPY	ETF	268.2	268.52	268.16	268.47	5258994.0
2017-12-18 12:00:00	SPY	ETF	268.47	268.56	268.42	268.46	4599667.0
2017-12-18 12:30:00	SPY	ETF	268.46	268.5	268.34	268.41	2147555.0
2017-12-18 13:00:00	SPY	ETF	268.4	268.5137	268.22	268.376	4017384.0
2017-12-18 13:30:00	SPY	ETF	268.37	268.38	268.18	268.23	3493012.0
2017-12-18 14:00:00	SPY	ETF	268.22	268.29	268.14	268.24	3522766.0
2017-12-18 14:30:00	SPY	ETF	268.235	268.4	268.21	268.39	1950954.0
2017-12-18 15:00:00	SPY	ETF	268.39	268.459	268.15	268.16	5222653.0
2017-12-18 15:30:00	SPY	ETF	268.15	268.25	268.0	268.18	12524470.0
2017-12-18 16:00:00	SPY	ETF	268.19	268.3622	268.05	268.21	16213431.0
2017-12-18 16:30:00	SPY	ETF	268.26	268.31	268.2	268.28	2785545.0
2017-12-18 17:00:00	SPY	ETF	268.24	268.33	268.1545	268.33	100244.0
2017-12-18 17:30:00	SPY	ETF	268.33	268.33	268.25	268.3	19523.0
2017-12-18 18:00:00	SPY	ETF	268.27	268.34	268.21	268.28	208104.0
2017-12-18 18:30:00	SPY	ETF	268.29	268.32	268.24	268.26	43137.0
2017-12-18 19:00:00	SPY	ETF	268.27	268.27	268.21	268.21	12599.0
2017-12-18 19:30:00	SPY	ETF	268.24	268.28	268.2	268.23	14771.0
2017-12-18 04:00:00	QQQ	ETF	158.35	158.51	158.35	158.48	27900.0
2017-12-18 04:30:00	QQQ	ETF	158.47	158.6	158.45	158.59	9050.0
2017-12-18 05:00:00	QQQ	ETF	158.59	158.59	158.54	158.54	10700.0
2017-12-18 05:30:00	QQQ	ETF	158.52	158.57	158.49	158.57	8755.0
2017-12-18 06:00:00	QQQ	ETF	158.58	158.69	158.58	158.64	26165.0
2017-12-18 06:30:00	QQQ	ETF	158.6	158.67	158.59	158.59	5648.0
2017-12-18 07:00:00	QQQ	ETF	158.55	158.59	158.54	158.55	25269.0
2017-12-18 07:30:00	QQQ	ETF	158.57	158.58	158.47	158.48	31650.0
2017-12-18 08:00:00	QQQ	ETF	158.53	158.53	158.4	158.43	91034.0
2017-12-18 08:30:00	QQQ	ETF	158.41	158.41	158.25	158.34	89417.0
2017-12-18 09:00:00	QQQ	ETF	158.34	158.46	158.28	158.28	113611.0
2017-12-18 09:30:00	QQQ	ETF	158.29	158.49	158.07	158.39	3380397.0
2017-12-18 10:00:00	QQQ	ETF	158.39	158.59	158.37	158.56	1704589.0
2017-12-18 10:30:00	QQQ	ETF	158.57	158.57	158.335	158.38	1356485.0
2017-12-18 11:00:00	QQQ	ETF	158.37	158.43	158.22	158.374	751693.0
2017-12-18 11:30:00	QQQ	ETF	158.375	158.64	158.34	158.55	740122.0
2017-12-18 12:00:00	QQQ	ETF	158.55	158.7	158.54	158.6	748660.0
2017-12-18 12:30:00	QQQ	ETF	158.6	158.77	158.58	158.72	1156164.0

> showing 50 of 16,297 rows — these rows as CSV

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