PREVIEW / etf_30min / 2021-10-14

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-14.parquet
  size:    625 KB
  rows:    23,958

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-10-14 04:00:00	SPY	ETF	436.65	438.15	436.65	437.75	21637.0
2021-10-14 04:30:00	SPY	ETF	437.77	438.11	437.76	437.95	47145.0
2021-10-14 05:00:00	SPY	ETF	438.02	438.16	437.96	438.08	18544.0
2021-10-14 05:30:00	SPY	ETF	438.17	438.3	437.99	438.08	25510.0
2021-10-14 06:00:00	SPY	ETF	438.09	438.2	437.83	437.96	44344.0
2021-10-14 06:30:00	SPY	ETF	437.82	438.07	437.74	438.01	25012.0
2021-10-14 07:00:00	SPY	ETF	437.93	438.47	437.87	438.24	90967.0
2021-10-14 07:30:00	SPY	ETF	438.23	439.0	438.23	438.93	141714.0
2021-10-14 08:00:00	SPY	ETF	437.948	439.44	436.16	438.99	485048.0
2021-10-14 08:30:00	SPY	ETF	439.0	439.45	438.88	439.04	275300.0
2021-10-14 09:00:00	SPY	ETF	439.06	439.36	438.9	439.06	232381.0
2021-10-14 09:30:00	SPY	ETF	439.08	439.86	438.58	439.57	8081512.0
2021-10-14 10:00:00	SPY	ETF	439.58	440.9699	439.58	440.59	5137449.0
2021-10-14 10:30:00	SPY	ETF	440.6	441.24	440.33	441.21	3252760.0
2021-10-14 11:00:00	SPY	ETF	441.21	441.34	440.79	441.14	2668775.0
2021-10-14 11:30:00	SPY	ETF	441.135	441.77	441.021	441.75	2423280.0
2021-10-14 12:00:00	SPY	ETF	441.75	442.16	441.69	441.8947	2234449.0
2021-10-14 12:30:00	SPY	ETF	441.9	442.12	441.76	442.1	1865208.0
2021-10-14 13:00:00	SPY	ETF	442.11	442.25	441.59	441.71	2199827.0
2021-10-14 13:30:00	SPY	ETF	441.715	442.43	441.715	442.28	1995359.0
2021-10-14 14:00:00	SPY	ETF	442.2701	442.51	442.02	442.5	2778799.0
2021-10-14 14:30:00	SPY	ETF	442.5	442.59	442.26	442.49	2085339.0
2021-10-14 15:00:00	SPY	ETF	442.5	442.52	441.93	442.135	3707921.0
2021-10-14 15:30:00	SPY	ETF	442.135	442.66	441.64	442.47	10078341.0
2021-10-14 16:00:00	SPY	ETF	442.46	443.46	442.36	443.05	3536143.0
2021-10-14 16:30:00	SPY	ETF	443.07	443.16	442.5	443.06	399416.0
2021-10-14 17:00:00	SPY	ETF	443.08	443.09	442.95	442.97	65720.0
2021-10-14 17:30:00	SPY	ETF	443.02	443.11	442.91	442.92	38313.0
2021-10-14 18:00:00	SPY	ETF	442.91	443.12	442.86	443.09	36099.0
2021-10-14 18:30:00	SPY	ETF	442.5	443.28	442.5	443.16	20708.0
2021-10-14 19:00:00	SPY	ETF	443.19	443.35	443.14	443.25	32250.0
2021-10-14 19:30:00	SPY	ETF	443.3	443.3	443.14	443.2	24116.0
2021-10-14 04:00:00	QQQ	ETF	362.12	363.06	362.12	362.81	24266.0
2021-10-14 04:30:00	QQQ	ETF	362.84	363.1	362.74	362.96	13406.0
2021-10-14 05:00:00	QQQ	ETF	363.06	363.08	362.92	363.01	6714.0
2021-10-14 05:30:00	QQQ	ETF	363.06	363.13	362.8	362.84	22746.0
2021-10-14 06:00:00	QQQ	ETF	362.85	362.9	362.57	362.6	12766.0
2021-10-14 06:30:00	QQQ	ETF	362.52	362.82	362.52	362.59	22320.0
2021-10-14 07:00:00	QQQ	ETF	362.52	363.12	362.52	363.0	79366.0
2021-10-14 07:30:00	QQQ	ETF	362.99	363.6	362.96	363.5	126474.0
2021-10-14 08:00:00	QQQ	ETF	362.57	364.14	360.27	363.86	262848.0
2021-10-14 08:30:00	QQQ	ETF	363.9	364.3699	363.59	363.72	208743.0
2021-10-14 09:00:00	QQQ	ETF	363.75	364.05	363.46	363.7	156122.0
2021-10-14 09:30:00	QQQ	ETF	363.69	364.61	363.01	364.33	5390253.0
2021-10-14 10:00:00	QQQ	ETF	364.34	365.52	364.17	364.98	2834752.0
2021-10-14 10:30:00	QQQ	ETF	365.0	365.61	364.83	365.26	2333687.0
2021-10-14 11:00:00	QQQ	ETF	365.27	365.59	365.025	365.55	2043944.0
2021-10-14 11:30:00	QQQ	ETF	365.56	366.12	365.34	366.12	2080935.0
2021-10-14 12:00:00	QQQ	ETF	366.11	366.62	366.04	366.365	2209376.0
2021-10-14 12:30:00	QQQ	ETF	366.37	366.73	366.35	366.6	1229537.0

> showing 50 of 23,958 rows — these rows as CSV

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