PREVIEW / etf_30min / 2021-04-01

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-01.parquet
  size:    641 KB
  rows:    24,494

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
2021-04-01 04:00:00	SPY	ETF	397.73	397.8	396.84	397.6	14494.0
2021-04-01 04:30:00	SPY	ETF	397.6	397.93	397.51	397.92	15869.0
2021-04-01 05:00:00	SPY	ETF	397.92	398.0	397.6	397.65	18492.0
2021-04-01 05:30:00	SPY	ETF	397.7	397.88	397.68	397.71	6850.0
2021-04-01 06:00:00	SPY	ETF	397.62	397.62	397.51	397.59	13361.0
2021-04-01 06:30:00	SPY	ETF	397.47	397.53	397.29	397.31	58805.0
2021-04-01 07:00:00	SPY	ETF	397.24	397.61	397.24	397.61	42817.0
2021-04-01 07:30:00	SPY	ETF	397.58	397.95	397.54	397.89	92224.0
2021-04-01 08:00:00	SPY	ETF	397.5804	398.0	396.92	397.95	114343.0
2021-04-01 08:30:00	SPY	ETF	397.94	398.2	396.33	398.11	109325.0
2021-04-01 09:00:00	SPY	ETF	398.13	398.4	396.33	398.4	360203.0
2021-04-01 09:30:00	SPY	ETF	398.4	398.77	398.18	398.41	7502162.0
2021-04-01 10:00:00	SPY	ETF	398.41	399.22	398.24	399.21	5817137.0
2021-04-01 10:30:00	SPY	ETF	399.22	399.32	398.79	399.3081	3206776.0
2021-04-01 11:00:00	SPY	ETF	399.3	399.64	399.02	399.2168	4032462.0
2021-04-01 11:30:00	SPY	ETF	399.23	399.43	399.0619	399.1814	1975365.0
2021-04-01 12:00:00	SPY	ETF	399.175	399.78	399.14	399.745	2659443.0
2021-04-01 12:30:00	SPY	ETF	399.745	399.86	399.56	399.725	1463264.0
2021-04-01 13:00:00	SPY	ETF	399.72	399.825	399.329	399.385	2311202.0
2021-04-01 13:30:00	SPY	ETF	399.39	399.86	399.34	399.65	2207608.0
2021-04-01 14:00:00	SPY	ETF	399.65	399.96	399.6	399.86	1544628.0
2021-04-01 14:30:00	SPY	ETF	399.855	400.0	399.825	399.935	2163370.0
2021-04-01 15:00:00	SPY	ETF	399.9301	399.99	399.42	399.59	3608842.0
2021-04-01 15:30:00	SPY	ETF	399.595	400.67	399.46	400.54	9757293.0
2021-04-01 16:00:00	SPY	ETF	400.535	401.05	400.53	400.92	3041019.0
2021-04-01 16:30:00	SPY	ETF	400.95	401.08	400.61	401.0	223217.0
2021-04-01 17:00:00	SPY	ETF	401.0	401.19	400.97	401.18	130047.0
2021-04-01 17:30:00	SPY	ETF	401.18	401.18	400.84	400.95	148728.0
2021-04-01 18:00:00	SPY	ETF	400.97	401.05	400.84	400.93	74639.0
2021-04-01 18:30:00	SPY	ETF	400.61	401.08	400.61	401.05	16912.0
2021-04-01 19:00:00	SPY	ETF	401.06	401.23	401.03	401.1	13232.0
2021-04-01 19:30:00	SPY	ETF	401.1	401.24	401.08	401.16	37379.0
2021-04-01 04:00:00	QQQ	ETF	321.9	322.57	321.9	322.34	87406.0
2021-04-01 04:30:00	QQQ	ETF	322.34	322.39	321.59	322.13	44247.0
2021-04-01 05:00:00	QQQ	ETF	322.1	322.19	321.89	322.02	22881.0
2021-04-01 05:30:00	QQQ	ETF	322.05	322.47	322.04	322.14	12650.0
2021-04-01 06:00:00	QQQ	ETF	322.11	322.12	321.88	321.91	18248.0
2021-04-01 06:30:00	QQQ	ETF	321.92	322.12	321.79	321.9	30987.0
2021-04-01 07:00:00	QQQ	ETF	321.9	322.21	321.86	322.15	111456.0
2021-04-01 07:30:00	QQQ	ETF	322.08	322.5	322.041	322.24	85598.0
2021-04-01 08:00:00	QQQ	ETF	322.24	322.82	319.13	322.63	96505.0
2021-04-01 08:30:00	QQQ	ETF	322.65	322.9	322.47	322.7	165373.0
2021-04-01 09:00:00	QQQ	ETF	322.79	323.24	322.65	323.1	368473.0
2021-04-01 09:30:00	QQQ	ETF	323.07	324.26	322.81	324.0	8524303.0
2021-04-01 10:00:00	QQQ	ETF	324.03	324.6599	323.27	324.3682	3880202.0
2021-04-01 10:30:00	QQQ	ETF	324.4	324.71	323.8206	324.29	3436579.0
2021-04-01 11:00:00	QQQ	ETF	324.28	324.56	323.48	323.943	3004198.0
2021-04-01 11:30:00	QQQ	ETF	323.95	324.15	323.32	323.6	1720467.0
2021-04-01 12:00:00	QQQ	ETF	323.59	324.17	323.46	324.1306	1519828.0
2021-04-01 12:30:00	QQQ	ETF	324.15	324.24	323.625	324.1	1289227.0

> showing 50 of 24,494 rows — these rows as CSV

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