PREVIEW / etf_30min / 2019-12-23

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-23.parquet
  size:    529 KB
  rows:    18,800

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-12-23 04:00:00	SPY	ETF	321.34	321.46	321.33	321.46	2560.0
2019-12-23 04:30:00	SPY	ETF	321.42	321.44	321.4	321.4	4681.0
2019-12-23 05:00:00	SPY	ETF	321.37	321.47	321.37	321.47	1358.0
2019-12-23 05:30:00	SPY	ETF	321.48	321.5	321.41	321.41	10449.0
2019-12-23 06:00:00	SPY	ETF	321.47	321.66	321.47	321.66	12655.0
2019-12-23 06:30:00	SPY	ETF	321.58	321.62	321.54	321.56	11839.0
2019-12-23 07:00:00	SPY	ETF	321.62	321.98	321.58	321.83	44812.0
2019-12-23 07:30:00	SPY	ETF	321.81	321.84	321.77	321.8	46911.0
2019-12-23 08:00:00	SPY	ETF	321.65	321.8801	321.22	321.8	90083.0
2019-12-23 08:30:00	SPY	ETF	321.8	321.92	321.55	321.65	134536.0
2019-12-23 09:00:00	SPY	ETF	321.65	321.7	321.47	321.48	343650.0
2019-12-23 09:30:00	SPY	ETF	321.59	321.63	321.215	321.31	4872292.0
2019-12-23 10:00:00	SPY	ETF	321.33	321.5	321.2486	321.37	2473155.0
2019-12-23 10:30:00	SPY	ETF	321.365	321.6	321.3	321.575	3576238.0
2019-12-23 11:00:00	SPY	ETF	321.57	321.63	321.43	321.5878	2621997.0
2019-12-23 11:30:00	SPY	ETF	321.59	321.65	321.46	321.51	2248724.0
2019-12-23 12:00:00	SPY	ETF	321.5038	321.52	321.28	321.31	1961471.0
2019-12-23 12:30:00	SPY	ETF	321.315	321.46	321.313	321.38	2219189.0
2019-12-23 13:00:00	SPY	ETF	321.375	321.515	321.36	321.51	2110935.0
2019-12-23 13:30:00	SPY	ETF	321.51	321.51	321.31	321.38	983925.0
2019-12-23 14:00:00	SPY	ETF	321.38	321.51	321.37	321.4431	3287885.0
2019-12-23 14:30:00	SPY	ETF	321.44	321.5	321.35	321.44	2505939.0
2019-12-23 15:00:00	SPY	ETF	321.435	321.46	321.23	321.39	2382247.0
2019-12-23 15:30:00	SPY	ETF	321.38	321.42	321.06	321.22	7896647.0
2019-12-23 16:00:00	SPY	ETF	321.25	321.37	321.2	321.33	7650257.0
2019-12-23 16:30:00	SPY	ETF	321.32	321.42	321.22	321.42	3322971.0
2019-12-23 17:00:00	SPY	ETF	321.36	321.4	321.36	321.39	844806.0
2019-12-23 17:30:00	SPY	ETF	321.39	321.42	321.39	321.41	7111.0
2019-12-23 18:00:00	SPY	ETF	321.44	321.45	321.34	321.41	11518.0
2019-12-23 18:30:00	SPY	ETF	321.45	321.55	321.4	321.45	13227.0
2019-12-23 19:00:00	SPY	ETF	321.46	321.46	321.41	321.41	997.0
2019-12-23 19:30:00	SPY	ETF	321.38	321.41	321.31	321.35	8491.0
2019-12-23 04:00:00	QQQ	ETF	211.63	211.69	211.6	211.67	7800.0
2019-12-23 04:30:00	QQQ	ETF	211.72	211.72	211.7	211.7	6547.0
2019-12-23 05:00:00	QQQ	ETF	211.73	211.75	211.7	211.75	3200.0
2019-12-23 05:30:00	QQQ	ETF	211.79	211.79	211.69	211.72	3326.0
2019-12-23 06:00:00	QQQ	ETF	211.72	211.95	211.71	211.89	5300.0
2019-12-23 06:30:00	QQQ	ETF	211.86	211.91	211.86	211.91	3750.0
2019-12-23 07:00:00	QQQ	ETF	211.93	212.24	211.89	212.1	25710.0
2019-12-23 07:30:00	QQQ	ETF	212.1	212.12	212.02	212.08	32118.0
2019-12-23 08:00:00	QQQ	ETF	212.2	212.2099	211.6	212.14	26140.0
2019-12-23 08:30:00	QQQ	ETF	212.14	212.28	212.1201	212.14	65482.0
2019-12-23 09:00:00	QQQ	ETF	212.15	212.17	211.98	212.03	198045.0
2019-12-23 09:30:00	QQQ	ETF	212.03	212.0898	211.79	211.87	2244990.0
2019-12-23 10:00:00	QQQ	ETF	211.88	211.97	211.74	211.83	1043442.0
2019-12-23 10:30:00	QQQ	ETF	211.83	212.03	211.785	212.02	880860.0
2019-12-23 11:00:00	QQQ	ETF	212.02	212.1	211.95	212.07	684046.0
2019-12-23 11:30:00	QQQ	ETF	212.07	212.15	212.05	212.125	533886.0
2019-12-23 12:00:00	QQQ	ETF	212.12	212.14	211.97	211.97	624386.0
2019-12-23 12:30:00	QQQ	ETF	211.98	212.02	211.91	211.93	569761.0

> showing 50 of 18,800 rows — these rows as CSV

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