PREVIEW / etf_30min / 2021-06-01

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-01.parquet
  size:    624 KB
  rows:    24,404

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-06-01 04:00:00	SPY	ETF	421.48	421.7	421.2	421.28	17154.0
2021-06-01 04:30:00	SPY	ETF	421.24	421.7	421.14	421.63	9466.0
2021-06-01 05:00:00	SPY	ETF	421.65	421.92	421.55	421.75	13824.0
2021-06-01 05:30:00	SPY	ETF	421.75	421.88	421.68	421.7	20770.0
2021-06-01 06:00:00	SPY	ETF	421.73	421.91	421.73	421.91	3282.0
2021-06-01 06:30:00	SPY	ETF	421.8	421.87	421.71	421.87	53600.0
2021-06-01 07:00:00	SPY	ETF	421.84	422.49	421.83	422.29	101246.0
2021-06-01 07:30:00	SPY	ETF	422.27	422.27	422.09	422.2	119762.0
2021-06-01 08:00:00	SPY	ETF	421.8999	422.49	419.6	422.27	126664.0
2021-06-01 08:30:00	SPY	ETF	422.25	422.27	421.9	422.09	119869.0
2021-06-01 09:00:00	SPY	ETF	422.1	422.59	421.92	422.58	273548.0
2021-06-01 09:30:00	SPY	ETF	422.57	422.72	420.98	421.3	6322661.0
2021-06-01 10:00:00	SPY	ETF	421.3	421.5101	419.91	420.4471	4608644.0
2021-06-01 10:30:00	SPY	ETF	420.445	420.7	419.44	419.83	4496750.0
2021-06-01 11:00:00	SPY	ETF	419.81	420.33	419.56	420.22	2310105.0
2021-06-01 11:30:00	SPY	ETF	420.22	420.475	419.97	420.29	1759178.0
2021-06-01 12:00:00	SPY	ETF	420.3	420.36	419.735	420.025	1673618.0
2021-06-01 12:30:00	SPY	ETF	420.0211	420.24	419.69	419.825	1292993.0
2021-06-01 13:00:00	SPY	ETF	419.83	419.83	419.2	419.325	1807071.0
2021-06-01 13:30:00	SPY	ETF	419.32	419.645	419.245	419.6015	1472988.0
2021-06-01 14:00:00	SPY	ETF	419.6	420.05	419.46	420.035	1731609.0
2021-06-01 14:30:00	SPY	ETF	420.035	420.38	419.95	420.33	2361132.0
2021-06-01 15:00:00	SPY	ETF	420.33	420.36	419.85	419.8641	2262272.0
2021-06-01 15:30:00	SPY	ETF	419.865	420.0	419.45	419.63	6497466.0
2021-06-01 16:00:00	SPY	ETF	419.63	419.925	419.49	419.74	2995482.0
2021-06-01 16:30:00	SPY	ETF	419.71	419.73	419.51	419.59	106831.0
2021-06-01 17:00:00	SPY	ETF	419.72	419.72	419.56	419.65	41520.0
2021-06-01 17:30:00	SPY	ETF	419.65	419.7	419.47	419.5	41729.0
2021-06-01 18:00:00	SPY	ETF	419.55	419.55	418.99	419.24	78754.0
2021-06-01 18:30:00	SPY	ETF	419.67	419.67	418.9	418.93	31441.0
2021-06-01 19:00:00	SPY	ETF	418.93	419.07	418.82	419.05	21482.0
2021-06-01 19:30:00	SPY	ETF	419.08	419.29	419.08	419.29	24064.0
2021-06-01 04:00:00	QQQ	ETF	334.16	334.67	334.16	334.4	32733.0
2021-06-01 04:30:00	QQQ	ETF	334.4	334.92	334.36	334.89	20831.0
2021-06-01 05:00:00	QQQ	ETF	334.88	335.13	334.81	335.0	14975.0
2021-06-01 05:30:00	QQQ	ETF	335.03	335.17	334.9	334.95	13020.0
2021-06-01 06:00:00	QQQ	ETF	334.99	335.17	334.97	335.1	9998.0
2021-06-01 06:30:00	QQQ	ETF	335.08	335.08	334.9	334.96	33993.0
2021-06-01 07:00:00	QQQ	ETF	334.89	335.41	334.76	335.23	102820.0
2021-06-01 07:30:00	QQQ	ETF	335.21	335.21	334.95	335.0	99830.0
2021-06-01 08:00:00	QQQ	ETF	335.0596	335.23	333.64	335.16	116420.0
2021-06-01 08:30:00	QQQ	ETF	335.14	335.16	334.8	335.04	89658.0
2021-06-01 09:00:00	QQQ	ETF	335.03	335.29	334.91	335.28	113369.0
2021-06-01 09:30:00	QQQ	ETF	335.31	335.785	334.15	334.59	3735628.0
2021-06-01 10:00:00	QQQ	ETF	334.6	334.7815	332.31	333.172	3397758.0
2021-06-01 10:30:00	QQQ	ETF	333.18	333.48	331.43	331.99	3426879.0
2021-06-01 11:00:00	QQQ	ETF	331.97	332.865	331.65	332.791	2175891.0
2021-06-01 11:30:00	QQQ	ETF	332.79	333.24	332.6218	333.055	1322934.0
2021-06-01 12:00:00	QQQ	ETF	333.06	333.23	332.58	333.13	1398280.0
2021-06-01 12:30:00	QQQ	ETF	333.13	333.46	332.96	333.18	816014.0

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

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