PREVIEW / etf_30min / 2023-04-13

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-13.parquet
  size:    702 KB
  rows:    27,584

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-13 04:00:00	SPY	ETF	409.0	409.31	408.61	408.68	35556.0
2023-04-13 04:30:00	SPY	ETF	408.7	408.86	408.54	408.54	8010.0
2023-04-13 05:00:00	SPY	ETF	408.6	409.36	408.54	409.2	17098.0
2023-04-13 05:30:00	SPY	ETF	409.21	409.23	408.85	409.02	14053.0
2023-04-13 06:00:00	SPY	ETF	408.95	408.95	408.33	408.35	18165.0
2023-04-13 06:30:00	SPY	ETF	408.37	408.57	408.37	408.52	13172.0
2023-04-13 07:00:00	SPY	ETF	408.5	408.79	408.42	408.53	54537.0
2023-04-13 07:30:00	SPY	ETF	408.56	408.78	408.08	408.22	63978.0
2023-04-13 08:00:00	SPY	ETF	408.512	409.2	408.02	408.59	103502.0
2023-04-13 08:30:00	SPY	ETF	408.56	409.94	408.05	409.55	516037.0
2023-04-13 09:00:00	SPY	ETF	409.55	409.75	409.11	409.24	294453.0
2023-04-13 09:30:00	SPY	ETF	409.24	409.53	408.7007	409.1398	5893053.0
2023-04-13 10:00:00	SPY	ETF	409.13	410.85	408.95	410.72	5792225.0
2023-04-13 10:30:00	SPY	ETF	410.74	410.88	410.1	410.26	4192761.0
2023-04-13 11:00:00	SPY	ETF	410.255	410.83	410.255	410.79	2666522.0
2023-04-13 11:30:00	SPY	ETF	410.79	411.08	410.34	410.95	2878969.0
2023-04-13 12:00:00	SPY	ETF	410.95	411.5	410.95	411.41	2757171.0
2023-04-13 12:30:00	SPY	ETF	411.41	411.56	411.14	411.49	2127831.0
2023-04-13 13:00:00	SPY	ETF	411.49	412.12	411.095	411.9025	3265693.0
2023-04-13 13:30:00	SPY	ETF	411.91	412.78	411.7709	412.67	3228770.0
2023-04-13 14:00:00	SPY	ETF	412.68	413.44	412.55	413.1375	4099944.0
2023-04-13 14:30:00	SPY	ETF	413.13	413.6599	412.94	413.555	4244321.0
2023-04-13 15:00:00	SPY	ETF	413.56	413.7899	413.24	413.585	4625202.0
2023-04-13 15:30:00	SPY	ETF	413.59	413.84	413.13	413.445	11800608.0
2023-04-13 16:00:00	SPY	ETF	413.45	413.47	413.21	413.4	3325763.0
2023-04-13 16:30:00	SPY	ETF	413.4	413.47	412.96	413.0	252502.0
2023-04-13 17:00:00	SPY	ETF	413.08	413.24	413.0	413.14	50790.0
2023-04-13 17:30:00	SPY	ETF	413.13	413.17	412.94	412.95	55062.0
2023-04-13 18:00:00	SPY	ETF	412.93	413.19	412.88	413.18	79631.0
2023-04-13 18:30:00	SPY	ETF	413.2	413.35	413.09	413.24	23397.0
2023-04-13 19:00:00	SPY	ETF	413.26	413.34	413.1	413.11	27775.0
2023-04-13 19:30:00	SPY	ETF	413.14	413.2	413.01	413.15	34038.0
2023-04-13 04:00:00	QQQ	ETF	313.86	314.16	313.5	313.62	66241.0
2023-04-13 04:30:00	QQQ	ETF	313.66	313.67	313.39	313.44	15353.0
2023-04-13 05:00:00	QQQ	ETF	313.6	314.6	313.52	314.31	26467.0
2023-04-13 05:30:00	QQQ	ETF	314.34	314.34	313.96	314.11	15783.0
2023-04-13 06:00:00	QQQ	ETF	314.07	314.07	313.57	313.64	20463.0
2023-04-13 06:30:00	QQQ	ETF	313.75	313.82	313.57	313.7	6062.0
2023-04-13 07:00:00	QQQ	ETF	313.74	314.15	313.61	313.89	52984.0
2023-04-13 07:30:00	QQQ	ETF	313.91	314.1	313.28	313.38	77056.0
2023-04-13 08:00:00	QQQ	ETF	313.67	314.6196	313.15	313.74	217851.0
2023-04-13 08:30:00	QQQ	ETF	313.58	315.1	313.55	314.78	1020611.0
2023-04-13 09:00:00	QQQ	ETF	314.75	315.02	314.26	314.82	365140.0
2023-04-13 09:30:00	QQQ	ETF	314.82	316.13	314.64	315.79	6272428.0
2023-04-13 10:00:00	QQQ	ETF	315.78	317.48	315.5	317.245	4801730.0
2023-04-13 10:30:00	QQQ	ETF	317.27	317.4	316.6209	316.7893	2621147.0
2023-04-13 11:00:00	QQQ	ETF	316.79	317.54	316.79	317.27	1934413.0
2023-04-13 11:30:00	QQQ	ETF	317.27	317.618	316.8	317.52	1632618.0
2023-04-13 12:00:00	QQQ	ETF	317.52	317.96	317.41	317.89	1809011.0
2023-04-13 12:30:00	QQQ	ETF	317.88	317.9592	317.48	317.71	1150916.0

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

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