PREVIEW / etf_30min / 2019-01-09

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-09.parquet
  size:    509 KB
  rows:    17,754

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
2019-01-09 04:00:00	SPY	ETF	257.5	257.75	257.3	257.59	22754.0
2019-01-09 04:30:00	SPY	ETF	257.67	257.77	257.46	257.54	19780.0
2019-01-09 05:00:00	SPY	ETF	257.47	257.62	257.01	257.06	23756.0
2019-01-09 05:30:00	SPY	ETF	257.05	257.42	257.04	257.34	25255.0
2019-01-09 06:00:00	SPY	ETF	257.42	257.49	257.09	257.11	14017.0
2019-01-09 06:30:00	SPY	ETF	257.1	257.29	256.9	257.29	69504.0
2019-01-09 07:00:00	SPY	ETF	257.17	257.23	256.75	257.0	168091.0
2019-01-09 07:30:00	SPY	ETF	257.0	257.45	256.86	257.38	135276.0
2019-01-09 08:00:00	SPY	ETF	257.41	257.76	256.77	257.58	291174.0
2019-01-09 08:30:00	SPY	ETF	257.6	257.8	256.77	257.71	1018989.0
2019-01-09 09:00:00	SPY	ETF	257.69	257.69	257.43	257.55	250693.0
2019-01-09 09:30:00	SPY	ETF	257.56	258.16	257.06	258.07	9659576.0
2019-01-09 10:00:00	SPY	ETF	258.07	258.29	257.43	257.84	6872716.0
2019-01-09 10:30:00	SPY	ETF	257.84	257.84	256.19	256.94	8956494.0
2019-01-09 11:00:00	SPY	ETF	256.93	258.02	256.83	257.88	6855474.0
2019-01-09 11:30:00	SPY	ETF	257.8753	258.55	257.535	258.17	4555965.0
2019-01-09 12:00:00	SPY	ETF	258.15	258.35	257.9287	258.21	3143116.0
2019-01-09 12:30:00	SPY	ETF	258.21	258.8	258.13	258.72	4056149.0
2019-01-09 13:00:00	SPY	ETF	258.71	258.77	258.22	258.52	3174740.0
2019-01-09 13:30:00	SPY	ETF	258.51	258.59	257.89	258.17	2983224.0
2019-01-09 14:00:00	SPY	ETF	258.16	258.91	257.29	257.65	7456273.0
2019-01-09 14:30:00	SPY	ETF	257.65	258.56	257.35	258.16	4400706.0
2019-01-09 15:00:00	SPY	ETF	258.17	258.61	258.06	258.375	4186602.0
2019-01-09 15:30:00	SPY	ETF	258.375	258.49	257.29	257.88	12638149.0
2019-01-09 16:00:00	SPY	ETF	257.89	257.99	257.4	257.46	10547287.0
2019-01-09 16:30:00	SPY	ETF	257.46	257.97	257.09	257.45	369224.0
2019-01-09 17:00:00	SPY	ETF	257.33	257.53	257.21	257.4	1123512.0
2019-01-09 17:30:00	SPY	ETF	257.41	257.43	257.22	257.26	36252.0
2019-01-09 18:00:00	SPY	ETF	257.3	257.42	256.95	257.06	135895.0
2019-01-09 18:30:00	SPY	ETF	257.03	257.32	257.03	257.03	37162.0
2019-01-09 19:00:00	SPY	ETF	257.06	257.4	256.85	257.0	77004.0
2019-01-09 19:30:00	SPY	ETF	256.9	257.07	256.57	256.58	83789.0
2019-01-09 04:00:00	QQQ	ETF	160.0	160.23	159.97	160.18	67649.0
2019-01-09 04:30:00	QQQ	ETF	160.21	160.28	160.11	160.14	32282.0
2019-01-09 05:00:00	QQQ	ETF	160.14	160.2	159.86	159.86	57359.0
2019-01-09 05:30:00	QQQ	ETF	159.84	160.1	159.83	160.1	17923.0
2019-01-09 06:00:00	QQQ	ETF	160.21	160.21	159.91	160.02	8763.0
2019-01-09 06:30:00	QQQ	ETF	159.94	160.07	159.81	160.07	9979.0
2019-01-09 07:00:00	QQQ	ETF	160.04	160.04	159.66	159.81	88996.0
2019-01-09 07:30:00	QQQ	ETF	159.82	160.15	159.72	160.1	74726.0
2019-01-09 08:00:00	QQQ	ETF	160.04	160.31	159.67	160.23	140691.0
2019-01-09 08:30:00	QQQ	ETF	160.22	160.38	160.1	160.18	180204.0
2019-01-09 09:00:00	QQQ	ETF	160.19	160.19	159.92	160.06	292246.0
2019-01-09 09:30:00	QQQ	ETF	160.15	160.76	159.69	160.6	6855300.0
2019-01-09 10:00:00	QQQ	ETF	160.6	160.78	160.07	160.59	3664904.0
2019-01-09 10:30:00	QQQ	ETF	160.58	160.59	159.47	160.0231	3496627.0
2019-01-09 11:00:00	QQQ	ETF	160.02	160.77	159.9	160.64	2297733.0
2019-01-09 11:30:00	QQQ	ETF	160.65	161.1	160.335	160.84	2422222.0
2019-01-09 12:00:00	QQQ	ETF	160.83	161.06	160.69	160.96	1328846.0
2019-01-09 12:30:00	QQQ	ETF	160.96	161.25	160.9	161.2	1858027.0

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

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