PREVIEW / etf_30min / 2018-05-08

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-08.parquet
  size:    454 KB
  rows:    15,712

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-05-08 04:00:00	SPY	ETF	266.75	266.75	266.35	266.45	1091.0
2018-05-08 04:30:00	SPY	ETF	266.32	266.43	266.13	266.43	8166.0
2018-05-08 05:00:00	SPY	ETF	266.38	266.38	265.88	266.03	11001.0
2018-05-08 05:30:00	SPY	ETF	266.14	266.23	266.07	266.13	3692.0
2018-05-08 06:00:00	SPY	ETF	266.22	266.34	266.15	266.19	7684.0
2018-05-08 06:30:00	SPY	ETF	266.17	266.17	265.86	265.95	27723.0
2018-05-08 07:00:00	SPY	ETF	265.94	266.07	265.77	266.07	63210.0
2018-05-08 07:30:00	SPY	ETF	266.09	266.26	266.09	266.14	61740.0
2018-05-08 08:00:00	SPY	ETF	266.09	267.05	266.0	266.28	241098.0
2018-05-08 08:30:00	SPY	ETF	266.3	266.63	266.28	266.61	80212.0
2018-05-08 09:00:00	SPY	ETF	266.6	266.64	266.46	266.49	404240.0
2018-05-08 09:30:00	SPY	ETF	266.5	266.73	265.86	266.16	6167886.0
2018-05-08 10:00:00	SPY	ETF	266.15	266.46	266.02	266.15	4230486.0
2018-05-08 10:30:00	SPY	ETF	266.15	266.87	266.12	266.45	3248579.0
2018-05-08 11:00:00	SPY	ETF	266.45	267.325	266.075	266.87	5480760.0
2018-05-08 11:30:00	SPY	ETF	266.86	266.87	266.29	266.43	2931911.0
2018-05-08 12:00:00	SPY	ETF	266.42	266.55	266.1	266.175	2132626.0
2018-05-08 12:30:00	SPY	ETF	266.161	266.35	265.65	265.9	3259907.0
2018-05-08 13:00:00	SPY	ETF	265.8934	266.449	265.8	266.375	3041458.0
2018-05-08 13:30:00	SPY	ETF	266.37	266.5	265.95	266.02	1590258.0
2018-05-08 14:00:00	SPY	ETF	266.02	266.85	265.72	266.21	5524210.0
2018-05-08 14:30:00	SPY	ETF	266.22	266.3299	265.15	265.765	7132991.0
2018-05-08 15:00:00	SPY	ETF	265.78	266.65	265.51	266.4835	5038179.0
2018-05-08 15:30:00	SPY	ETF	266.48	266.9	266.4	266.9	6808039.0
2018-05-08 16:00:00	SPY	ETF	266.89	266.95	266.6283	266.91	8734864.0
2018-05-08 16:30:00	SPY	ETF	266.91	267.0	266.82	266.92	145564.0
2018-05-08 17:00:00	SPY	ETF	266.92	266.98	266.85	266.98	71025.0
2018-05-08 17:30:00	SPY	ETF	266.98	267.0	266.91	266.92	48873.0
2018-05-08 18:00:00	SPY	ETF	266.9	267.18	266.9	267.08	33702.0
2018-05-08 18:30:00	SPY	ETF	267.1	267.13	267.01	267.01	10435.0
2018-05-08 19:00:00	SPY	ETF	267.04	267.06	266.87	266.94	38027.0
2018-05-08 19:30:00	SPY	ETF	266.99	266.99	266.7	266.74	52499.0
2018-05-08 04:30:00	QQQ	ETF	165.85	165.9	165.72	165.88	3100.0
2018-05-08 05:00:00	QQQ	ETF	165.7	165.7	165.61	165.64	400.0
2018-05-08 05:30:00	QQQ	ETF	165.68	165.81	165.67	165.68	4600.0
2018-05-08 06:00:00	QQQ	ETF	165.84	165.94	165.8	165.8	2720.0
2018-05-08 06:30:00	QQQ	ETF	165.8	165.8	165.43	165.52	8780.0
2018-05-08 07:00:00	QQQ	ETF	165.57	165.64	165.34	165.54	47596.0
2018-05-08 07:30:00	QQQ	ETF	165.58	165.63	165.53	165.57	36471.0
2018-05-08 08:00:00	QQQ	ETF	165.56	165.78	165.34	165.77	80820.0
2018-05-08 08:30:00	QQQ	ETF	165.77	166.0	165.77	166.0	41526.0
2018-05-08 09:00:00	QQQ	ETF	166.0	166.01	165.82	165.82	106607.0
2018-05-08 09:30:00	QQQ	ETF	165.84	166.1	165.13	165.4201	2847157.0
2018-05-08 10:00:00	QQQ	ETF	165.43	165.74	165.36	165.51	1689750.0
2018-05-08 10:30:00	QQQ	ETF	165.51	166.01	165.48	165.6	1118022.0
2018-05-08 11:00:00	QQQ	ETF	165.585	166.43	165.41	165.92	2057785.0
2018-05-08 11:30:00	QQQ	ETF	165.915	166.0	165.525	165.71	1501538.0
2018-05-08 12:00:00	QQQ	ETF	165.69	165.78	165.48	165.63	1020357.0
2018-05-08 12:30:00	QQQ	ETF	165.62	165.7373	165.1	165.31	1114849.0
2018-05-08 13:00:00	QQQ	ETF	165.31	165.75	165.2551	165.7199	1347264.0

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

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