PREVIEW / etf_30min / 2023-03-08

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-08.parquet
  size:    671 KB
  rows:    26,898

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-03-08 04:00:00	SPY	ETF	398.74	398.82	398.06	398.39	52733.0
2023-03-08 04:30:00	SPY	ETF	398.4	398.77	398.4	398.72	12966.0
2023-03-08 05:00:00	SPY	ETF	398.79	398.79	398.58	398.58	6544.0
2023-03-08 05:30:00	SPY	ETF	398.66	399.05	398.66	399.04	9604.0
2023-03-08 06:00:00	SPY	ETF	399.01	399.41	398.98	399.15	22002.0
2023-03-08 06:30:00	SPY	ETF	399.18	399.18	398.75	398.78	29721.0
2023-03-08 07:00:00	SPY	ETF	398.78	398.87	398.12	398.3	86434.0
2023-03-08 07:30:00	SPY	ETF	398.31	398.34	397.64	398.23	94891.0
2023-03-08 08:00:00	SPY	ETF	398.22	399.095	397.66	398.48	372955.0
2023-03-08 08:30:00	SPY	ETF	398.5	398.89	398.3	398.49	120920.0
2023-03-08 09:00:00	SPY	ETF	398.48	398.75	398.26	398.37	234877.0
2023-03-08 09:30:00	SPY	ETF	398.39	399.1	397.94	398.745	5317085.0
2023-03-08 10:00:00	SPY	ETF	398.74	399.25	396.83	398.63	7528166.0
2023-03-08 10:30:00	SPY	ETF	398.63	399.69	398.09	398.3692	4271603.0
2023-03-08 11:00:00	SPY	ETF	398.37	399.18	398.28	398.6	3093104.0
2023-03-08 11:30:00	SPY	ETF	398.6	399.71	397.72	399.315	4837311.0
2023-03-08 12:00:00	SPY	ETF	399.33	399.495	397.894	397.985	3796827.0
2023-03-08 12:30:00	SPY	ETF	397.975	398.37	397.22	397.95	3940264.0
2023-03-08 13:00:00	SPY	ETF	397.955	398.17	396.74	396.8399	4176292.0
2023-03-08 13:30:00	SPY	ETF	396.83	397.28	396.59	397.0099	3185466.0
2023-03-08 14:00:00	SPY	ETF	396.9915	397.86	396.91	397.81	2904600.0
2023-03-08 14:30:00	SPY	ETF	397.815	398.01	397.2499	397.3299	2676370.0
2023-03-08 15:00:00	SPY	ETF	397.33	397.57	396.95	397.2201	2666322.0
2023-03-08 15:30:00	SPY	ETF	397.21	399.16	397.18	398.92	8658284.0
2023-03-08 16:00:00	SPY	ETF	398.92	399.1	398.76	399.08	2565335.0
2023-03-08 16:30:00	SPY	ETF	399.09	399.2	398.8587	399.16	217458.0
2023-03-08 17:00:00	SPY	ETF	399.14	399.3	399.14	399.26	80495.0
2023-03-08 17:30:00	SPY	ETF	399.28	399.28	399.2	399.2	10814.0
2023-03-08 18:00:00	SPY	ETF	399.19	399.19	398.88	398.97	65863.0
2023-03-08 18:30:00	SPY	ETF	398.99	399.09	398.8	398.88	40370.0
2023-03-08 19:00:00	SPY	ETF	398.85	398.89	398.7	398.77	30639.0
2023-03-08 19:30:00	SPY	ETF	398.72	398.77	397.91	398.64	100446.0
2023-03-08 04:00:00	QQQ	ETF	297.35	297.35	296.19	296.4	67325.0
2023-03-08 04:30:00	QQQ	ETF	296.48	296.72	296.45	296.7	9862.0
2023-03-08 05:00:00	QQQ	ETF	296.7	296.71	296.47	296.5	37191.0
2023-03-08 05:30:00	QQQ	ETF	296.59	297.06	296.59	297.02	10501.0
2023-03-08 06:00:00	QQQ	ETF	297.1	297.53	297.05	297.22	32408.0
2023-03-08 06:30:00	QQQ	ETF	297.25	297.25	296.88	296.9	18743.0
2023-03-08 07:00:00	QQQ	ETF	296.86	297.02	296.2	296.45	116737.0
2023-03-08 07:30:00	QQQ	ETF	296.5	296.51	295.95	296.36	63107.0
2023-03-08 08:00:00	QQQ	ETF	296.86	297.0696	295.82	296.55	380254.0
2023-03-08 08:30:00	QQQ	ETF	296.66	296.99	296.36	296.57	188026.0
2023-03-08 09:00:00	QQQ	ETF	296.57	296.91	296.44	296.76	184266.0
2023-03-08 09:30:00	QQQ	ETF	296.74	297.49	296.02	296.57	4056784.0
2023-03-08 10:00:00	QQQ	ETF	296.56	297.27	294.88	296.8	5792823.0
2023-03-08 10:30:00	QQQ	ETF	296.82	297.68	296.4	296.8899	3348034.0
2023-03-08 11:00:00	QQQ	ETF	296.89	297.91	296.77	297.1041	2111275.0
2023-03-08 11:30:00	QQQ	ETF	297.12	298.43	296.24	298.2	2984254.0
2023-03-08 12:00:00	QQQ	ETF	298.2	298.37	296.86	296.94	2359406.0
2023-03-08 12:30:00	QQQ	ETF	296.93	297.34	296.171	296.925	1958970.0

> showing 50 of 26,898 rows — these rows as CSV

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