PREVIEW / etf_30min / 2022-04-14

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-14.parquet
  size:    653 KB
  rows:    25,778

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-04-14 04:00:00	SPY	ETF	443.46	443.56	442.88	442.93	15011.0
2022-04-14 04:30:00	SPY	ETF	443.01	443.26	442.89	443.22	13400.0
2022-04-14 05:00:00	SPY	ETF	443.3	443.35	443.05	443.08	9395.0
2022-04-14 05:30:00	SPY	ETF	443.31	443.4	442.84	443.31	4117.0
2022-04-14 06:00:00	SPY	ETF	443.39	443.58	443.26	443.31	5169.0
2022-04-14 06:30:00	SPY	ETF	443.14	443.28	442.89	443.27	4696.0
2022-04-14 07:00:00	SPY	ETF	443.24	443.68	443.1	443.12	27273.0
2022-04-14 07:30:00	SPY	ETF	443.05	443.58	442.42	442.54	49248.0
2022-04-14 08:00:00	SPY	ETF	442.5199	444.64	442.4999	443.23	97221.0
2022-04-14 08:30:00	SPY	ETF	443.17	443.35	442.19	442.23	126144.0
2022-04-14 09:00:00	SPY	ETF	442.2	443.57	442.01	443.51	301386.0
2022-04-14 09:30:00	SPY	ETF	443.55	444.7301	441.67	442.1299	6837816.0
2022-04-14 10:00:00	SPY	ETF	442.18	442.95	440.51	441.31	5560028.0
2022-04-14 10:30:00	SPY	ETF	441.29	442.02	440.83	441.42	3730905.0
2022-04-14 11:00:00	SPY	ETF	441.41	442.27	441.06	442.04	3160763.0
2022-04-14 11:30:00	SPY	ETF	442.05	442.22	440.565	440.78	2642097.0
2022-04-14 12:00:00	SPY	ETF	440.775	441.2	439.97	440.0901	3053549.0
2022-04-14 12:30:00	SPY	ETF	440.09	440.29	439.47	440.08	2848211.0
2022-04-14 13:00:00	SPY	ETF	440.07	440.27	439.64	439.99	2297976.0
2022-04-14 13:30:00	SPY	ETF	439.99	441.35	439.9	441.28	2875925.0
2022-04-14 14:00:00	SPY	ETF	441.28	441.83	440.46	440.91	3314843.0
2022-04-14 14:30:00	SPY	ETF	440.92	441.13	439.33	439.34	3039453.0
2022-04-14 15:00:00	SPY	ETF	439.34	440.0	438.88	439.25	4094340.0
2022-04-14 15:30:00	SPY	ETF	439.26	439.28	437.68	437.87	14108137.0
2022-04-14 16:00:00	SPY	ETF	437.86	438.02	437.6	437.7	5992399.0
2022-04-14 16:30:00	SPY	ETF	437.73	438.05	437.68	438.02	307219.0
2022-04-14 17:00:00	SPY	ETF	438.02	438.04	437.8	438.01	90380.0
2022-04-14 17:30:00	SPY	ETF	438.01	438.4	437.79	438.4	137994.0
2022-04-14 18:00:00	SPY	ETF	438.23	438.4	438.0	438.39	46862.0
2022-04-14 18:30:00	SPY	ETF	438.4	438.42	438.2	438.2	21426.0
2022-04-14 19:00:00	SPY	ETF	438.2	438.28	438.05	438.06	21227.0
2022-04-14 19:30:00	SPY	ETF	438.12	438.12	437.64	437.82	44840.0
2022-04-14 04:00:00	QQQ	ETF	347.08	347.37	346.59	346.79	71151.0
2022-04-14 04:30:00	QQQ	ETF	346.66	346.87	346.45	346.82	24875.0
2022-04-14 05:00:00	QQQ	ETF	346.53	346.83	346.46	346.6	10930.0
2022-04-14 05:30:00	QQQ	ETF	346.6	346.85	346.28	346.7	8600.0
2022-04-14 06:00:00	QQQ	ETF	346.82	347.01	346.39	346.39	30788.0
2022-04-14 06:30:00	QQQ	ETF	346.49	346.49	345.92	346.38	51279.0
2022-04-14 07:00:00	QQQ	ETF	346.36	346.86	346.25	346.28	61801.0
2022-04-14 07:30:00	QQQ	ETF	346.26	346.81	345.65	345.85	83593.0
2022-04-14 08:00:00	QQQ	ETF	346.8583	348.01	345.65	346.36	160610.0
2022-04-14 08:30:00	QQQ	ETF	346.36	346.65	345.43	345.58	304840.0
2022-04-14 09:00:00	QQQ	ETF	345.62	346.78	345.3	346.41	588108.0
2022-04-14 09:30:00	QQQ	ETF	346.44	346.97	343.51	343.7699	7027586.0
2022-04-14 10:00:00	QQQ	ETF	343.77	344.4	341.82	342.53	5644695.0
2022-04-14 10:30:00	QQQ	ETF	342.54	343.0	341.38	342.1	3745556.0
2022-04-14 11:00:00	QQQ	ETF	342.09	343.08	341.75	342.79	3096402.0
2022-04-14 11:30:00	QQQ	ETF	342.81	342.93	341.27	341.49	2387736.0
2022-04-14 12:00:00	QQQ	ETF	341.48	341.86	340.54	340.68	2707071.0
2022-04-14 12:30:00	QQQ	ETF	340.63	340.9	340.03	340.63	2633293.0

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

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