PREVIEW / etf_30min / 2023-04-20

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-20.parquet
  size:    675 KB
  rows:    26,841

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-04-20 04:00:00	SPY	ETF	411.55	411.64	411.22	411.4	19534.0
2023-04-20 04:30:00	SPY	ETF	411.38	411.47	411.0	411.21	28585.0
2023-04-20 05:00:00	SPY	ETF	411.18	411.42	411.13	411.42	11722.0
2023-04-20 05:30:00	SPY	ETF	411.41	411.58	411.32	411.47	10411.0
2023-04-20 06:00:00	SPY	ETF	411.47	411.62	411.29	411.32	123619.0
2023-04-20 06:30:00	SPY	ETF	411.32	411.75	411.27	411.75	20848.0
2023-04-20 07:00:00	SPY	ETF	411.75	411.97	411.56	411.87	130455.0
2023-04-20 07:30:00	SPY	ETF	411.87	411.87	411.25	411.25	136319.0
2023-04-20 08:00:00	SPY	ETF	411.62	413.48	410.87	411.32	322968.0
2023-04-20 08:30:00	SPY	ETF	411.4	411.68	411.04	411.54	243600.0
2023-04-20 09:00:00	SPY	ETF	411.59	411.62	411.1	411.21	241807.0
2023-04-20 09:30:00	SPY	ETF	411.21	412.32	411.08	411.66	6751728.0
2023-04-20 10:00:00	SPY	ETF	411.65	412.51	411.36	412.24	4271859.0
2023-04-20 10:30:00	SPY	ETF	412.23	412.87	412.18	412.7199	2941753.0
2023-04-20 11:00:00	SPY	ETF	412.72	412.84	411.89	412.22	2746731.0
2023-04-20 11:30:00	SPY	ETF	412.21	412.61	411.81	412.3178	2443606.0
2023-04-20 12:00:00	SPY	ETF	412.315	412.69	411.83	412.64	1907341.0
2023-04-20 12:30:00	SPY	ETF	412.64	413.32	412.545	413.24	2678736.0
2023-04-20 13:00:00	SPY	ETF	413.26	413.6	413.1	413.52	2867921.0
2023-04-20 13:30:00	SPY	ETF	413.53	413.7	413.125	413.23	2761368.0
2023-04-20 14:00:00	SPY	ETF	413.22	413.25	412.38	412.4399	3915046.0
2023-04-20 14:30:00	SPY	ETF	412.43	412.47	411.14	411.6301	5474268.0
2023-04-20 15:00:00	SPY	ETF	411.64	411.85	410.27	410.36	6769507.0
2023-04-20 15:30:00	SPY	ETF	410.37	411.95	410.365	411.88	10757912.0
2023-04-20 16:00:00	SPY	ETF	411.87	412.36	411.79	412.05	2841872.0
2023-04-20 16:30:00	SPY	ETF	412.03	412.07	411.9	411.93	403256.0
2023-04-20 17:00:00	SPY	ETF	411.97	412.03	411.88	411.92	38015.0
2023-04-20 17:30:00	SPY	ETF	411.93	411.93	411.81	411.86	21008.0
2023-04-20 18:00:00	SPY	ETF	411.86	411.93	411.71	411.88	38380.0
2023-04-20 18:30:00	SPY	ETF	411.8399	411.8399	411.75	411.8	4800.0
2023-04-20 19:00:00	SPY	ETF	411.98	412.01	411.85	411.88	24479.0
2023-04-20 19:30:00	SPY	ETF	411.93	411.93	411.62	411.75	36659.0
2023-04-20 04:00:00	QQQ	ETF	317.0	317.0	315.7	315.84	47272.0
2023-04-20 04:30:00	QQQ	ETF	315.7	315.83	315.07	315.29	35984.0
2023-04-20 05:00:00	QQQ	ETF	315.26	315.56	315.16	315.49	26816.0
2023-04-20 05:30:00	QQQ	ETF	315.47	315.64	315.47	315.59	14255.0
2023-04-20 06:00:00	QQQ	ETF	315.59	315.72	315.51	315.54	16080.0
2023-04-20 06:30:00	QQQ	ETF	315.51	316.05	315.51	316.03	29550.0
2023-04-20 07:00:00	QQQ	ETF	316.0	316.19	315.85	316.09	111240.0
2023-04-20 07:30:00	QQQ	ETF	316.04	316.04	315.62	315.63	85250.0
2023-04-20 08:00:00	QQQ	ETF	316.12	318.949	315.27	315.75	333003.0
2023-04-20 08:30:00	QQQ	ETF	315.9	316.28	315.68	316.1	244071.0
2023-04-20 09:00:00	QQQ	ETF	316.11	316.17	315.66	315.66	232340.0
2023-04-20 09:30:00	QQQ	ETF	315.69	317.48	315.57	317.26	5289281.0
2023-04-20 10:00:00	QQQ	ETF	317.25	318.12	317.06	317.67	3014451.0
2023-04-20 10:30:00	QQQ	ETF	317.68	318.23	317.31	317.57	2601041.0
2023-04-20 11:00:00	QQQ	ETF	317.59	317.6516	316.68	317.43	2411437.0
2023-04-20 11:30:00	QQQ	ETF	317.43	318.08	316.99	317.755	1860849.0
2023-04-20 12:00:00	QQQ	ETF	317.77	318.02	317.19	317.968	1570896.0
2023-04-20 12:30:00	QQQ	ETF	317.9699	318.7	317.846	318.651	2100765.0

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

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