PREVIEW / etf_30min / 2023-01-04

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-04.parquet
  size:    684 KB
  rows:    28,017

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
2023-01-04 04:00:00	SPY	ETF	382.5	382.51	382.09	382.18	20401.0
2023-01-04 04:30:00	SPY	ETF	382.04	382.62	382.0	382.38	7426.0
2023-01-04 05:00:00	SPY	ETF	382.38	382.87	382.38	382.73	5175.0
2023-01-04 05:30:00	SPY	ETF	382.69	382.69	381.87	382.08	6035.0
2023-01-04 06:00:00	SPY	ETF	382.3	382.69	382.26	382.55	2992.0
2023-01-04 06:30:00	SPY	ETF	382.57	382.81	382.38	382.38	17833.0
2023-01-04 07:00:00	SPY	ETF	382.28	382.39	381.78	381.88	122620.0
2023-01-04 07:30:00	SPY	ETF	381.89	382.19	381.4	381.84	270858.0
2023-01-04 08:00:00	SPY	ETF	382.17	383.25	381.3	382.96	248609.0
2023-01-04 08:30:00	SPY	ETF	383.0	383.28	382.69	382.92	227117.0
2023-01-04 09:00:00	SPY	ETF	382.97	383.27	382.31	383.18	380160.0
2023-01-04 09:30:00	SPY	ETF	383.18	384.17	381.9	383.23	5635000.0
2023-01-04 10:00:00	SPY	ETF	383.16	384.27	380.0	381.65	6540931.0
2023-01-04 10:30:00	SPY	ETF	381.66	382.975	380.86	382.975	3163278.0
2023-01-04 11:00:00	SPY	ETF	382.97	383.69	382.311	383.581	3104797.0
2023-01-04 11:30:00	SPY	ETF	383.6	385.88	383.6	385.48	5049280.0
2023-01-04 12:00:00	SPY	ETF	385.5	385.645	385.08	385.195	2577987.0
2023-01-04 12:30:00	SPY	ETF	385.2	385.74	384.33	384.34	2098697.0
2023-01-04 13:00:00	SPY	ETF	384.35	385.1	383.65	384.83	3103718.0
2023-01-04 13:30:00	SPY	ETF	384.83	385.33	383.95	384.14	1963980.0
2023-01-04 14:00:00	SPY	ETF	384.26	385.56	381.2	381.49	8185957.0
2023-01-04 14:30:00	SPY	ETF	381.5	383.35	381.14	383.2301	4685676.0
2023-01-04 15:00:00	SPY	ETF	383.26	384.08	382.62	382.765	3803636.0
2023-01-04 15:30:00	SPY	ETF	382.76	383.99	381.2163	383.74	9596476.0
2023-01-04 16:00:00	SPY	ETF	383.73	383.95	383.32	383.42	5160782.0
2023-01-04 16:30:00	SPY	ETF	383.42	383.76	383.15	383.42	306871.0
2023-01-04 17:00:00	SPY	ETF	383.31	383.88	383.29	383.76	127842.0
2023-01-04 17:30:00	SPY	ETF	383.78	383.8006	383.61	383.61	36760.0
2023-01-04 18:00:00	SPY	ETF	383.45	383.61	383.38	383.6	58733.0
2023-01-04 18:30:00	SPY	ETF	383.63	383.87	383.63	383.63	50933.0
2023-01-04 19:00:00	SPY	ETF	383.55	383.75	383.42	383.7	17655.0
2023-01-04 19:30:00	SPY	ETF	383.7	383.7	383.34	383.37	48894.0
2023-01-04 04:00:00	QQQ	ETF	266.33	266.43	265.07	266.01	27033.0
2023-01-04 04:30:00	QQQ	ETF	265.82	266.24	265.76	265.97	29972.0
2023-01-04 05:00:00	QQQ	ETF	266.05	266.43	266.05	266.25	10633.0
2023-01-04 05:30:00	QQQ	ETF	266.33	266.33	265.24	265.69	40409.0
2023-01-04 06:00:00	QQQ	ETF	265.77	266.34	265.77	266.05	10139.0
2023-01-04 06:30:00	QQQ	ETF	266.1	266.55	266.09	266.15	20347.0
2023-01-04 07:00:00	QQQ	ETF	266.1	266.15	265.63	265.7	122030.0
2023-01-04 07:30:00	QQQ	ETF	265.84	266.04	265.19	265.62	169415.0
2023-01-04 08:00:00	QQQ	ETF	266.1275	267.01	264.678	266.61	346265.0
2023-01-04 08:30:00	QQQ	ETF	266.67	266.82	266.14	266.38	217889.0
2023-01-04 09:00:00	QQQ	ETF	266.45	266.66	265.94	266.61	401411.0
2023-01-04 09:30:00	QQQ	ETF	266.61	266.92	264.72	265.39	4464545.0
2023-01-04 10:00:00	QQQ	ETF	265.33	266.26	262.53	263.73	4963666.0
2023-01-04 10:30:00	QQQ	ETF	263.7	265.07	262.86	265.0	2337711.0
2023-01-04 11:00:00	QQQ	ETF	264.99	265.77	264.41	265.68	1866829.0
2023-01-04 11:30:00	QQQ	ETF	265.67	267.45	265.67	266.9499	2782555.0
2023-01-04 12:00:00	QQQ	ETF	267.01	267.22	266.5	266.8	1337125.0
2023-01-04 12:30:00	QQQ	ETF	266.8	267.25	265.89	265.905	1063223.0

> showing 50 of 28,017 rows — these rows as CSV

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