PREVIEW / etf_30min / 2021-03-05

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-05.parquet
  size:    656 KB
  rows:    25,081

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-03-05 04:00:00	SPY	ETF	375.16	375.66	374.44	374.58	42251.0
2021-03-05 04:30:00	SPY	ETF	374.62	375.07	374.34	375.07	25638.0
2021-03-05 05:00:00	SPY	ETF	375.06	375.48	374.84	375.36	15775.0
2021-03-05 05:30:00	SPY	ETF	375.35	376.1	375.16	375.9	61520.0
2021-03-05 06:00:00	SPY	ETF	375.76	376.6	375.76	376.6	132648.0
2021-03-05 06:30:00	SPY	ETF	376.58	377.4	376.52	376.8	127251.0
2021-03-05 07:00:00	SPY	ETF	376.72	377.34	376.48	377.34	165398.0
2021-03-05 07:30:00	SPY	ETF	377.33	377.86	376.94	377.64	174265.0
2021-03-05 08:00:00	SPY	ETF	377.1701	378.03	374.02	377.81	487606.0
2021-03-05 08:30:00	SPY	ETF	377.87	379.48	375.4	379.05	2164126.0
2021-03-05 09:00:00	SPY	ETF	378.91	381.21	378.91	380.43	1135524.0
2021-03-05 09:30:00	SPY	ETF	380.42	380.59	375.79	377.34	12438486.0
2021-03-05 10:00:00	SPY	ETF	377.33	379.23	376.04	376.08	10974717.0
2021-03-05 10:30:00	SPY	ETF	376.08	376.95	374.93	375.39	10009221.0
2021-03-05 11:00:00	SPY	ETF	375.381	376.3	372.64	373.0699	9366849.0
2021-03-05 11:30:00	SPY	ETF	373.0698	376.07	373.06	375.86	7141564.0
2021-03-05 12:00:00	SPY	ETF	375.84	378.218	375.44	378.0211	4838985.0
2021-03-05 12:30:00	SPY	ETF	378.03	379.53	377.52	379.14	5916281.0
2021-03-05 13:00:00	SPY	ETF	379.11	380.98	377.89	380.815	5981714.0
2021-03-05 13:30:00	SPY	ETF	380.835	381.88	380.34	381.34	5475746.0
2021-03-05 14:00:00	SPY	ETF	381.36	381.795	379.92	381.66	4382003.0
2021-03-05 14:30:00	SPY	ETF	381.6699	383.23	381.6699	383.0946	5038993.0
2021-03-05 15:00:00	SPY	ETF	383.0919	383.68	382.5048	383.28	6107991.0
2021-03-05 15:30:00	SPY	ETF	383.28	384.76	382.97	383.595	16432770.0
2021-03-05 16:00:00	SPY	ETF	383.61	384.07	383.44	383.57	7716320.0
2021-03-05 16:30:00	SPY	ETF	383.57	383.82	383.39	383.82	560651.0
2021-03-05 17:00:00	SPY	ETF	383.75	383.99	383.6	383.88	147793.0
2021-03-05 17:30:00	SPY	ETF	383.88	384.0	383.65	383.88	77578.0
2021-03-05 18:00:00	SPY	ETF	383.89	383.92	383.82	383.85	28347.0
2021-03-05 18:30:00	SPY	ETF	383.63	383.85	383.63	383.85	5064.0
2021-03-05 19:00:00	SPY	ETF	383.81	383.92	383.8	383.83	19664.0
2021-03-05 19:30:00	SPY	ETF	383.92	384.03	383.83	383.95	22213.0
2021-03-05 04:00:00	QQQ	ETF	302.66	303.33	302.03	302.07	55406.0
2021-03-05 04:30:00	QQQ	ETF	302.02	302.45	301.89	302.01	28879.0
2021-03-05 05:00:00	QQQ	ETF	302.03	302.7	301.64	302.31	50488.0
2021-03-05 05:30:00	QQQ	ETF	302.27	303.06	302.1	302.77	24848.0
2021-03-05 06:00:00	QQQ	ETF	302.61	303.63	302.61	303.5	58087.0
2021-03-05 06:30:00	QQQ	ETF	303.62	304.31	303.43	303.6	130874.0
2021-03-05 07:00:00	QQQ	ETF	303.53	304.4	303.2	304.4	188564.0
2021-03-05 07:30:00	QQQ	ETF	304.41	304.97	304.06	304.66	196769.0
2021-03-05 08:00:00	QQQ	ETF	304.67	305.14	301.5	304.91	639256.0
2021-03-05 08:30:00	QQQ	ETF	304.99	305.57	301.7	304.81	2314727.0
2021-03-05 09:00:00	QQQ	ETF	304.8	307.98	304.7	306.8	1547099.0
2021-03-05 09:30:00	QQQ	ETF	306.79	307.38	301.35	302.94	13063327.0
2021-03-05 10:00:00	QQQ	ETF	302.94	304.62	301.04	301.28	10744603.0
2021-03-05 10:30:00	QQQ	ETF	301.28	302.73	300.36	300.89	7050517.0
2021-03-05 11:00:00	QQQ	ETF	300.9002	301.5894	297.45	298.25	7909525.0
2021-03-05 11:30:00	QQQ	ETF	298.31	301.54	298.26	301.34	7920705.0
2021-03-05 12:00:00	QQQ	ETF	301.34	303.85	300.27	303.6	5912763.0
2021-03-05 12:30:00	QQQ	ETF	303.62	305.55	302.88	305.35	5218080.0

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

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