PREVIEW / etf_30min / 2018-06-15

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-15.parquet
  size:    466 KB
  rows:    16,084

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-06-15 04:00:00	SPY	ETF	277.34	277.34	276.08	276.48	71604.0
2018-06-15 04:30:00	SPY	ETF	276.43	276.52	276.18	276.38	18612.0
2018-06-15 05:00:00	SPY	ETF	276.43	276.61	276.33	276.5	17953.0
2018-06-15 05:30:00	SPY	ETF	276.45	276.56	276.28	276.33	16000.0
2018-06-15 06:00:00	SPY	ETF	276.31	276.43	275.94	276.32	59240.0
2018-06-15 06:30:00	SPY	ETF	276.19	276.46	276.17	276.4	33692.0
2018-06-15 07:00:00	SPY	ETF	276.46	276.53	276.38	276.53	225319.0
2018-06-15 07:30:00	SPY	ETF	276.5	276.94	276.5	276.74	200786.0
2018-06-15 08:00:00	SPY	ETF	276.74	277.48	276.2	276.35	388020.0
2018-06-15 08:30:00	SPY	ETF	276.35	276.39	275.95	276.1	1145291.0
2018-06-15 09:00:00	SPY	ETF	276.09	276.68	275.86	276.62	1914559.0
2018-06-15 09:30:00	SPY	ETF	276.6	276.66	275.97	276.49	10098732.0
2018-06-15 10:00:00	SPY	ETF	276.48	276.62	276.12	276.12	7623746.0
2018-06-15 10:30:00	SPY	ETF	276.11	276.8854	275.35	276.2131	7481941.0
2018-06-15 11:00:00	SPY	ETF	276.215	276.51	276.015	276.02	20483114.0
2018-06-15 11:30:00	SPY	ETF	276.02	276.4	275.8701	276.35	4947310.0
2018-06-15 12:00:00	SPY	ETF	276.35	276.8854	276.09	276.2899	3564148.0
2018-06-15 12:30:00	SPY	ETF	276.2899	276.57	276.21	276.5484	3333084.0
2018-06-15 13:00:00	SPY	ETF	276.56	276.63	276.46	276.505	3956979.0
2018-06-15 13:30:00	SPY	ETF	276.505	276.51	276.19	276.235	3174189.0
2018-06-15 14:00:00	SPY	ETF	276.26	277.33	276.21	277.295	3966225.0
2018-06-15 14:30:00	SPY	ETF	277.29	277.51	277.13	277.2352	4685175.0
2018-06-15 15:00:00	SPY	ETF	277.23	277.25	276.79	277.13	5916271.0
2018-06-15 15:30:00	SPY	ETF	277.12	277.22	276.79	277.2	15158525.0
2018-06-15 16:00:00	SPY	ETF	277.21	277.25	276.87	277.14	9552931.0
2018-06-15 16:30:00	SPY	ETF	277.17	277.39	276.86	276.93	2170877.0
2018-06-15 17:00:00	SPY	ETF	276.91	277.21	276.83	277.0	6313324.0
2018-06-15 17:30:00	SPY	ETF	277.13	277.15	276.55	276.65	377899.0
2018-06-15 18:00:00	SPY	ETF	276.65	276.71	276.51	276.64	95207.0
2018-06-15 18:30:00	SPY	ETF	276.66	276.71	276.55	276.64	74452.0
2018-06-15 19:00:00	SPY	ETF	276.62	276.64	276.61	276.62	12391.0
2018-06-15 19:30:00	SPY	ETF	276.62	276.69	276.54	276.54	35828.0
2018-06-15 04:00:00	QQQ	ETF	177.3	177.36	177.1	177.27	8957.0
2018-06-15 04:30:00	QQQ	ETF	177.24	177.32	177.17	177.23	15150.0
2018-06-15 05:00:00	QQQ	ETF	177.22	177.34	177.22	177.26	7011.0
2018-06-15 05:30:00	QQQ	ETF	177.25	177.33	177.22	177.23	5900.0
2018-06-15 06:00:00	QQQ	ETF	177.25	177.31	176.95	177.13	17103.0
2018-06-15 06:30:00	QQQ	ETF	177.22	177.27	177.08	177.15	8174.0
2018-06-15 07:00:00	QQQ	ETF	177.24	177.24	177.01	177.12	26229.0
2018-06-15 07:30:00	QQQ	ETF	177.15	177.62	177.15	177.44	43569.0
2018-06-15 08:00:00	QQQ	ETF	177.6	177.6	177.0	177.16	101514.0
2018-06-15 08:30:00	QQQ	ETF	177.12	177.15	176.7	176.83	217180.0
2018-06-15 09:00:00	QQQ	ETF	176.84	177.1	176.57	177.0	737027.0
2018-06-15 09:30:00	QQQ	ETF	176.99	177.01	176.11	176.72	6314804.0
2018-06-15 10:00:00	QQQ	ETF	176.725	177.035	176.54	176.725	3108580.0
2018-06-15 10:30:00	QQQ	ETF	176.725	176.95	176.251	176.8	3026674.0
2018-06-15 11:00:00	QQQ	ETF	176.8	176.95	176.61	176.61	1485564.0
2018-06-15 11:30:00	QQQ	ETF	176.605	176.85	176.51	176.79	1300196.0
2018-06-15 12:00:00	QQQ	ETF	176.79	176.88	176.7099	176.84	771582.0
2018-06-15 12:30:00	QQQ	ETF	176.86	177.14	176.809	177.11	812996.0

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

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