PREVIEW / etf_30min / 2021-11-10

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-10.parquet
  size:    653 KB
  rows:    25,190

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-11-10 04:00:00	SPY	ETF	466.51	466.93	466.28	466.45	7219.0
2021-11-10 04:30:00	SPY	ETF	466.41	466.93	466.4	466.85	1982.0
2021-11-10 05:00:00	SPY	ETF	466.88	466.88	466.51	466.51	2972.0
2021-11-10 05:30:00	SPY	ETF	466.47	466.47	465.89	466.21	7946.0
2021-11-10 06:00:00	SPY	ETF	466.27	466.35	465.99	466.18	10787.0
2021-11-10 06:30:00	SPY	ETF	466.28	466.29	465.69	465.83	22369.0
2021-11-10 07:00:00	SPY	ETF	465.78	466.31	465.78	466.3	65018.0
2021-11-10 07:30:00	SPY	ETF	466.25	466.42	465.9	466.28	167199.0
2021-11-10 08:00:00	SPY	ETF	465.9399	467.0	465.7404	466.48	166288.0
2021-11-10 08:30:00	SPY	ETF	466.23	466.23	465.26	465.77	497372.0
2021-11-10 09:00:00	SPY	ETF	465.79	466.06	465.55	465.55	212181.0
2021-11-10 09:30:00	SPY	ETF	465.58	467.21	465.31	467.07	4689970.0
2021-11-10 10:00:00	SPY	ETF	467.09	467.38	466.7228	466.93	2584886.0
2021-11-10 10:30:00	SPY	ETF	466.93	467.19	466.66	466.75	2041836.0
2021-11-10 11:00:00	SPY	ETF	466.75	467.3	466.65	466.73	1765895.0
2021-11-10 11:30:00	SPY	ETF	466.72	466.969	466.23	466.8199	1828388.0
2021-11-10 12:00:00	SPY	ETF	466.81	466.95	466.07	466.0704	1409676.0
2021-11-10 12:30:00	SPY	ETF	466.08	466.43	465.535	466.02	1762946.0
2021-11-10 13:00:00	SPY	ETF	466.02	466.12	464.5	465.05	5117980.0
2021-11-10 13:30:00	SPY	ETF	465.05	465.4199	463.935	464.23	3719178.0
2021-11-10 14:00:00	SPY	ETF	464.22	464.28	462.78	462.785	5590602.0
2021-11-10 14:30:00	SPY	ETF	462.8	463.41	462.04	462.751	5970802.0
2021-11-10 15:00:00	SPY	ETF	462.76	464.08	462.44	463.82	4725750.0
2021-11-10 15:30:00	SPY	ETF	463.83	464.29	463.01	463.65	9060061.0
2021-11-10 16:00:00	SPY	ETF	463.65	463.96	463.5	463.84	2230473.0
2021-11-10 16:30:00	SPY	ETF	463.83	464.05	463.82	463.99	194724.0
2021-11-10 17:00:00	SPY	ETF	463.99	464.04	463.62	463.95	25647.0
2021-11-10 17:30:00	SPY	ETF	463.95	464.05	463.91	463.95	20059.0
2021-11-10 18:00:00	SPY	ETF	463.97	464.03	463.75	463.75	45130.0
2021-11-10 18:30:00	SPY	ETF	463.81	463.81	463.37	463.69	45197.0
2021-11-10 19:00:00	SPY	ETF	463.7	464.39	463.7	464.36	68075.0
2021-11-10 19:30:00	SPY	ETF	464.34	464.48	464.07	464.31	33051.0
2021-11-10 04:00:00	QQQ	ETF	394.99	395.18	394.45	394.61	24787.0
2021-11-10 04:30:00	QQQ	ETF	394.58	394.96	394.25	394.75	21480.0
2021-11-10 05:00:00	QQQ	ETF	394.87	394.87	394.32	394.32	18290.0
2021-11-10 05:30:00	QQQ	ETF	394.34	394.34	393.3	393.7	40852.0
2021-11-10 06:00:00	QQQ	ETF	393.7	393.89	393.52	393.76	26971.0
2021-11-10 06:30:00	QQQ	ETF	393.63	393.63	392.78	393.14	43748.0
2021-11-10 07:00:00	QQQ	ETF	393.08	393.61	393.04	393.38	112757.0
2021-11-10 07:30:00	QQQ	ETF	393.36	393.55	392.98	393.25	127991.0
2021-11-10 08:00:00	QQQ	ETF	393.0725	395.85	392.9504	393.64	326906.0
2021-11-10 08:30:00	QQQ	ETF	393.5	393.52	392.02	392.59	989611.0
2021-11-10 09:00:00	QQQ	ETF	392.57	393.03	392.38	392.46	428968.0
2021-11-10 09:30:00	QQQ	ETF	392.47	394.39	391.03	394.23	7482733.0
2021-11-10 10:00:00	QQQ	ETF	394.24	395.36	393.79	394.42	3437702.0
2021-11-10 10:30:00	QQQ	ETF	394.44	394.93	394.0	394.02	2004506.0
2021-11-10 11:00:00	QQQ	ETF	394.03	394.77	393.57	393.63	1552831.0
2021-11-10 11:30:00	QQQ	ETF	393.64	393.99	392.81	393.79	1733738.0
2021-11-10 12:00:00	QQQ	ETF	393.77	393.97	392.99	393.025	1573010.0
2021-11-10 12:30:00	QQQ	ETF	393.02	393.32	392.42	393.14	2249584.0

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

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