PREVIEW / etf_30min / 2021-01-11

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-11.parquet
  size:    644 KB
  rows:    24,017

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
2021-01-11 04:00:00	SPY	ETF	379.47	379.6	379.11	379.3	35637.0
2021-01-11 04:30:00	SPY	ETF	379.28	379.53	378.84	378.84	13635.0
2021-01-11 05:00:00	SPY	ETF	378.8	379.34	378.79	379.34	13139.0
2021-01-11 05:30:00	SPY	ETF	379.25	379.53	379.08	379.48	14700.0
2021-01-11 06:00:00	SPY	ETF	379.53	379.53	379.02	379.3	8631.0
2021-01-11 06:30:00	SPY	ETF	379.2	379.63	379.2	379.42	9552.0
2021-01-11 07:00:00	SPY	ETF	379.47	379.57	378.72	379.15	186771.0
2021-01-11 07:30:00	SPY	ETF	379.2	379.28	379.01	379.25	114372.0
2021-01-11 08:00:00	SPY	ETF	379.19	379.81	378.46	378.46	235647.0
2021-01-11 08:30:00	SPY	ETF	378.41	378.5002	377.76	377.91	464733.0
2021-01-11 09:00:00	SPY	ETF	377.89	378.19	377.25	377.92	387104.0
2021-01-11 09:30:00	SPY	ETF	377.85	379.3	377.7189	379.09	8316341.0
2021-01-11 10:00:00	SPY	ETF	379.1	379.82	378.84	379.66	3148236.0
2021-01-11 10:30:00	SPY	ETF	379.66	379.89	378.97	379.5232	2554214.0
2021-01-11 11:00:00	SPY	ETF	379.52	379.97	378.58	379.85	2535027.0
2021-01-11 11:30:00	SPY	ETF	379.85	379.93	379.57	379.8169	2261882.0
2021-01-11 12:00:00	SPY	ETF	379.82	380.09	379.71	379.8862	1610065.0
2021-01-11 12:30:00	SPY	ETF	379.89	380.58	379.88	380.24	1749935.0
2021-01-11 13:00:00	SPY	ETF	380.249	380.48	379.65	379.7358	1928179.0
2021-01-11 13:30:00	SPY	ETF	379.74	379.82	378.78	379.24	2286934.0
2021-01-11 14:00:00	SPY	ETF	379.24	379.2411	378.3101	378.68	2547597.0
2021-01-11 14:30:00	SPY	ETF	378.67	379.6	378.45	379.52	2703812.0
2021-01-11 15:00:00	SPY	ETF	379.53	379.64	378.23	378.2699	3703846.0
2021-01-11 15:30:00	SPY	ETF	378.27	379.33	378.12	378.74	9229372.0
2021-01-11 16:00:00	SPY	ETF	378.77	379.4	378.49	378.98	3575896.0
2021-01-11 16:30:00	SPY	ETF	379.0	379.01	378.7	378.75	163909.0
2021-01-11 17:00:00	SPY	ETF	378.69	378.95	378.68	378.95	105433.0
2021-01-11 17:30:00	SPY	ETF	378.95	379.0	378.69	378.94	43789.0
2021-01-11 18:00:00	SPY	ETF	379.03	379.2	378.71	379.13	83454.0
2021-01-11 18:30:00	SPY	ETF	379.15	379.4	378.96	379.27	31390.0
2021-01-11 19:00:00	SPY	ETF	379.18	379.46	379.0	379.23	38022.0
2021-01-11 19:30:00	SPY	ETF	379.29	379.95	379.24	379.74	63801.0
2021-01-11 04:00:00	QQQ	ETF	318.29	318.29	317.8	317.9	44425.0
2021-01-11 04:30:00	QQQ	ETF	317.94	318.05	317.65	317.65	13570.0
2021-01-11 05:00:00	QQQ	ETF	317.58	317.94	317.4	317.94	23172.0
2021-01-11 05:30:00	QQQ	ETF	317.94	318.07	317.61	317.98	23401.0
2021-01-11 06:00:00	QQQ	ETF	318.03	318.03	317.77	317.89	14332.0
2021-01-11 06:30:00	QQQ	ETF	317.84	318.19	317.84	317.95	14069.0
2021-01-11 07:00:00	QQQ	ETF	317.97	317.97	316.95	317.3	123922.0
2021-01-11 07:30:00	QQQ	ETF	317.34	317.74	317.34	317.58	49147.0
2021-01-11 08:00:00	QQQ	ETF	317.5	318.21	316.67	316.68	164392.0
2021-01-11 08:30:00	QQQ	ETF	316.77	316.8	316.15	316.35	247052.0
2021-01-11 09:00:00	QQQ	ETF	316.36	316.48	315.7	315.99	226818.0
2021-01-11 09:30:00	QQQ	ETF	315.99	316.21	314.245	315.87	4924301.0
2021-01-11 10:00:00	QQQ	ETF	315.88	316.8	315.475	316.63	2263850.0
2021-01-11 10:30:00	QQQ	ETF	316.64	316.96	315.71	316.27	1756294.0
2021-01-11 11:00:00	QQQ	ETF	316.27	316.47	315.205	316.39	1222676.0
2021-01-11 11:30:00	QQQ	ETF	316.3	316.58	316.01	316.48	697897.0
2021-01-11 12:00:00	QQQ	ETF	316.47	316.75	316.31	316.74	585330.0
2021-01-11 12:30:00	QQQ	ETF	316.74	317.19	316.62	316.7399	706331.0

> showing 50 of 24,017 rows — these rows as CSV

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