PREVIEW / etf_30min / 2021-09-23

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-23.parquet
  size:    622 KB
  rows:    23,789

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-09-23 04:00:00	SPY	ETF	439.02	440.89	439.02	440.84	29053.0
2021-09-23 04:30:00	SPY	ETF	440.83	441.02	440.83	440.96	16368.0
2021-09-23 05:00:00	SPY	ETF	441.01	441.87	440.81	441.23	69901.0
2021-09-23 05:30:00	SPY	ETF	441.37	441.4	440.87	441.0	27249.0
2021-09-23 06:00:00	SPY	ETF	441.0	441.15	439.49	440.4	180904.0
2021-09-23 06:30:00	SPY	ETF	440.41	440.46	439.65	440.18	91526.0
2021-09-23 07:00:00	SPY	ETF	440.15	440.36	439.87	440.14	96256.0
2021-09-23 07:30:00	SPY	ETF	440.13	440.73	439.9	440.18	117328.0
2021-09-23 08:00:00	SPY	ETF	440.18	440.63	438.98	440.49	187146.0
2021-09-23 08:30:00	SPY	ETF	440.52	440.75	439.92	439.94	293559.0
2021-09-23 09:00:00	SPY	ETF	439.97	440.12	438.96	439.83	543531.0
2021-09-23 09:30:00	SPY	ETF	439.84	442.82	439.6	442.2	9647787.0
2021-09-23 10:00:00	SPY	ETF	442.21	443.64	442.21	443.28	6197872.0
2021-09-23 10:30:00	SPY	ETF	443.27	443.92	442.84	443.7001	4161443.0
2021-09-23 11:00:00	SPY	ETF	443.7001	443.72	442.81	443.36	3288503.0
2021-09-23 11:30:00	SPY	ETF	443.36	443.77	443.14	443.7301	2878614.0
2021-09-23 12:00:00	SPY	ETF	443.74	443.77	443.28	443.71	2500930.0
2021-09-23 12:30:00	SPY	ETF	443.695	444.13	443.66	443.75	3022838.0
2021-09-23 13:00:00	SPY	ETF	443.74	444.47	443.73	444.4101	2300720.0
2021-09-23 13:30:00	SPY	ETF	444.41	444.89	444.41	444.855	2494595.0
2021-09-23 14:00:00	SPY	ETF	444.861	444.87	444.24	444.29	2579867.0
2021-09-23 14:30:00	SPY	ETF	444.3	444.6	443.925	444.2	2623958.0
2021-09-23 15:00:00	SPY	ETF	444.2	444.27	443.6	443.74	3914808.0
2021-09-23 15:30:00	SPY	ETF	443.76	444.0	443.03	443.08	10971407.0
2021-09-23 16:00:00	SPY	ETF	443.14	443.65	442.94	443.18	3350075.0
2021-09-23 16:30:00	SPY	ETF	443.18	443.44	443.07	443.3	198199.0
2021-09-23 17:00:00	SPY	ETF	443.28	443.42	443.15	443.42	72614.0
2021-09-23 17:30:00	SPY	ETF	443.43	443.43	443.3	443.3	39758.0
2021-09-23 18:00:00	SPY	ETF	443.31	443.64	443.3	443.49	56061.0
2021-09-23 18:30:00	SPY	ETF	443.18	443.65	443.18	443.58	21078.0
2021-09-23 19:00:00	SPY	ETF	443.65	443.78	443.6	443.7	23250.0
2021-09-23 19:30:00	SPY	ETF	443.61	443.78	443.4	443.52	41517.0
2021-09-23 04:00:00	QQQ	ETF	371.47	372.15	371.47	372.02	25431.0
2021-09-23 04:30:00	QQQ	ETF	372.01	372.26	371.97	372.26	19159.0
2021-09-23 05:00:00	QQQ	ETF	372.26	373.0	372.15	372.62	51778.0
2021-09-23 05:30:00	QQQ	ETF	372.64	372.64	372.34	372.41	32374.0
2021-09-23 06:00:00	QQQ	ETF	372.46	372.6	371.29	372.01	100953.0
2021-09-23 06:30:00	QQQ	ETF	371.95	371.99	371.28	371.71	74819.0
2021-09-23 07:00:00	QQQ	ETF	371.74	371.84	371.51	371.68	47606.0
2021-09-23 07:30:00	QQQ	ETF	371.65	372.0	371.25	371.47	155283.0
2021-09-23 08:00:00	QQQ	ETF	371.49	372.4404	370.07	371.7	142460.0
2021-09-23 08:30:00	QQQ	ETF	371.73	371.89	370.66	370.7296	268989.0
2021-09-23 09:00:00	QQQ	ETF	370.66	370.8	369.94	370.72	354639.0
2021-09-23 09:30:00	QQQ	ETF	370.76	372.83	370.099	372.32	5683126.0
2021-09-23 10:00:00	QQQ	ETF	372.3567	373.83	372.35	373.46	3678473.0
2021-09-23 10:30:00	QQQ	ETF	373.45	373.78	372.91	373.53	2262376.0
2021-09-23 11:00:00	QQQ	ETF	373.5299	373.55	372.08	372.73	2795401.0
2021-09-23 11:30:00	QQQ	ETF	372.75	373.28	372.33	373.23	2016599.0
2021-09-23 12:00:00	QQQ	ETF	373.24	373.255	372.35	372.79	1869738.0
2021-09-23 12:30:00	QQQ	ETF	372.78	373.32	372.77	372.919	1381573.0

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

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