PREVIEW / etf_30min / 2021-12-03

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-03.parquet
  size:    671 KB
  rows:    26,097

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-12-03 04:00:00	SPY	ETF	456.27	457.42	456.27	457.34	10100.0
2021-12-03 04:30:00	SPY	ETF	457.25	457.25	456.8	456.84	3109.0
2021-12-03 05:00:00	SPY	ETF	456.95	456.95	455.85	456.22	11841.0
2021-12-03 05:30:00	SPY	ETF	456.27	456.32	455.5	455.88	16814.0
2021-12-03 06:00:00	SPY	ETF	455.99	456.33	455.79	456.2	6620.0
2021-12-03 06:30:00	SPY	ETF	456.14	457.0	456.14	457.0	39351.0
2021-12-03 07:00:00	SPY	ETF	457.0	457.45	456.86	457.33	92269.0
2021-12-03 07:30:00	SPY	ETF	457.41	457.9	457.28	457.67	143109.0
2021-12-03 08:00:00	SPY	ETF	457.69	458.5	455.62	458.11	267237.0
2021-12-03 08:30:00	SPY	ETF	458.11	459.8	457.11	458.91	954550.0
2021-12-03 09:00:00	SPY	ETF	458.96	459.59	458.6	459.16	493881.0
2021-12-03 09:30:00	SPY	ETF	459.17	460.3	455.12	455.4	9944693.0
2021-12-03 10:00:00	SPY	ETF	455.42	456.13	453.54	455.6	8822189.0
2021-12-03 10:30:00	SPY	ETF	455.585	455.6	451.62	451.95	7618154.0
2021-12-03 11:00:00	SPY	ETF	451.98	453.36	451.12	453.14	7887202.0
2021-12-03 11:30:00	SPY	ETF	453.14	453.64	450.4	450.5165	6115545.0
2021-12-03 12:00:00	SPY	ETF	450.53	452.56	450.13	452.27	5267826.0
2021-12-03 12:30:00	SPY	ETF	452.29	453.25	451.09	451.8	4587643.0
2021-12-03 13:00:00	SPY	ETF	451.78	453.14	451.15	452.03	3969866.0
2021-12-03 13:30:00	SPY	ETF	452.03	452.09	450.3132	450.53	4719705.0
2021-12-03 14:00:00	SPY	ETF	450.5	451.5	449.435	450.82	6717269.0
2021-12-03 14:30:00	SPY	ETF	450.84	451.06	449.51	449.64	5896298.0
2021-12-03 15:00:00	SPY	ETF	449.64	451.77	448.92	451.08	7915723.0
2021-12-03 15:30:00	SPY	ETF	451.093	453.67	449.81	453.43	19703567.0
2021-12-03 16:00:00	SPY	ETF	453.44	453.99	452.46	452.96	4846801.0
2021-12-03 16:30:00	SPY	ETF	452.9	453.03	452.61	452.97	298691.0
2021-12-03 17:00:00	SPY	ETF	453.04	453.56	452.87	453.5	157911.0
2021-12-03 17:30:00	SPY	ETF	453.54	454.15	453.54	454.15	118045.0
2021-12-03 18:00:00	SPY	ETF	454.15	454.34	454.08	454.08	90455.0
2021-12-03 18:30:00	SPY	ETF	453.42	454.85	453.42	454.05	27523.0
2021-12-03 19:00:00	SPY	ETF	454.155	454.4	454.15	454.35	24394.0
2021-12-03 19:30:00	SPY	ETF	454.35	454.36	453.43	453.53	43444.0
2021-12-03 04:00:00	QQQ	ETF	389.21	389.77	388.8	389.38	24229.0
2021-12-03 04:30:00	QQQ	ETF	389.48	389.48	388.71	389.05	12222.0
2021-12-03 05:00:00	QQQ	ETF	389.13	389.13	388.35	388.72	12661.0
2021-12-03 05:30:00	QQQ	ETF	388.75	388.75	388.1	388.54	4993.0
2021-12-03 06:00:00	QQQ	ETF	388.56	388.99	388.55	388.92	15336.0
2021-12-03 06:30:00	QQQ	ETF	389.02	389.63	389.02	389.61	5949.0
2021-12-03 07:00:00	QQQ	ETF	389.72	390.25	389.5	390.11	113463.0
2021-12-03 07:30:00	QQQ	ETF	390.15	390.7	390.04	390.6	73823.0
2021-12-03 08:00:00	QQQ	ETF	390.52	391.24	388.24	390.94	217973.0
2021-12-03 08:30:00	QQQ	ETF	391.28	393.08	390.76	391.24	856356.0
2021-12-03 09:00:00	QQQ	ETF	391.32	392.12	390.98	391.22	181273.0
2021-12-03 09:30:00	QQQ	ETF	391.29	392.34	386.0	386.29	7486814.0
2021-12-03 10:00:00	QQQ	ETF	386.38	386.96	383.6	385.51	9901421.0
2021-12-03 10:30:00	QQQ	ETF	385.47	385.54	381.74	382.55	7923258.0
2021-12-03 11:00:00	QQQ	ETF	382.55	383.28	381.07	383.06	8215521.0
2021-12-03 11:30:00	QQQ	ETF	383.07	383.32	379.89	380.05	6844209.0
2021-12-03 12:00:00	QQQ	ETF	380.05	381.69	379.43	381.4201	4766708.0
2021-12-03 12:30:00	QQQ	ETF	381.48	382.43	380.32	381.17	4229746.0

> showing 50 of 26,097 rows — these rows as CSV

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