PREVIEW / etf_30min / 2024-01-30

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-01-30.parquet
  size:    805 KB
  rows:    31,674

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
2024-01-30 04:00:00	SPY	ETF	491.15	491.29	490.8	490.81	17215.0
2024-01-30 04:30:00	SPY	ETF	490.78	490.93	490.71	490.88	17942.0
2024-01-30 05:00:00	SPY	ETF	490.87	491.12	490.84	491.12	10269.0
2024-01-30 05:30:00	SPY	ETF	491.04	491.16	490.93	490.93	2958.0
2024-01-30 06:00:00	SPY	ETF	490.9	490.9	490.6	490.75	11444.0
2024-01-30 06:30:00	SPY	ETF	490.84	490.85	490.7	490.83	4965.0
2024-01-30 07:00:00	SPY	ETF	490.86	490.95	490.75	490.92	24873.0
2024-01-30 07:30:00	SPY	ETF	490.831	490.85	490.47	490.6	52960.0
2024-01-30 08:00:00	SPY	ETF	490.8896	491.34	490.03	490.34	236870.0
2024-01-30 08:30:00	SPY	ETF	490.32	490.41	490.19	490.23	65745.0
2024-01-30 09:00:00	SPY	ETF	490.26	490.6	490.12	490.55	152098.0
2024-01-30 09:30:00	SPY	ETF	490.56	491.32	490.52	491.2601	4690564.0
2024-01-30 10:00:00	SPY	ETF	491.3	491.3596	490.34	490.7498	4320687.0
2024-01-30 10:30:00	SPY	ETF	490.76	490.945	490.34	490.64	2761101.0
2024-01-30 11:00:00	SPY	ETF	490.64	491.13	490.46	491.06	2368358.0
2024-01-30 11:30:00	SPY	ETF	491.07	491.48	490.97	491.32	2460332.0
2024-01-30 12:00:00	SPY	ETF	491.33	491.47	490.53	490.56	2611046.0
2024-01-30 12:30:00	SPY	ETF	490.56	490.67	490.11	490.4	2447150.0
2024-01-30 13:00:00	SPY	ETF	490.39	490.95	490.13	490.914	2017414.0
2024-01-30 13:30:00	SPY	ETF	490.92	491.04	490.55	490.74	1567380.0
2024-01-30 14:00:00	SPY	ETF	490.75	491.26	490.46	491.23	2389946.0
2024-01-30 14:30:00	SPY	ETF	491.23	491.49	491.12	491.37	2153828.0
2024-01-30 15:00:00	SPY	ETF	491.38	491.62	490.95	491.37	2666134.0
2024-01-30 15:30:00	SPY	ETF	491.375	491.44	490.72	490.86	7882258.0
2024-01-30 16:00:00	SPY	ETF	490.85	491.1233	489.8	489.96	4038468.0
2024-01-30 16:30:00	SPY	ETF	489.96	490.13	489.28	489.31	687893.0
2024-01-30 17:00:00	SPY	ETF	489.38	489.63	488.21	488.82	400083.0
2024-01-30 17:30:00	SPY	ETF	488.83	490.89	488.15	488.4015	113820.0
2024-01-30 18:00:00	SPY	ETF	488.74	489.3	488.64	488.8	152699.0
2024-01-30 18:30:00	SPY	ETF	488.79	489.05	488.78	488.89	35773.0
2024-01-30 19:00:00	SPY	ETF	489.06	489.29	489.04	489.26	20016.0
2024-01-30 19:30:00	SPY	ETF	489.32	489.32	489.15	489.21	6941.0
2024-01-30 04:00:00	QQQ	ETF	428.41	428.62	427.88	427.9	53476.0
2024-01-30 04:30:00	QQQ	ETF	427.89	427.99	427.7	427.87	16032.0
2024-01-30 05:00:00	QQQ	ETF	427.85	428.31	427.83	428.22	33590.0
2024-01-30 05:30:00	QQQ	ETF	428.21	428.34	427.94	427.98	18353.0
2024-01-30 06:00:00	QQQ	ETF	427.87	427.97	427.67	427.97	27710.0
2024-01-30 06:30:00	QQQ	ETF	428.02	428.13	427.85	428.03	20202.0
2024-01-30 07:00:00	QQQ	ETF	428.05	428.12	427.74	427.9	62395.0
2024-01-30 07:30:00	QQQ	ETF	427.85	427.85	427.51	427.6	39728.0
2024-01-30 08:00:00	QQQ	ETF	427.84	428.67	426.95	427.27	180277.0
2024-01-30 08:30:00	QQQ	ETF	427.27	427.36	426.93	427.1	114592.0
2024-01-30 09:00:00	QQQ	ETF	427.1	427.32	426.75	427.14	150066.0
2024-01-30 09:30:00	QQQ	ETF	427.1	427.68	426.94	427.3	2590661.0
2024-01-30 10:00:00	QQQ	ETF	427.3	427.35	426.05	426.9751	2988879.0
2024-01-30 10:30:00	QQQ	ETF	426.9858	427.27	426.05	426.59	1872737.0
2024-01-30 11:00:00	QQQ	ETF	426.6	426.86	426.25	426.64	1409198.0
2024-01-30 11:30:00	QQQ	ETF	426.67	426.96	426.38	426.5899	997034.0
2024-01-30 12:00:00	QQQ	ETF	426.6	426.79	425.2401	425.32	1714094.0
2024-01-30 12:30:00	QQQ	ETF	425.32	425.44	424.76	425.0	1851839.0

> showing 50 of 31,674 rows — these rows as CSV

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