PREVIEW / etf_30min / 2021-03-30

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-30.parquet
  size:    604 KB
  rows:    23,019

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-30 04:00:00	SPY	ETF	395.5	395.62	395.1	395.27	5900.0
2021-03-30 04:30:00	SPY	ETF	395.33	395.47	395.24	395.31	3920.0
2021-03-30 05:00:00	SPY	ETF	395.26	395.6	395.18	395.6	4000.0
2021-03-30 05:30:00	SPY	ETF	395.55	395.59	395.36	395.59	14352.0
2021-03-30 06:00:00	SPY	ETF	395.58	395.78	395.58	395.64	4793.0
2021-03-30 06:30:00	SPY	ETF	395.64	395.66	394.91	395.03	136342.0
2021-03-30 07:00:00	SPY	ETF	395.04	395.04	394.08	394.5	126639.0
2021-03-30 07:30:00	SPY	ETF	394.44	394.48	393.98	394.15	76780.0
2021-03-30 08:00:00	SPY	ETF	394.7201	396.769	393.9996	394.37	125097.0
2021-03-30 08:30:00	SPY	ETF	394.33	394.37	393.93	394.23	186698.0
2021-03-30 09:00:00	SPY	ETF	394.2	394.7	394.13	394.4	223322.0
2021-03-30 09:30:00	SPY	ETF	394.4	394.73	393.43	394.09	6791938.0
2021-03-30 10:00:00	SPY	ETF	394.09	394.37	393.02	394.3081	5977526.0
2021-03-30 10:30:00	SPY	ETF	394.31	394.84	394.11	394.27	4625599.0
2021-03-30 11:00:00	SPY	ETF	394.265	394.85	394.19	394.47	3521188.0
2021-03-30 11:30:00	SPY	ETF	394.47	394.94	393.94	394.04	3008944.0
2021-03-30 12:00:00	SPY	ETF	394.03	394.3	393.48	393.95	2410806.0
2021-03-30 12:30:00	SPY	ETF	393.94	394.28	393.64	393.96	2133608.0
2021-03-30 13:00:00	SPY	ETF	393.97	394.33	393.4	394.18	1898969.0
2021-03-30 13:30:00	SPY	ETF	394.18	394.35	393.88	394.0	1961349.0
2021-03-30 14:00:00	SPY	ETF	394.0	394.47	393.69	394.27	2513922.0
2021-03-30 14:30:00	SPY	ETF	394.26	395.2	394.1	395.1214	3094064.0
2021-03-30 15:00:00	SPY	ETF	395.12	395.45	394.8	395.08	3734392.0
2021-03-30 15:30:00	SPY	ETF	395.0811	395.37	393.42	394.78	12509520.0
2021-03-30 16:00:00	SPY	ETF	394.77	394.86	394.37	394.55	4134592.0
2021-03-30 16:30:00	SPY	ETF	394.57	394.6	394.43	394.5	93775.0
2021-03-30 17:00:00	SPY	ETF	394.52	394.53	394.35	394.35	65152.0
2021-03-30 17:30:00	SPY	ETF	394.45	394.45	394.41	394.45	31374.0
2021-03-30 18:00:00	SPY	ETF	394.45	394.49	393.89	394.24	113042.0
2021-03-30 18:30:00	SPY	ETF	394.73	394.73	394.0	394.12	11599.0
2021-03-30 19:00:00	SPY	ETF	394.08	394.61	393.95	394.59	35155.0
2021-03-30 19:30:00	SPY	ETF	394.58	394.8	394.52	394.63	23092.0
2021-03-30 04:00:00	QQQ	ETF	314.4	314.4	313.49	313.8	47863.0
2021-03-30 04:30:00	QQQ	ETF	313.81	314.0	313.66	313.9	11835.0
2021-03-30 05:00:00	QQQ	ETF	313.85	314.47	313.79	314.37	20892.0
2021-03-30 05:30:00	QQQ	ETF	314.4	314.56	314.16	314.43	15083.0
2021-03-30 06:00:00	QQQ	ETF	314.36	314.59	314.28	314.39	20727.0
2021-03-30 06:30:00	QQQ	ETF	314.41	314.43	313.26	313.69	59031.0
2021-03-30 07:00:00	QQQ	ETF	313.84	313.85	313.08	313.63	172487.0
2021-03-30 07:30:00	QQQ	ETF	313.61	313.71	313.16	313.25	87104.0
2021-03-30 08:00:00	QQQ	ETF	313.27	315.48	312.99	313.61	182728.0
2021-03-30 08:30:00	QQQ	ETF	313.56	313.63	313.14	313.6	120508.0
2021-03-30 09:00:00	QQQ	ETF	313.61	314.17	313.49	313.94	135988.0
2021-03-30 09:30:00	QQQ	ETF	313.87	314.23	312.22	312.89	5671452.0
2021-03-30 10:00:00	QQQ	ETF	312.87	313.37	311.54	312.6518	4242206.0
2021-03-30 10:30:00	QQQ	ETF	312.66	313.91	312.415	313.56	3331092.0
2021-03-30 11:00:00	QQQ	ETF	313.56	314.2	313.14	313.91	2617229.0
2021-03-30 11:30:00	QQQ	ETF	313.915	314.91	313.38	313.53	2521075.0
2021-03-30 12:00:00	QQQ	ETF	313.52	313.76	312.86	313.4999	1543237.0
2021-03-30 12:30:00	QQQ	ETF	313.5	313.84	313.04	313.29	1081002.0

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

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