PREVIEW / etf_30min / 2023-05-18

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-18.parquet
  size:    700 KB
  rows:    27,823

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
2023-05-18 04:00:00	SPY	ETF	415.69	416.3	415.2	416.09	19605.0
2023-05-18 04:30:00	SPY	ETF	416.0	416.03	415.84	415.93	7772.0
2023-05-18 05:00:00	SPY	ETF	415.74	415.94	415.72	415.94	2912.0
2023-05-18 05:30:00	SPY	ETF	415.88	416.19	415.88	416.12	14424.0
2023-05-18 06:00:00	SPY	ETF	416.11	416.2	416.01	416.08	14182.0
2023-05-18 06:30:00	SPY	ETF	416.09	416.47	416.09	416.25	125849.0
2023-05-18 07:00:00	SPY	ETF	416.24	416.52	416.2	416.21	107688.0
2023-05-18 07:30:00	SPY	ETF	416.21	416.3	416.07	416.13	106541.0
2023-05-18 08:00:00	SPY	ETF	416.2213	416.5	414.96	415.87	207420.0
2023-05-18 08:30:00	SPY	ETF	415.87	416.0	414.59	414.63	517180.0
2023-05-18 09:00:00	SPY	ETF	414.6	415.0599	414.31	414.92	397992.0
2023-05-18 09:30:00	SPY	ETF	414.9	415.47	414.67	415.1494	4576432.0
2023-05-18 10:00:00	SPY	ETF	415.15	416.9	414.95	416.89	5390795.0
2023-05-18 10:30:00	SPY	ETF	416.89	417.53	416.58	417.28	4829775.0
2023-05-18 11:00:00	SPY	ETF	417.28	417.93	416.9373	417.295	4090873.0
2023-05-18 11:30:00	SPY	ETF	417.31	418.06	416.775	417.08	4440304.0
2023-05-18 12:00:00	SPY	ETF	417.08	417.13	415.72	416.1597	4627384.0
2023-05-18 12:30:00	SPY	ETF	416.16	416.47	415.73	416.2	2885806.0
2023-05-18 13:00:00	SPY	ETF	416.2	417.21	416.12	416.14	3831558.0
2023-05-18 13:30:00	SPY	ETF	416.14	416.67	415.395	415.625	3034962.0
2023-05-18 14:00:00	SPY	ETF	415.62	416.76	415.47	416.5336	3222727.0
2023-05-18 14:30:00	SPY	ETF	416.538	417.14	416.5372	417.03	3015900.0
2023-05-18 15:00:00	SPY	ETF	417.04	417.99	416.8123	417.785	3933849.0
2023-05-18 15:30:00	SPY	ETF	417.79	419.67	417.73	419.23	16346565.0
2023-05-18 16:00:00	SPY	ETF	419.22	419.5	419.08	419.24	3846224.0
2023-05-18 16:30:00	SPY	ETF	419.23	419.65	419.2	419.6	245121.0
2023-05-18 17:00:00	SPY	ETF	419.61	419.69	419.59	419.65	39212.0
2023-05-18 17:30:00	SPY	ETF	419.66	419.79	419.65	419.75	120214.0
2023-05-18 18:00:00	SPY	ETF	419.71	420.65	419.48	420.22	246249.0
2023-05-18 18:30:00	SPY	ETF	420.23	420.39	420.1	420.39	73745.0
2023-05-18 19:00:00	SPY	ETF	420.27	420.27	419.96	420.08	25338.0
2023-05-18 19:30:00	SPY	ETF	420.04	420.04	419.88	419.9	51932.0
2023-05-18 04:00:00	QQQ	ETF	331.5	332.04	331.5	331.9	20614.0
2023-05-18 04:30:00	QQQ	ETF	331.87	331.87	331.75	331.79	8347.0
2023-05-18 05:00:00	QQQ	ETF	331.69	331.78	331.68	331.78	5125.0
2023-05-18 05:30:00	QQQ	ETF	331.74	331.9	331.74	331.8	5871.0
2023-05-18 06:00:00	QQQ	ETF	331.9	331.93	331.79	331.88	6538.0
2023-05-18 06:30:00	QQQ	ETF	331.94	332.12	331.9	331.9	37819.0
2023-05-18 07:00:00	QQQ	ETF	331.92	332.22	331.92	332.14	42398.0
2023-05-18 07:30:00	QQQ	ETF	332.13	332.21	332.07	332.12	31142.0
2023-05-18 08:00:00	QQQ	ETF	332.04	332.2101	331.06	331.96	135430.0
2023-05-18 08:30:00	QQQ	ETF	331.9	331.93	331.15	331.17	400721.0
2023-05-18 09:00:00	QQQ	ETF	331.15	331.64	331.001	331.51	385776.0
2023-05-18 09:30:00	QQQ	ETF	331.52	333.08	331.5	332.97	5342943.0
2023-05-18 10:00:00	QQQ	ETF	332.98	334.4797	332.66	334.41	4741944.0
2023-05-18 10:30:00	QQQ	ETF	334.43	334.84	334.05	334.68	4195481.0
2023-05-18 11:00:00	QQQ	ETF	334.69	335.73	334.64	335.5695	4061762.0
2023-05-18 11:30:00	QQQ	ETF	335.57	336.4	335.37	335.64	4211744.0
2023-05-18 12:00:00	QQQ	ETF	335.64	335.72	334.44	334.68	4102966.0
2023-05-18 12:30:00	QQQ	ETF	334.69	335.03	334.47	334.84	2587965.0

> showing 50 of 27,823 rows — these rows as CSV

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