PREVIEW / etf_30min / 2021-03-24

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-24.parquet
  size:    619 KB
  rows:    23,793

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-24 04:00:00	SPY	ETF	389.5	390.4	389.25	390.4	13867.0
2021-03-24 04:30:00	SPY	ETF	390.41	391.08	390.29	390.88	21392.0
2021-03-24 05:00:00	SPY	ETF	390.88	391.24	390.85	390.98	20680.0
2021-03-24 05:30:00	SPY	ETF	390.9	390.97	390.78	390.97	2700.0
2021-03-24 06:00:00	SPY	ETF	391.02	391.05	390.8	390.95	95287.0
2021-03-24 06:30:00	SPY	ETF	390.97	391.07	390.55	390.79	171700.0
2021-03-24 07:00:00	SPY	ETF	390.82	391.46	390.8	391.2	175652.0
2021-03-24 07:30:00	SPY	ETF	391.22	391.25	390.66	390.75	84830.0
2021-03-24 08:00:00	SPY	ETF	390.77	391.45	390.62	391.17	215006.0
2021-03-24 08:30:00	SPY	ETF	391.19	391.36	390.81	390.96	121692.0
2021-03-24 09:00:00	SPY	ETF	390.94	391.06	390.63	390.97	237242.0
2021-03-24 09:30:00	SPY	ETF	391.0	392.0	390.61	390.71	7209417.0
2021-03-24 10:00:00	SPY	ETF	390.7	391.66	390.27	390.86	5777092.0
2021-03-24 10:30:00	SPY	ETF	390.88	392.38	390.52	392.23	4793548.0
2021-03-24 11:00:00	SPY	ETF	392.24	392.75	391.91	392.12	4479785.0
2021-03-24 11:30:00	SPY	ETF	392.12	392.28	391.18	391.465	3939063.0
2021-03-24 12:00:00	SPY	ETF	391.47	392.25	391.43	392.173	2893109.0
2021-03-24 12:30:00	SPY	ETF	392.18	392.309	391.295	391.35	2877045.0
2021-03-24 13:00:00	SPY	ETF	391.36	391.36	389.99	390.767	4481400.0
2021-03-24 13:30:00	SPY	ETF	390.76	391.32	389.92	391.29	3304184.0
2021-03-24 14:00:00	SPY	ETF	391.295	391.42	390.35	390.43	3268816.0
2021-03-24 14:30:00	SPY	ETF	390.42	390.585	389.5	389.59	5446587.0
2021-03-24 15:00:00	SPY	ETF	389.6	390.185	389.29	389.38	4732401.0
2021-03-24 15:30:00	SPY	ETF	389.39	389.51	387.48	387.48	15375577.0
2021-03-24 16:00:00	SPY	ETF	387.48	387.93	387.33	387.77	4917911.0
2021-03-24 16:30:00	SPY	ETF	387.8	387.9	387.52	387.81	154477.0
2021-03-24 17:00:00	SPY	ETF	387.8	387.87	387.52	387.77	55839.0
2021-03-24 17:30:00	SPY	ETF	387.73	387.83	387.52	387.82	150031.0
2021-03-24 18:00:00	SPY	ETF	387.82	388.13	387.52	387.96	169917.0
2021-03-24 18:30:00	SPY	ETF	387.52	388.15	387.52	388.03	29733.0
2021-03-24 19:00:00	SPY	ETF	387.96	388.17	387.9	388.13	17155.0
2021-03-24 19:30:00	SPY	ETF	388.05	388.29	387.8	388.11	46075.0
2021-03-24 04:00:00	QQQ	ETF	317.96	319.41	317.84	319.28	31863.0
2021-03-24 04:30:00	QQQ	ETF	319.33	320.25	319.33	320.04	30730.0
2021-03-24 05:00:00	QQQ	ETF	320.02	320.4	319.63	319.63	46951.0
2021-03-24 05:30:00	QQQ	ETF	319.66	320.04	319.61	319.88	25583.0
2021-03-24 06:00:00	QQQ	ETF	319.85	319.96	319.34	319.53	52940.0
2021-03-24 06:30:00	QQQ	ETF	319.5	319.72	319.1	319.38	20525.0
2021-03-24 07:00:00	QQQ	ETF	319.4	319.71	319.24	319.56	74606.0
2021-03-24 07:30:00	QQQ	ETF	319.6	319.63	318.99	319.17	67613.0
2021-03-24 08:00:00	QQQ	ETF	319.52	319.68	317.53	319.2	146352.0
2021-03-24 08:30:00	QQQ	ETF	319.2	319.49	318.94	318.96	173329.0
2021-03-24 09:00:00	QQQ	ETF	318.95	319.01	318.58	318.67	116332.0
2021-03-24 09:30:00	QQQ	ETF	318.66	318.67	315.6	315.86	6173190.0
2021-03-24 10:00:00	QQQ	ETF	315.84	316.63	314.76	315.57	5116423.0
2021-03-24 10:30:00	QQQ	ETF	315.59	317.22	315.09	317.0	3351452.0
2021-03-24 11:00:00	QQQ	ETF	317.0	318.09	317.0	317.62	3504462.0
2021-03-24 11:30:00	QQQ	ETF	317.62	317.7	315.68	316.04	3307176.0
2021-03-24 12:00:00	QQQ	ETF	316.03	316.59	315.72	316.41	1944326.0
2021-03-24 12:30:00	QQQ	ETF	316.41	316.46	315.27	315.32	2081922.0

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

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