PREVIEW / etf_30min / 2018-02-12

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-12.parquet
  size:    499 KB
  rows:    17,283

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
2018-02-12 04:00:00	SPY	ETF	263.48	265.31	263.48	264.54	72310.0
2018-02-12 04:30:00	SPY	ETF	264.56	265.08	264.56	264.95	15860.0
2018-02-12 05:00:00	SPY	ETF	264.91	264.91	264.57	264.6	16742.0
2018-02-12 05:30:00	SPY	ETF	264.61	264.88	264.29	264.77	68815.0
2018-02-12 06:00:00	SPY	ETF	264.69	264.92	264.6	264.7	18212.0
2018-02-12 06:30:00	SPY	ETF	264.74	264.76	264.25	264.27	82292.0
2018-02-12 07:00:00	SPY	ETF	264.4	265.02	264.27	264.83	389892.0
2018-02-12 07:30:00	SPY	ETF	264.84	264.97	264.38	264.6	245536.0
2018-02-12 08:00:00	SPY	ETF	264.61	264.94	263.22	264.79	325278.0
2018-02-12 08:30:00	SPY	ETF	264.79	264.94	263.92	264.0	642132.0
2018-02-12 09:00:00	SPY	ETF	263.95	264.19	261.5	263.82	2253319.0
2018-02-12 09:30:00	SPY	ETF	263.83	265.29	263.48	263.67	14481991.0
2018-02-12 10:00:00	SPY	ETF	263.68	264.66	261.88	262.72	11878966.0
2018-02-12 10:30:00	SPY	ETF	262.7124	263.73	262.11	263.45	9488281.0
2018-02-12 11:00:00	SPY	ETF	263.44	264.13	262.81	263.8452	8610896.0
2018-02-12 11:30:00	SPY	ETF	263.85	265.1	263.32	265.07	8486779.0
2018-02-12 12:00:00	SPY	ETF	265.07	265.92	264.69	265.59	6939670.0
2018-02-12 12:30:00	SPY	ETF	265.61	265.65	264.96	265.31	3621967.0
2018-02-12 13:00:00	SPY	ETF	265.32	265.59	264.88	265.35	4105038.0
2018-02-12 13:30:00	SPY	ETF	265.36	266.61	265.08	266.3	7063753.0
2018-02-12 14:00:00	SPY	ETF	266.31	266.3802	265.5047	266.2036	4800117.0
2018-02-12 14:30:00	SPY	ETF	266.21	266.64	265.525	265.91	6684361.0
2018-02-12 15:00:00	SPY	ETF	265.92	267.01	265.84	266.42	8986258.0
2018-02-12 15:30:00	SPY	ETF	266.44	266.71	264.45	265.26	27146416.0
2018-02-12 16:00:00	SPY	ETF	265.24	265.51	261.6644	265.36	10909783.0
2018-02-12 16:30:00	SPY	ETF	265.36	265.6667	265.12	265.14	724760.0
2018-02-12 17:00:00	SPY	ETF	265.15	265.28	265.07	265.2	77417.0
2018-02-12 17:30:00	SPY	ETF	265.21	265.36	265.11	265.17	2480267.0
2018-02-12 18:00:00	SPY	ETF	265.17	265.57	265.09	265.49	376341.0
2018-02-12 18:30:00	SPY	ETF	265.42	265.42	264.81	265.05	69552.0
2018-02-12 19:00:00	SPY	ETF	265.05	265.08	264.56	264.7	36788.0
2018-02-12 19:30:00	SPY	ETF	264.71	265.13	264.71	264.86	21171.0
2018-02-12 04:00:00	QQQ	ETF	156.73	158.2	156.73	157.64	121538.0
2018-02-12 04:30:00	QQQ	ETF	157.73	158.2	157.73	158.19	10840.0
2018-02-12 05:00:00	QQQ	ETF	158.04	158.09	157.96	157.96	14395.0
2018-02-12 05:30:00	QQQ	ETF	157.95	158.09	157.81	157.95	46385.0
2018-02-12 06:00:00	QQQ	ETF	158.1	158.17	158.02	158.1	8461.0
2018-02-12 06:30:00	QQQ	ETF	158.12	158.12	157.67	157.7	77740.0
2018-02-12 07:00:00	QQQ	ETF	157.75	158.17	157.7	158.11	118391.0
2018-02-12 07:30:00	QQQ	ETF	158.08	158.13	157.85	157.93	97198.0
2018-02-12 08:00:00	QQQ	ETF	157.93	158.15	156.81	157.94	200285.0
2018-02-12 08:30:00	QQQ	ETF	157.99	158.25	156.13	157.6	566958.0
2018-02-12 09:00:00	QQQ	ETF	157.55	157.72	156.1	157.65	933900.0
2018-02-12 09:30:00	QQQ	ETF	157.66	158.69	157.59	157.7101	8754908.0
2018-02-12 10:00:00	QQQ	ETF	157.72	158.49	156.46	157.06	4879669.0
2018-02-12 10:30:00	QQQ	ETF	157.05	157.78	156.67	157.68	4451793.0
2018-02-12 11:00:00	QQQ	ETF	157.68	158.3	157.37	158.0	3147596.0
2018-02-12 11:30:00	QQQ	ETF	158.0	158.949	157.84	158.94	3093545.0
2018-02-12 12:00:00	QQQ	ETF	158.94	159.26	158.62	158.93	2331270.0
2018-02-12 12:30:00	QQQ	ETF	158.94	158.94	158.465	158.72	1785212.0

> showing 50 of 17,283 rows — these rows as CSV

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