PREVIEW / etf_30min / 2022-01-14

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-14.parquet
  size:    667 KB
  rows:    26,207

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-01-14 04:00:00	SPY	ETF	464.87	465.6	464.83	465.39	10845.0
2022-01-14 04:30:00	SPY	ETF	465.48	465.95	465.27	465.32	19302.0
2022-01-14 05:00:00	SPY	ETF	465.4	465.43	464.92	464.95	4728.0
2022-01-14 05:30:00	SPY	ETF	464.83	465.33	464.53	465.12	4538.0
2022-01-14 06:00:00	SPY	ETF	465.2	465.43	465.0	465.1	26673.0
2022-01-14 06:30:00	SPY	ETF	465.13	465.13	464.34	464.58	54444.0
2022-01-14 07:00:00	SPY	ETF	464.47	464.47	463.29	463.3	191658.0
2022-01-14 07:30:00	SPY	ETF	463.32	463.56	461.1	461.1	236532.0
2022-01-14 08:00:00	SPY	ETF	461.1	465.5296	460.59	461.67	664149.0
2022-01-14 08:30:00	SPY	ETF	461.6201	461.81	459.98	460.68	724144.0
2022-01-14 09:00:00	SPY	ETF	460.67	461.6	460.26	461.15	888449.0
2022-01-14 09:30:00	SPY	ETF	461.19	464.5	460.73	464.4	10172468.0
2022-01-14 10:00:00	SPY	ETF	464.38	464.86	462.66	463.06	5955837.0
2022-01-14 10:30:00	SPY	ETF	463.1	463.3	461.8	462.6	4950585.0
2022-01-14 11:00:00	SPY	ETF	462.61	463.41	460.71	461.45	5135106.0
2022-01-14 11:30:00	SPY	ETF	461.46	463.3549	461.08	462.94	4103254.0
2022-01-14 12:00:00	SPY	ETF	462.95	463.29	461.78	462.33	2573010.0
2022-01-14 12:30:00	SPY	ETF	462.28	462.9	460.53	460.64	3198524.0
2022-01-14 13:00:00	SPY	ETF	460.64	461.16	459.9	460.45	4252825.0
2022-01-14 13:30:00	SPY	ETF	460.42	462.16	459.99	461.975	3490265.0
2022-01-14 14:00:00	SPY	ETF	461.97	462.62	461.46	461.51	3621388.0
2022-01-14 14:30:00	SPY	ETF	461.49	463.14	461.43	462.24	3745681.0
2022-01-14 15:00:00	SPY	ETF	462.238	464.25	462.238	463.68	4832434.0
2022-01-14 15:30:00	SPY	ETF	463.67	465.09	463.67	464.69	13279326.0
2022-01-14 16:00:00	SPY	ETF	464.67	465.5	464.62	465.49	4147622.0
2022-01-14 16:30:00	SPY	ETF	465.49	465.72	465.44	465.67	186119.0
2022-01-14 17:00:00	SPY	ETF	465.69	465.69	465.35	465.42	34131.0
2022-01-14 17:30:00	SPY	ETF	465.43	465.45	465.4	465.45	20408.0
2022-01-14 18:00:00	SPY	ETF	465.46	465.47	465.3	465.3	19423.0
2022-01-14 18:30:00	SPY	ETF	465.33	465.38	465.3	465.3	3088.0
2022-01-14 19:00:00	SPY	ETF	465.38	465.42	465.3	465.35	6011.0
2022-01-14 19:30:00	SPY	ETF	465.3	465.42	465.26	465.31	19290.0
2022-01-14 04:00:00	QQQ	ETF	377.66	378.43	377.36	378.16	96192.0
2022-01-14 04:30:00	QQQ	ETF	378.14	378.58	377.98	378.19	39106.0
2022-01-14 05:00:00	QQQ	ETF	378.11	378.15	377.22	377.33	46808.0
2022-01-14 05:30:00	QQQ	ETF	377.17	377.81	376.91	377.63	29341.0
2022-01-14 06:00:00	QQQ	ETF	377.7	377.92	377.26	377.4	16362.0
2022-01-14 06:30:00	QQQ	ETF	377.32	377.34	376.7	377.1	90067.0
2022-01-14 07:00:00	QQQ	ETF	377.04	377.2	376.02	376.13	188621.0
2022-01-14 07:30:00	QQQ	ETF	376.11	376.45	373.41	373.41	448909.0
2022-01-14 08:00:00	QQQ	ETF	373.5	378.6	373.23	374.57	515056.0
2022-01-14 08:30:00	QQQ	ETF	374.72	375.16	373.46	374.22	450324.0
2022-01-14 09:00:00	QQQ	ETF	374.24	375.31	373.92	374.94	776528.0
2022-01-14 09:30:00	QQQ	ETF	375.07	380.08	374.86	379.73	9701430.0
2022-01-14 10:00:00	QQQ	ETF	379.71	380.21	377.4	378.1301	7111678.0
2022-01-14 10:30:00	QQQ	ETF	378.1301	378.17	376.71	377.67	5274435.0
2022-01-14 11:00:00	QQQ	ETF	377.69	378.74	375.76	377.06	6019562.0
2022-01-14 11:30:00	QQQ	ETF	377.04	379.51	376.73	378.79	5449519.0
2022-01-14 12:00:00	QQQ	ETF	378.82	379.13	377.42	378.11	2382739.0
2022-01-14 12:30:00	QQQ	ETF	378.06	378.569	376.13	376.2695	2497664.0

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

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