PREVIEW / etf_30min / 2017-12-14

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-14.parquet
  size:    451 KB
  rows:    15,572

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-14 04:00:00	SPY	ETF	267.18	267.4	267.18	267.3	1730.0
2017-12-14 04:30:00	SPY	ETF	267.38	267.38	267.38	267.38	240.0
2017-12-14 05:00:00	SPY	ETF	267.4	267.4	267.2	267.26	1900.0
2017-12-14 05:30:00	SPY	ETF	267.23	267.32	267.2	267.2	5853.0
2017-12-14 06:00:00	SPY	ETF	267.19	267.26	267.19	267.26	2600.0
2017-12-14 06:30:00	SPY	ETF	267.25	267.26	267.17	267.19	7101.0
2017-12-14 07:00:00	SPY	ETF	267.15	267.21	267.11	267.17	14399.0
2017-12-14 07:30:00	SPY	ETF	267.17	267.17	267.08	267.16	155011.0
2017-12-14 08:00:00	SPY	ETF	267.15	267.19	266.96	267.13	211152.0
2017-12-14 08:30:00	SPY	ETF	267.15	267.24	267.07	267.21	157355.0
2017-12-14 09:00:00	SPY	ETF	267.22	267.23	267.04	267.09	295764.0
2017-12-14 09:30:00	SPY	ETF	267.09	267.21	266.85	267.115	5417579.0
2017-12-14 10:00:00	SPY	ETF	267.115	267.22	266.96	267.08	3196898.0
2017-12-14 10:30:00	SPY	ETF	267.08	267.21	266.97	266.99	5527067.0
2017-12-14 11:00:00	SPY	ETF	266.99	267.07	266.55	266.8001	5709610.0
2017-12-14 11:30:00	SPY	ETF	266.8	266.95	266.73	266.88	4359952.0
2017-12-14 12:00:00	SPY	ETF	266.89	266.91	266.67	266.675	2648880.0
2017-12-14 12:30:00	SPY	ETF	266.675	266.77	266.45	266.51	4204109.0
2017-12-14 13:00:00	SPY	ETF	266.51	266.6567	266.25	266.475	5623173.0
2017-12-14 13:30:00	SPY	ETF	266.48	266.5	266.15	266.18	8184139.0
2017-12-14 14:00:00	SPY	ETF	266.18	266.32	265.6	265.63	5279202.0
2017-12-14 14:30:00	SPY	ETF	265.63	266.1	265.6	266.07	5241974.0
2017-12-14 15:00:00	SPY	ETF	266.07	266.09	265.72	265.895	6009357.0
2017-12-14 15:30:00	SPY	ETF	265.895	266.31	265.6	265.67	17007278.0
2017-12-14 16:00:00	SPY	ETF	265.68	265.94	265.54	265.66	16804750.0
2017-12-14 16:30:00	SPY	ETF	265.68	267.18	265.29	267.18	1157567.0
2017-12-14 17:00:00	SPY	ETF	265.32	265.66	265.22	265.23	919089.0
2017-12-14 17:30:00	SPY	ETF	265.27	265.52	265.27	265.45	306519.0
2017-12-14 18:00:00	SPY	ETF	265.46	265.66	265.39	265.42	688390.0
2017-12-14 18:30:00	SPY	ETF	265.5	266.83	265.5	265.55	29514.0
2017-12-14 19:00:00	SPY	ETF	265.55	265.55	265.45	265.54	10349.0
2017-12-14 19:30:00	SPY	ETF	265.54	265.63	265.54	265.63	15881.0
2017-12-14 04:00:00	QQQ	ETF	156.21	156.22	156.2	156.22	12700.0
2017-12-14 05:00:00	QQQ	ETF	156.23	156.23	156.19	156.2	2800.0
2017-12-14 05:30:00	QQQ	ETF	156.23	156.24	156.19	156.21	71786.0
2017-12-14 06:00:00	QQQ	ETF	156.21	156.26	156.21	156.24	2500.0
2017-12-14 06:30:00	QQQ	ETF	156.25	156.25	156.21	156.21	2800.0
2017-12-14 07:00:00	QQQ	ETF	156.26	156.27	156.21	156.22	7000.0
2017-12-14 07:30:00	QQQ	ETF	156.2	156.2	156.12	156.15	4203.0
2017-12-14 08:00:00	QQQ	ETF	156.19	156.21	156.13	156.15	9831.0
2017-12-14 08:30:00	QQQ	ETF	156.15	156.28	156.11	156.28	41133.0
2017-12-14 09:00:00	QQQ	ETF	156.29	156.35	156.26	156.27	64801.0
2017-12-14 09:30:00	QQQ	ETF	156.28	156.44	156.065	156.29	2081877.0
2017-12-14 10:00:00	QQQ	ETF	156.29	156.59	156.11	156.49	1620446.0
2017-12-14 10:30:00	QQQ	ETF	156.49	156.66	156.4499	156.54	1013209.0
2017-12-14 11:00:00	QQQ	ETF	156.54	156.615	156.2	156.38	1262825.0
2017-12-14 11:30:00	QQQ	ETF	156.38	156.52	156.34	156.39	570641.0
2017-12-14 12:00:00	QQQ	ETF	156.395	156.48	156.34	156.3699	489210.0
2017-12-14 12:30:00	QQQ	ETF	156.36	156.47	156.195	156.24	556428.0
2017-12-14 13:00:00	QQQ	ETF	156.24	156.29	155.78	156.1	1682001.0

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

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