PREVIEW / etf_30min / 2022-03-10

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-10.parquet
  size:    678 KB
  rows:    26,837

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
2022-03-10 04:00:00	SPY	ETF	424.49	426.75	424.49	425.35	43386.0
2022-03-10 04:30:00	SPY	ETF	425.24	425.84	424.2	424.66	104057.0
2022-03-10 05:00:00	SPY	ETF	424.64	425.14	423.82	424.87	61145.0
2022-03-10 05:30:00	SPY	ETF	424.83	424.83	423.9	423.9	15210.0
2022-03-10 06:00:00	SPY	ETF	423.81	424.3	423.2	424.25	41296.0
2022-03-10 06:30:00	SPY	ETF	424.1	424.33	422.8	423.31	152850.0
2022-03-10 07:00:00	SPY	ETF	423.28	424.0	422.52	423.99	219185.0
2022-03-10 07:30:00	SPY	ETF	423.87	424.0	422.35	422.39	218533.0
2022-03-10 08:00:00	SPY	ETF	423.2999	426.87	421.89	422.78	516010.0
2022-03-10 08:30:00	SPY	ETF	422.75	424.41	421.75	422.0	1073389.0
2022-03-10 09:00:00	SPY	ETF	421.99	422.53	421.75	422.5	465197.0
2022-03-10 09:30:00	SPY	ETF	422.52	425.0	422.0493	424.535	9754738.0
2022-03-10 10:00:00	SPY	ETF	424.55	425.29	423.14	423.18	6582302.0
2022-03-10 10:30:00	SPY	ETF	423.17	423.6399	421.52	421.78	4687986.0
2022-03-10 11:00:00	SPY	ETF	421.77	421.88	420.5	420.7762	4130555.0
2022-03-10 11:30:00	SPY	ETF	420.77	422.02	420.44	421.92	3451175.0
2022-03-10 12:00:00	SPY	ETF	421.91	423.19	421.68	422.87	2764139.0
2022-03-10 12:30:00	SPY	ETF	422.86	422.905	421.16	421.49	2263296.0
2022-03-10 13:00:00	SPY	ETF	421.49	422.68	421.1	422.39	2659343.0
2022-03-10 13:30:00	SPY	ETF	422.39	423.87	422.1	423.4799	3535993.0
2022-03-10 14:00:00	SPY	ETF	423.48	425.31	423.35	424.79	4381453.0
2022-03-10 14:30:00	SPY	ETF	424.81	426.09	424.47	425.64	4145050.0
2022-03-10 15:00:00	SPY	ETF	425.66	425.7818	424.08	424.905	4724172.0
2022-03-10 15:30:00	SPY	ETF	424.9	426.43	424.161	425.48	11306880.0
2022-03-10 16:00:00	SPY	ETF	425.5	425.8	425.08	425.72	3870334.0
2022-03-10 16:30:00	SPY	ETF	425.75	425.96	425.39	425.42	157027.0
2022-03-10 17:00:00	SPY	ETF	425.4	425.67	425.0	425.32	135615.0
2022-03-10 17:30:00	SPY	ETF	425.32	425.34	425.1	425.18	13189.0
2022-03-10 18:00:00	SPY	ETF	425.34	426.2	425.18	425.95	135359.0
2022-03-10 18:30:00	SPY	ETF	426.05	426.56	425.99	426.14	25577.0
2022-03-10 19:00:00	SPY	ETF	426.239	426.239	425.77	425.91	79442.0
2022-03-10 19:30:00	SPY	ETF	426.1	426.2	424.94	425.05	96337.0
2022-03-10 04:00:00	QQQ	ETF	332.8	334.14	332.8	333.0	55519.0
2022-03-10 04:30:00	QQQ	ETF	333.07	333.42	332.0	332.3	71401.0
2022-03-10 05:00:00	QQQ	ETF	332.1	332.65	331.6	332.42	39264.0
2022-03-10 05:30:00	QQQ	ETF	332.26	332.32	331.23	331.23	36809.0
2022-03-10 06:00:00	QQQ	ETF	331.23	331.75	330.58	331.41	53158.0
2022-03-10 06:30:00	QQQ	ETF	331.33	331.48	329.92	330.42	255326.0
2022-03-10 07:00:00	QQQ	ETF	330.4	331.06	329.75	331.06	299711.0
2022-03-10 07:30:00	QQQ	ETF	331.02	331.15	329.56	329.65	340597.0
2022-03-10 08:00:00	QQQ	ETF	330.5499	335.241	329.5	330.32	601641.0
2022-03-10 08:30:00	QQQ	ETF	330.3	332.19	329.59	329.75	1243994.0
2022-03-10 09:00:00	QQQ	ETF	329.73	330.82	329.55	330.82	438384.0
2022-03-10 09:30:00	QQQ	ETF	330.82	331.51	328.92	331.17	7535725.0
2022-03-10 10:00:00	QQQ	ETF	331.1358	331.98	329.29	329.66	4999011.0
2022-03-10 10:30:00	QQQ	ETF	329.65	330.0	327.58	327.88	4763281.0
2022-03-10 11:00:00	QQQ	ETF	327.87	327.948	326.71	327.07	3481155.0
2022-03-10 11:30:00	QQQ	ETF	327.08	328.44	326.84	328.33	2503798.0
2022-03-10 12:00:00	QQQ	ETF	328.32	329.43	327.76	328.97	2590012.0
2022-03-10 12:30:00	QQQ	ETF	328.96	328.9884	327.4	327.57	2384390.0

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

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