PREVIEW / etf_30min / 2020-12-11

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-11.parquet
  size:    579 KB
  rows:    21,617

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
2020-12-11 04:00:00	SPY	ETF	364.75	365.36	364.67	365.1	44684.0
2020-12-11 04:30:00	SPY	ETF	365.17	365.29	364.5	364.61	15211.0
2020-12-11 05:00:00	SPY	ETF	364.5	365.04	364.35	365.02	41948.0
2020-12-11 05:30:00	SPY	ETF	364.96	365.04	363.41	363.5	29818.0
2020-12-11 06:00:00	SPY	ETF	363.41	363.82	362.86	363.05	107074.0
2020-12-11 06:30:00	SPY	ETF	363.05	363.9	363.05	363.86	47308.0
2020-12-11 07:00:00	SPY	ETF	363.86	364.31	363.83	364.17	96318.0
2020-12-11 07:30:00	SPY	ETF	364.16	364.43	363.99	364.4	110406.0
2020-12-11 08:00:00	SPY	ETF	364.36	367.02	363.4204	364.15	137467.0
2020-12-11 08:30:00	SPY	ETF	364.2	364.65	364.07	364.57	100627.0
2020-12-11 09:00:00	SPY	ETF	364.56	364.94	364.43	364.92	121826.0
2020-12-11 09:30:00	SPY	ETF	364.9	365.34	364.28	365.05	5801451.0
2020-12-11 10:00:00	SPY	ETF	365.06	365.92	365.03	365.4459	2472034.0
2020-12-11 10:30:00	SPY	ETF	365.45	365.49	364.655	364.99	2700836.0
2020-12-11 11:00:00	SPY	ETF	364.992	365.33	364.52	364.54	2367243.0
2020-12-11 11:30:00	SPY	ETF	364.53	364.74	363.76	364.33	4889677.0
2020-12-11 12:00:00	SPY	ETF	364.35	364.526	363.27	363.77	3635894.0
2020-12-11 12:30:00	SPY	ETF	363.76	366.7402	363.26	364.24	3268736.0
2020-12-11 13:00:00	SPY	ETF	364.23	364.77	364.1401	364.645	2769425.0
2020-12-11 13:30:00	SPY	ETF	364.64	365.9535	364.585	365.676	3812998.0
2020-12-11 14:00:00	SPY	ETF	365.69	365.945	365.39	365.69	2143982.0
2020-12-11 14:30:00	SPY	ETF	365.68	366.21	365.66	365.6779	2198241.0
2020-12-11 15:00:00	SPY	ETF	365.69	366.58	365.46	366.085	3779391.0
2020-12-11 15:30:00	SPY	ETF	366.09	366.53	365.71	366.28	8096491.0
2020-12-11 16:00:00	SPY	ETF	366.28	366.45	365.69	366.23	7340718.0
2020-12-11 16:30:00	SPY	ETF	366.15	366.7402	366.01	366.11	273417.0
2020-12-11 17:00:00	SPY	ETF	366.1	366.3	365.94	365.94	81541.0
2020-12-11 17:30:00	SPY	ETF	365.94	366.3	365.92	366.01	32689.0
2020-12-11 18:00:00	SPY	ETF	366.09	366.2	366.07	366.07	12206.0
2020-12-11 18:30:00	SPY	ETF	366.08	366.25	365.92	366.08	24133.0
2020-12-11 19:00:00	SPY	ETF	366.08	366.14	366.02	366.02	14218.0
2020-12-11 19:30:00	SPY	ETF	366.08	366.14	366.05	366.1	8466.0
2020-12-11 04:00:00	QQQ	ETF	300.98	301.25	300.91	301.22	18973.0
2020-12-11 04:30:00	QQQ	ETF	301.05	301.22	300.63	300.63	7563.0
2020-12-11 05:00:00	QQQ	ETF	300.54	300.93	300.54	300.87	10940.0
2020-12-11 05:30:00	QQQ	ETF	300.89	300.92	299.75	299.75	29244.0
2020-12-11 06:00:00	QQQ	ETF	300.02	300.04	299.22	299.61	21781.0
2020-12-11 06:30:00	QQQ	ETF	299.52	300.06	299.52	300.0	14554.0
2020-12-11 07:00:00	QQQ	ETF	300.09	300.39	300.09	300.25	45967.0
2020-12-11 07:30:00	QQQ	ETF	300.29	300.52	299.98	300.5	52496.0
2020-12-11 08:00:00	QQQ	ETF	300.25	302.52	299.9096	300.43	68367.0
2020-12-11 08:30:00	QQQ	ETF	300.44	300.85	300.44	300.75	49886.0
2020-12-11 09:00:00	QQQ	ETF	300.73	300.89	300.55	300.81	86489.0
2020-12-11 09:30:00	QQQ	ETF	300.81	301.4	299.45	300.43	2946318.0
2020-12-11 10:00:00	QQQ	ETF	300.43	301.5	300.24	301.19	1435002.0
2020-12-11 10:30:00	QQQ	ETF	301.225	301.23	300.03	300.38	1167130.0
2020-12-11 11:00:00	QQQ	ETF	300.41	300.8	299.66	299.681	1241974.0
2020-12-11 11:30:00	QQQ	ETF	299.68	299.94	299.01	299.56	1442131.0
2020-12-11 12:00:00	QQQ	ETF	299.57	299.9319	298.7128	299.02	1432131.0
2020-12-11 12:30:00	QQQ	ETF	299.025	299.51	298.47	299.42	1477384.0

> showing 50 of 21,617 rows — these rows as CSV

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