PREVIEW / etf_30min / 2022-05-24

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-24.parquet
  size:    683 KB
  rows:    26,820

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-05-24 04:00:00	SPY	ETF	392.38	392.38	391.57	391.96	35707.0
2022-05-24 04:30:00	SPY	ETF	392.08	392.08	390.81	390.91	20575.0
2022-05-24 05:00:00	SPY	ETF	391.03	391.6	390.99	391.56	24160.0
2022-05-24 05:30:00	SPY	ETF	391.51	392.4	391.51	392.22	13559.0
2022-05-24 06:00:00	SPY	ETF	392.2	392.95	391.98	392.74	19379.0
2022-05-24 06:30:00	SPY	ETF	392.91	392.91	392.37	392.45	43369.0
2022-05-24 07:00:00	SPY	ETF	392.48	393.54	392.48	393.31	118644.0
2022-05-24 07:30:00	SPY	ETF	393.36	393.55	392.4	392.58	161013.0
2022-05-24 08:00:00	SPY	ETF	392.85	393.95	391.08	392.42	472019.0
2022-05-24 08:30:00	SPY	ETF	392.43	393.41	392.26	393.08	251879.0
2022-05-24 09:00:00	SPY	ETF	393.08	393.32	392.48	392.56	330278.0
2022-05-24 09:30:00	SPY	ETF	392.56	393.6	390.66	390.77	6447211.0
2022-05-24 10:00:00	SPY	ETF	390.8	390.92	387.43	388.9901	6971452.0
2022-05-24 10:30:00	SPY	ETF	389.0	389.02	386.96	388.1	4426814.0
2022-05-24 11:00:00	SPY	ETF	388.11	388.98	387.34	388.605	4222938.0
2022-05-24 11:30:00	SPY	ETF	388.62	391.08	387.97	390.265	4260688.0
2022-05-24 12:00:00	SPY	ETF	390.25	392.63	389.76	390.78	4388723.0
2022-05-24 12:30:00	SPY	ETF	390.77	391.07	389.17	390.2299	3332290.0
2022-05-24 13:00:00	SPY	ETF	390.22	390.2464	388.76	389.99	2651167.0
2022-05-24 13:30:00	SPY	ETF	390.0	392.01	389.17	391.4701	3452050.0
2022-05-24 14:00:00	SPY	ETF	391.53	393.29	390.67	391.93	4076054.0
2022-05-24 14:30:00	SPY	ETF	391.9	393.1	390.03	390.85	3981644.0
2022-05-24 15:00:00	SPY	ETF	390.82	392.9	390.67	392.76	4564197.0
2022-05-24 15:30:00	SPY	ETF	392.76	395.15	392.48	394.0	12808253.0
2022-05-24 16:00:00	SPY	ETF	393.99	394.77	393.6526	394.0501	3602302.0
2022-05-24 16:30:00	SPY	ETF	394.1	394.8796	393.89	394.745	148420.0
2022-05-24 17:00:00	SPY	ETF	394.72	394.83	394.61	394.6947	39490.0
2022-05-24 17:30:00	SPY	ETF	394.69	394.86	394.65	394.79	17093.0
2022-05-24 18:00:00	SPY	ETF	394.79	395.81	394.79	395.62	59817.0
2022-05-24 18:30:00	SPY	ETF	395.66	395.9	395.48	395.62	40095.0
2022-05-24 19:00:00	SPY	ETF	395.62	396.05	395.62	395.79	36052.0
2022-05-24 19:30:00	SPY	ETF	395.79	395.99	395.39	395.57	34962.0
2022-05-24 04:00:00	QQQ	ETF	287.69	288.36	287.56	288.0	88584.0
2022-05-24 04:30:00	QQQ	ETF	288.08	288.12	287.08	287.38	49282.0
2022-05-24 05:00:00	QQQ	ETF	287.31	287.74	287.31	287.74	36814.0
2022-05-24 05:30:00	QQQ	ETF	287.7	288.52	287.7	288.39	140127.0
2022-05-24 06:00:00	QQQ	ETF	288.34	288.8	288.08	288.65	36931.0
2022-05-24 06:30:00	QQQ	ETF	288.51	288.8	288.24	288.37	64849.0
2022-05-24 07:00:00	QQQ	ETF	288.5	289.45	288.47	289.14	190692.0
2022-05-24 07:30:00	QQQ	ETF	289.1	289.49	288.3	288.5	160281.0
2022-05-24 08:00:00	QQQ	ETF	288.4701	293.7	287.4	288.16	364434.0
2022-05-24 08:30:00	QQQ	ETF	288.13	289.01	287.95	288.62	237255.0
2022-05-24 09:00:00	QQQ	ETF	288.72	288.9	288.05	288.16	308356.0
2022-05-24 09:30:00	QQQ	ETF	288.125	288.86	284.67	284.75	7013611.0
2022-05-24 10:00:00	QQQ	ETF	284.76	284.78	282.25	283.97	6472521.0
2022-05-24 10:30:00	QQQ	ETF	283.965	284.4771	282.61	283.5	4171542.0
2022-05-24 11:00:00	QQQ	ETF	283.507	284.64	283.15	284.295	2919454.0
2022-05-24 11:30:00	QQQ	ETF	284.31	286.18	283.5601	285.46	3813923.0
2022-05-24 12:00:00	QQQ	ETF	285.46	287.89	285.04	286.1	3826729.0
2022-05-24 12:30:00	QQQ	ETF	286.0547	286.3	284.43	285.2852	2491872.0

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

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