PREVIEW / etf_30min / 2017-08-30

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-30.parquet
  size:    427 KB
  rows:    14,662

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-08-30 04:00:00	SPY	ETF	245.41	245.41	245.33	245.33	3924.0
2017-08-30 04:30:00	SPY	ETF	245.31	245.33	245.31	245.33	310.0
2017-08-30 05:00:00	SPY	ETF	245.31	245.31	245.19	245.19	1600.0
2017-08-30 05:30:00	SPY	ETF	245.21	245.21	245.16	245.16	2100.0
2017-08-30 06:00:00	SPY	ETF	245.15	245.15	245.13	245.13	2200.0
2017-08-30 06:30:00	SPY	ETF	245.2	245.26	245.2	245.24	11314.0
2017-08-30 07:00:00	SPY	ETF	245.23	245.26	245.01	245.01	48396.0
2017-08-30 07:30:00	SPY	ETF	245.04	245.15	245.01	245.13	62767.0
2017-08-30 08:00:00	SPY	ETF	245.21	245.21	244.97	245.03	116490.0
2017-08-30 08:30:00	SPY	ETF	245.05	245.06	244.67	244.7	476766.0
2017-08-30 09:00:00	SPY	ETF	244.72	244.91	244.62	244.82	459103.0
2017-08-30 09:30:00	SPY	ETF	244.83	245.15	244.62	245.11	4725567.0
2017-08-30 10:00:00	SPY	ETF	245.11	245.26	244.98	245.215	3590798.0
2017-08-30 10:30:00	SPY	ETF	245.22	245.49	245.03	245.47	4811729.0
2017-08-30 11:00:00	SPY	ETF	245.47	245.501	245.33	245.4715	2735979.0
2017-08-30 11:30:00	SPY	ETF	245.47	245.59	245.38	245.51	2860526.0
2017-08-30 12:00:00	SPY	ETF	245.52	245.59	245.44	245.55	1645359.0
2017-08-30 12:30:00	SPY	ETF	245.555	245.83	245.54	245.81	2337668.0
2017-08-30 13:00:00	SPY	ETF	245.805	246.23	245.7797	246.145	2963805.0
2017-08-30 13:30:00	SPY	ETF	246.14	246.29	246.07	246.22	2851947.0
2017-08-30 14:00:00	SPY	ETF	246.23	246.24	246.1	246.19	4672063.0
2017-08-30 14:30:00	SPY	ETF	246.2	246.32	246.035	246.23	2217351.0
2017-08-30 15:00:00	SPY	ETF	246.23	246.25	246.02	246.16	3100402.0
2017-08-30 15:30:00	SPY	ETF	246.1601	246.19	245.66	246.04	10849945.0
2017-08-30 16:00:00	SPY	ETF	246.03	246.08	245.92	245.97	7922214.0
2017-08-30 16:30:00	SPY	ETF	245.97	246.0387	245.93	245.94	795375.0
2017-08-30 17:00:00	SPY	ETF	245.94	246.0	245.94	245.99	294941.0
2017-08-30 17:30:00	SPY	ETF	245.98	245.98	245.9	245.91	45494.0
2017-08-30 18:00:00	SPY	ETF	245.91	245.99	245.88	245.97	166492.0
2017-08-30 18:30:00	SPY	ETF	245.94	246.0	245.94	245.95	54802.0
2017-08-30 19:00:00	SPY	ETF	245.98	246.02	245.95	246.01	14621.0
2017-08-30 19:30:00	SPY	ETF	246.01	246.12	246.01	246.1	20305.0
2017-08-30 04:00:00	QQQ	ETF	143.54	143.58	143.38	143.38	14559.0
2017-08-30 04:30:00	QQQ	ETF	143.36	143.36	143.36	143.36	500.0
2017-08-30 05:00:00	QQQ	ETF	143.33	143.33	143.29	143.29	600.0
2017-08-30 06:00:00	QQQ	ETF	143.3	143.3	143.26	143.26	340.0
2017-08-30 07:00:00	QQQ	ETF	143.33	143.36	143.2	143.21	10404.0
2017-08-30 07:30:00	QQQ	ETF	143.21	143.3	143.17	143.3	61507.0
2017-08-30 08:00:00	QQQ	ETF	143.29	143.36	143.22	143.35	57224.0
2017-08-30 08:30:00	QQQ	ETF	143.31	143.32	142.94	143.0	113576.0
2017-08-30 09:00:00	QQQ	ETF	143.0	143.18	142.97	143.13	88834.0
2017-08-30 09:30:00	QQQ	ETF	143.11	143.71	143.0	143.67	3616276.0
2017-08-30 10:00:00	QQQ	ETF	143.66	143.79	143.49	143.7262	1535501.0
2017-08-30 10:30:00	QQQ	ETF	143.73	143.98	143.53	143.97	1316643.0
2017-08-30 11:00:00	QQQ	ETF	143.97	144.01	143.82	143.9	1384191.0
2017-08-30 11:30:00	QQQ	ETF	143.9	143.97	143.83	143.9338	1286187.0
2017-08-30 12:00:00	QQQ	ETF	143.94	144.03	143.88	144.0	1441711.0
2017-08-30 12:30:00	QQQ	ETF	144.0	144.31	143.99	144.29	1540254.0
2017-08-30 13:00:00	QQQ	ETF	144.285	144.62	144.2599	144.56	2372091.0
2017-08-30 13:30:00	QQQ	ETF	144.56	144.8301	144.52	144.76	2728051.0

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

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