PREVIEW / etf_30min / 2022-03-25

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-25.parquet
  size:    661 KB
  rows:    25,983

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-25 04:00:00	SPY	ETF	450.8	450.97	449.25	449.53	23133.0
2022-03-25 04:30:00	SPY	ETF	449.52	450.07	449.47	449.99	11482.0
2022-03-25 05:00:00	SPY	ETF	450.0	450.31	449.42	449.92	9768.0
2022-03-25 05:30:00	SPY	ETF	449.95	450.6	449.79	450.56	5597.0
2022-03-25 06:00:00	SPY	ETF	450.62	450.8	450.48	450.8	23796.0
2022-03-25 06:30:00	SPY	ETF	450.88	451.49	450.66	451.27	15157.0
2022-03-25 07:00:00	SPY	ETF	451.31	452.2	450.88	452.06	46674.0
2022-03-25 07:30:00	SPY	ETF	452.01	452.16	451.62	451.92	85450.0
2022-03-25 08:00:00	SPY	ETF	452.05	452.16	449.5896	451.97	101547.0
2022-03-25 08:30:00	SPY	ETF	451.94	452.0	451.58	451.85	59588.0
2022-03-25 09:00:00	SPY	ETF	451.86	451.86	451.0	451.13	248332.0
2022-03-25 09:30:00	SPY	ETF	451.16	451.63	450.3	450.8601	4504646.0
2022-03-25 10:00:00	SPY	ETF	450.88	452.49	450.45	451.84	3191816.0
2022-03-25 10:30:00	SPY	ETF	451.85	452.98	451.84	452.33	3321157.0
2022-03-25 11:00:00	SPY	ETF	452.33	452.52	448.43	449.07	6319311.0
2022-03-25 11:30:00	SPY	ETF	449.08	450.06	448.6834	449.275	4223156.0
2022-03-25 12:00:00	SPY	ETF	449.29	450.42	448.9601	450.26	2967143.0
2022-03-25 12:30:00	SPY	ETF	450.26	450.48	449.26	450.06	2465141.0
2022-03-25 13:00:00	SPY	ETF	450.07	450.78	449.54	449.96	2670197.0
2022-03-25 13:30:00	SPY	ETF	449.965	451.43	449.965	451.335	2543612.0
2022-03-25 14:00:00	SPY	ETF	451.35	451.88	451.14	451.72	2622204.0
2022-03-25 14:30:00	SPY	ETF	451.71	452.195	451.534	451.885	2326817.0
2022-03-25 15:00:00	SPY	ETF	451.885	451.965	450.01	450.07	3927035.0
2022-03-25 15:30:00	SPY	ETF	450.06	452.79	449.71	452.66	8936125.0
2022-03-25 16:00:00	SPY	ETF	452.64	452.74	452.25	452.59	2254404.0
2022-03-25 16:30:00	SPY	ETF	452.59	452.69	452.54	452.64	168020.0
2022-03-25 17:00:00	SPY	ETF	452.61	452.69	452.5	452.6	123065.0
2022-03-25 17:30:00	SPY	ETF	452.6	452.69	452.56	452.6	12635.0
2022-03-25 18:00:00	SPY	ETF	452.56	452.72	452.56	452.7	9224.0
2022-03-25 18:30:00	SPY	ETF	452.71	452.8	452.71	452.75	13978.0
2022-03-25 19:00:00	SPY	ETF	452.8	453.01	452.8	452.9	20703.0
2022-03-25 19:30:00	SPY	ETF	453.0	453.0	452.84	452.9	19893.0
2022-03-25 04:00:00	QQQ	ETF	360.1	360.1	357.94	358.35	143003.0
2022-03-25 04:30:00	QQQ	ETF	358.34	358.84	358.22	358.68	41749.0
2022-03-25 05:00:00	QQQ	ETF	358.78	359.12	358.24	358.98	21639.0
2022-03-25 05:30:00	QQQ	ETF	358.95	359.62	358.9	359.45	35035.0
2022-03-25 06:00:00	QQQ	ETF	359.56	359.87	359.41	359.85	22840.0
2022-03-25 06:30:00	QQQ	ETF	359.86	360.37	359.65	360.3	51031.0
2022-03-25 07:00:00	QQQ	ETF	360.28	361.35	359.94	361.21	156383.0
2022-03-25 07:30:00	QQQ	ETF	361.17	361.4	360.93	361.11	134493.0
2022-03-25 08:00:00	QQQ	ETF	360.31	361.3804	357.9896	361.11	201418.0
2022-03-25 08:30:00	QQQ	ETF	361.13	361.13	360.5	360.76	161735.0
2022-03-25 09:00:00	QQQ	ETF	360.75	360.75	359.51	359.57	320182.0
2022-03-25 09:30:00	QQQ	ETF	359.58	360.18	358.2607	358.55	6008016.0
2022-03-25 10:00:00	QQQ	ETF	358.55	359.86	357.9004	359.11	3788876.0
2022-03-25 10:30:00	QQQ	ETF	359.11	360.67	358.7	359.2017	3595403.0
2022-03-25 11:00:00	QQQ	ETF	359.22	359.47	354.9438	355.53	5832215.0
2022-03-25 11:30:00	QQQ	ETF	355.54	356.55	355.2	355.7138	3166012.0
2022-03-25 12:00:00	QQQ	ETF	355.76	357.1099	355.22	356.93	2737306.0
2022-03-25 12:30:00	QQQ	ETF	356.92	357.28	355.9231	356.71	1978419.0

> showing 50 of 25,983 rows — these rows as CSV

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