PREVIEW / etf_30min / 2023-03-27

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-27.parquet
  size:    675 KB
  rows:    27,589

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-27 04:00:00	SPY	ETF	397.25	397.25	395.84	396.85	57165.0
2023-03-27 04:30:00	SPY	ETF	396.87	397.15	396.79	396.83	20112.0
2023-03-27 05:00:00	SPY	ETF	396.96	397.14	396.65	396.93	6017.0
2023-03-27 05:30:00	SPY	ETF	396.88	397.6	396.73	397.2	28176.0
2023-03-27 06:00:00	SPY	ETF	397.51	398.03	397.5	397.76	31282.0
2023-03-27 06:30:00	SPY	ETF	397.65	398.26	397.62	397.96	42428.0
2023-03-27 07:00:00	SPY	ETF	397.94	398.67	397.94	398.65	329615.0
2023-03-27 07:30:00	SPY	ETF	398.65	398.8	398.07	398.38	178886.0
2023-03-27 08:00:00	SPY	ETF	398.4	398.75	395.6	398.1	195180.0
2023-03-27 08:30:00	SPY	ETF	398.1	398.48	397.89	398.0	147236.0
2023-03-27 09:00:00	SPY	ETF	398.05	398.45	397.95	398.11	207312.0
2023-03-27 09:30:00	SPY	ETF	398.11	398.92	397.41	398.0399	7311434.0
2023-03-27 10:00:00	SPY	ETF	398.04	398.22	397.06	397.17	4263698.0
2023-03-27 10:30:00	SPY	ETF	397.14	397.28	396.23	396.41	4236019.0
2023-03-27 11:00:00	SPY	ETF	396.41	396.71	395.82	396.61	3081525.0
2023-03-27 11:30:00	SPY	ETF	396.63	396.87	395.56	395.96	2637243.0
2023-03-27 12:00:00	SPY	ETF	395.95	396.866	395.57	396.81	3537686.0
2023-03-27 12:30:00	SPY	ETF	396.81	396.97	396.1	396.43	2334610.0
2023-03-27 13:00:00	SPY	ETF	396.45	397.14	396.04	397.03	2367509.0
2023-03-27 13:30:00	SPY	ETF	397.04	397.545	396.81	396.83	2753410.0
2023-03-27 14:00:00	SPY	ETF	396.84	397.66	396.385	397.38	2716878.0
2023-03-27 14:30:00	SPY	ETF	397.4	398.12	397.4	398.04	2868810.0
2023-03-27 15:00:00	SPY	ETF	398.04	398.27	397.22	397.71	3904111.0
2023-03-27 15:30:00	SPY	ETF	397.68	397.85	395.84	396.45	11013594.0
2023-03-27 16:00:00	SPY	ETF	396.45	396.77	396.2524	396.74	2642921.0
2023-03-27 16:30:00	SPY	ETF	396.72	396.95	396.7	396.92	75811.0
2023-03-27 17:00:00	SPY	ETF	396.99	397.0	396.2735	396.91	1495771.0
2023-03-27 17:30:00	SPY	ETF	396.91	396.99	396.85	396.93	23615.0
2023-03-27 18:00:00	SPY	ETF	396.89	396.89	396.63	396.67	43292.0
2023-03-27 18:30:00	SPY	ETF	396.67	396.84	396.55	396.84	62075.0
2023-03-27 19:00:00	SPY	ETF	396.87	396.96	396.82	396.89	19347.0
2023-03-27 19:30:00	SPY	ETF	396.93	397.06	396.88	397.01	59113.0
2023-03-27 04:00:00	QQQ	ETF	310.78	311.3	310.35	311.23	52035.0
2023-03-27 04:30:00	QQQ	ETF	311.22	311.45	311.16	311.32	10848.0
2023-03-27 05:00:00	QQQ	ETF	311.32	311.48	311.1	311.2	10781.0
2023-03-27 05:30:00	QQQ	ETF	311.13	311.69	311.11	311.41	22928.0
2023-03-27 06:00:00	QQQ	ETF	311.57	312.04	311.57	311.8	35023.0
2023-03-27 06:30:00	QQQ	ETF	311.63	312.02	311.63	311.86	12471.0
2023-03-27 07:00:00	QQQ	ETF	311.82	312.5	311.79	312.46	123866.0
2023-03-27 07:30:00	QQQ	ETF	312.42	312.45	311.93	312.21	93295.0
2023-03-27 08:00:00	QQQ	ETF	312.21	312.7	310.13	311.87	151593.0
2023-03-27 08:30:00	QQQ	ETF	311.86	312.03	311.4111	311.48	210510.0
2023-03-27 09:00:00	QQQ	ETF	311.53	312.0	311.45	311.54	172975.0
2023-03-27 09:30:00	QQQ	ETF	311.6	312.7	310.71	311.9099	6521813.0
2023-03-27 10:00:00	QQQ	ETF	311.91	312.2905	310.96	311.0501	3119264.0
2023-03-27 10:30:00	QQQ	ETF	311.05	311.08	310.09	310.17	2867201.0
2023-03-27 11:00:00	QQQ	ETF	310.18	310.35	309.26	309.86	2548681.0
2023-03-27 11:30:00	QQQ	ETF	309.86	310.04	308.09	308.26	2489288.0
2023-03-27 12:00:00	QQQ	ETF	308.26	309.15	307.89	309.11	2423162.0
2023-03-27 12:30:00	QQQ	ETF	309.1	309.18	307.95	308.52	2062313.0

> showing 50 of 27,589 rows — these rows as CSV

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