PREVIEW / etf_30min / 2021-03-19

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-19.parquet
  size:    614 KB
  rows:    23,324

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-19 04:00:00	SPY	ETF	391.8	391.8	390.73	391.68	13758.0
2021-03-19 04:30:00	SPY	ETF	391.81	391.81	391.54	391.73	12100.0
2021-03-19 05:00:00	SPY	ETF	391.6	391.76	391.42	391.59	16700.0
2021-03-19 05:30:00	SPY	ETF	391.49	391.6	391.36	391.4	11755.0
2021-03-19 06:00:00	SPY	ETF	391.39	391.45	390.89	391.16	18404.0
2021-03-19 06:30:00	SPY	ETF	391.35	391.68	391.16	391.56	28782.0
2021-03-19 07:00:00	SPY	ETF	391.6	391.6	390.45	390.7	141809.0
2021-03-19 07:30:00	SPY	ETF	390.79	391.14	390.75	391.04	68185.0
2021-03-19 08:00:00	SPY	ETF	390.8	391.55	389.83	390.95	236206.0
2021-03-19 08:30:00	SPY	ETF	391.12	391.48	391.01	391.18	414155.0
2021-03-19 09:00:00	SPY	ETF	391.14	391.14	389.33	389.91	1466609.0
2021-03-19 09:30:00	SPY	ETF	389.89	390.2	387.4	388.53	12611942.0
2021-03-19 10:00:00	SPY	ETF	388.51	389.14	387.15	388.797	6642928.0
2021-03-19 10:30:00	SPY	ETF	388.79	389.96	387.78	389.84	6153552.0
2021-03-19 11:00:00	SPY	ETF	389.86	390.02	388.33	389.0	4396062.0
2021-03-19 11:30:00	SPY	ETF	388.99	390.88	388.76	390.52	3606748.0
2021-03-19 12:00:00	SPY	ETF	390.51	390.98	390.27	390.63	3655655.0
2021-03-19 12:30:00	SPY	ETF	390.62	391.19	390.39	391.02	2572572.0
2021-03-19 13:00:00	SPY	ETF	391.0201	391.06	390.24	390.95	2266076.0
2021-03-19 13:30:00	SPY	ETF	390.96	391.36	390.74	391.09	2921149.0
2021-03-19 14:00:00	SPY	ETF	391.1	391.38	390.18	390.8201	3126147.0
2021-03-19 14:30:00	SPY	ETF	390.83	391.5	390.66	391.46	3348439.0
2021-03-19 15:00:00	SPY	ETF	391.45	391.569	390.5	390.81	4265922.0
2021-03-19 15:30:00	SPY	ETF	390.81	391.33	389.42	389.5	12311270.0
2021-03-19 16:00:00	SPY	ETF	389.51	389.8594	389.14	389.19	7458638.0
2021-03-19 16:30:00	SPY	ETF	389.19	389.56	389.19	389.31	463325.0
2021-03-19 17:00:00	SPY	ETF	389.28	389.5	389.16	389.17	119172.0
2021-03-19 17:30:00	SPY	ETF	389.15	389.48	389.06	389.06	894532.0
2021-03-19 18:00:00	SPY	ETF	389.05	389.18	389.05	389.11	6865.0
2021-03-19 18:30:00	SPY	ETF	389.48	389.48	389.07	389.2499	17792.0
2021-03-19 19:00:00	SPY	ETF	389.15	389.19	388.95	389.11	17445.0
2021-03-19 19:30:00	SPY	ETF	389.11	389.18	389.1	389.1	31331.0
2021-03-19 04:00:00	QQQ	ETF	312.84	314.71	312.84	314.51	110466.0
2021-03-19 04:30:00	QQQ	ETF	314.54	314.85	314.2	314.37	30622.0
2021-03-19 05:00:00	QQQ	ETF	314.4	314.72	314.25	314.36	75465.0
2021-03-19 05:30:00	QQQ	ETF	314.3	314.48	314.02	314.2	33496.0
2021-03-19 06:00:00	QQQ	ETF	314.1	314.13	313.42	313.75	103669.0
2021-03-19 06:30:00	QQQ	ETF	313.7	314.06	313.41	313.98	54775.0
2021-03-19 07:00:00	QQQ	ETF	313.99	314.01	313.0	313.4	190455.0
2021-03-19 07:30:00	QQQ	ETF	313.46	314.09	313.37	313.68	81766.0
2021-03-19 08:00:00	QQQ	ETF	313.67	314.37	310.42	313.91	221928.0
2021-03-19 08:30:00	QQQ	ETF	314.03	314.2	313.5	313.6	180343.0
2021-03-19 09:00:00	QQQ	ETF	313.54	313.55	311.22	312.0	1995417.0
2021-03-19 09:30:00	QQQ	ETF	311.92	313.41	310.72	311.97	8477610.0
2021-03-19 10:00:00	QQQ	ETF	311.91	312.24	309.6601	311.9	6172168.0
2021-03-19 10:30:00	QQQ	ETF	311.89	313.58	310.87	313.345	4850106.0
2021-03-19 11:00:00	QQQ	ETF	313.36	313.81	311.52	312.5	3571919.0
2021-03-19 11:30:00	QQQ	ETF	312.48	313.9899	312.23	313.6	3174223.0
2021-03-19 12:00:00	QQQ	ETF	313.6	314.195	313.36	313.615	2064819.0
2021-03-19 12:30:00	QQQ	ETF	313.61	314.59	313.5799	314.44	2148776.0

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

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