PREVIEW / etf_30min / 2021-11-01

all etf 30-min files

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

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-11-01 04:00:00	SPY	ETF	459.92	460.75	459.92	460.66	17165.0
2021-11-01 04:30:00	SPY	ETF	460.66	460.92	460.65	460.89	16307.0
2021-11-01 05:00:00	SPY	ETF	460.88	461.29	460.88	461.04	10988.0
2021-11-01 05:30:00	SPY	ETF	461.07	461.14	461.0	461.02	5853.0
2021-11-01 06:00:00	SPY	ETF	461.07	461.25	461.04	461.07	59981.0
2021-11-01 06:30:00	SPY	ETF	461.05	461.34	461.05	461.33	31522.0
2021-11-01 07:00:00	SPY	ETF	461.28	461.42	461.16	461.21	27317.0
2021-11-01 07:30:00	SPY	ETF	461.2	461.2	461.0	461.07	47425.0
2021-11-01 08:00:00	SPY	ETF	461.3299	461.4	459.71	460.9	47510.0
2021-11-01 08:30:00	SPY	ETF	460.88	460.88	460.39	460.41	75340.0
2021-11-01 09:00:00	SPY	ETF	460.41	460.43	459.95	460.31	339346.0
2021-11-01 09:30:00	SPY	ETF	460.3	460.7021	459.14	459.27	6452425.0
2021-11-01 10:00:00	SPY	ETF	459.28	459.4	458.2	459.04	3815297.0
2021-11-01 10:30:00	SPY	ETF	459.03	459.03	458.26	458.59	2441658.0
2021-11-01 11:00:00	SPY	ETF	458.58	459.44	458.52	459.23	1938070.0
2021-11-01 11:30:00	SPY	ETF	459.23	459.52	459.01	459.4701	1286498.0
2021-11-01 12:00:00	SPY	ETF	459.49	459.73	459.37	459.675	1470855.0
2021-11-01 12:30:00	SPY	ETF	459.68	460.0	459.61	459.9675	1097228.0
2021-11-01 13:00:00	SPY	ETF	459.97	460.02	459.1	459.25	1395158.0
2021-11-01 13:30:00	SPY	ETF	459.26	459.39	458.675	458.83	1275079.0
2021-11-01 14:00:00	SPY	ETF	458.81	458.93	458.22	458.63	1738239.0
2021-11-01 14:30:00	SPY	ETF	458.61	459.32	458.61	459.2	1404397.0
2021-11-01 15:00:00	SPY	ETF	459.2	459.54	458.96	459.39	1471693.0
2021-11-01 15:30:00	SPY	ETF	459.37	460.23	459.37	460.1	6208378.0
2021-11-01 16:00:00	SPY	ETF	460.09	460.12	459.77	460.03	2556067.0
2021-11-01 16:30:00	SPY	ETF	460.02	460.1	459.98	460.09	113511.0
2021-11-01 17:00:00	SPY	ETF	460.04	460.04	459.91	459.99	60240.0
2021-11-01 17:30:00	SPY	ETF	459.98	460.06	459.96	460.02	11012.0
2021-11-01 18:00:00	SPY	ETF	460.04	460.1	459.8	460.05	50241.0
2021-11-01 18:30:00	SPY	ETF	460.04	460.29	460.04	460.25	25455.0
2021-11-01 19:00:00	SPY	ETF	460.25	460.25	459.9	460.09	31015.0
2021-11-01 19:30:00	SPY	ETF	459.91	459.98	459.84	459.84	12187.0
2021-11-01 04:00:00	QQQ	ETF	387.0	387.5	386.99	387.42	40085.0
2021-11-01 04:30:00	QQQ	ETF	387.51	387.61	387.4	387.61	20173.0
2021-11-01 05:00:00	QQQ	ETF	387.64	387.87	387.58	387.62	65611.0
2021-11-01 05:30:00	QQQ	ETF	387.65	387.7	387.43	387.56	22871.0
2021-11-01 06:00:00	QQQ	ETF	387.5	387.56	387.4	387.48	11382.0
2021-11-01 06:30:00	QQQ	ETF	387.5	387.73	387.5	387.73	9091.0
2021-11-01 07:00:00	QQQ	ETF	387.73	387.92	387.63	387.75	55098.0
2021-11-01 07:30:00	QQQ	ETF	387.73	387.73	387.52	387.55	37072.0
2021-11-01 08:00:00	QQQ	ETF	387.55	387.87	386.399	387.31	88733.0
2021-11-01 08:30:00	QQQ	ETF	387.3	387.3	386.6	386.8	162242.0
2021-11-01 09:00:00	QQQ	ETF	386.78	386.8	386.42	386.59	407282.0
2021-11-01 09:30:00	QQQ	ETF	386.56	386.83	385.13	385.29	4370731.0
2021-11-01 10:00:00	QQQ	ETF	385.29	385.79	384.42	385.65	3277573.0
2021-11-01 10:30:00	QQQ	ETF	385.65	385.86	384.93	385.35	1736269.0
2021-11-01 11:00:00	QQQ	ETF	385.331	386.34	385.3	386.24	1206796.0
2021-11-01 11:30:00	QQQ	ETF	386.24	386.66	386.08	386.65	863870.0
2021-11-01 12:00:00	QQQ	ETF	386.65	386.7098	386.35	386.53	642732.0
2021-11-01 12:30:00	QQQ	ETF	386.54	386.77	386.42	386.63	493575.0

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

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