PREVIEW / etf_30min / 2024-07-16

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-16.parquet
  size:    863 KB
  rows:    33,996

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-07-16 04:00:00	SPY	ETF	561.5	561.5	560.51	560.91	39781.0
2024-07-16 04:30:00	SPY	ETF	560.99	561.73	560.99	561.73	2435.0
2024-07-16 05:00:00	SPY	ETF	561.71	561.84	561.53	561.76	5807.0
2024-07-16 05:30:00	SPY	ETF	561.62	561.8	561.5	561.8	3318.0
2024-07-16 06:00:00	SPY	ETF	561.8	562.22	561.8	562.22	3500.0
2024-07-16 06:30:00	SPY	ETF	562.16	562.32	562.12	562.21	10732.0
2024-07-16 07:00:00	SPY	ETF	562.16	562.29	561.95	562.1	36140.0
2024-07-16 07:30:00	SPY	ETF	562.1	562.29	561.99	562.2	24059.0
2024-07-16 08:00:00	SPY	ETF	562.32	562.48	561.42	562.14	32843.0
2024-07-16 08:30:00	SPY	ETF	562.14	562.85	561.61	562.49	296719.0
2024-07-16 09:00:00	SPY	ETF	562.34	562.9	562.2	562.87	89734.0
2024-07-16 09:30:00	SPY	ETF	562.87	563.61	562.74	563.08	2906834.0
2024-07-16 10:00:00	SPY	ETF	563.075	563.25	562.1	562.66	2111540.0
2024-07-16 10:30:00	SPY	ETF	562.64	563.71	562.42	563.23	1509824.0
2024-07-16 11:00:00	SPY	ETF	563.24	564.47	562.89	563.54	1522235.0
2024-07-16 11:30:00	SPY	ETF	563.53	563.59	562.8	563.13	967488.0
2024-07-16 12:00:00	SPY	ETF	563.105	563.45	562.23	562.64	972411.0
2024-07-16 12:30:00	SPY	ETF	562.61	563.59	562.29	563.54	1010953.0
2024-07-16 13:00:00	SPY	ETF	563.54	563.54	562.645	562.74	885701.0
2024-07-16 13:30:00	SPY	ETF	562.71	563.325	562.48	563.2097	844717.0
2024-07-16 14:00:00	SPY	ETF	563.2007	563.59	562.5901	563.39	1538406.0
2024-07-16 14:30:00	SPY	ETF	563.38	564.57	563.28	564.54	1558033.0
2024-07-16 15:00:00	SPY	ETF	564.555	564.6001	564.04	564.425	2220122.0
2024-07-16 15:30:00	SPY	ETF	564.43	565.16	564.0099	564.845	5178611.0
2024-07-16 16:00:00	SPY	ETF	564.82	565.39	564.27	564.69	2276856.0
2024-07-16 16:30:00	SPY	ETF	564.67	564.86	564.61	564.64	173058.0
2024-07-16 17:00:00	SPY	ETF	564.59	564.72	564.41	564.7	53324.0
2024-07-16 17:30:00	SPY	ETF	564.7	564.73	564.65	564.66	11727.0
2024-07-16 18:00:00	SPY	ETF	564.64	564.76	564.53	564.7	28403.0
2024-07-16 18:30:00	SPY	ETF	564.73	564.85	564.71	564.77	15956.0
2024-07-16 19:00:00	SPY	ETF	564.71	564.71	564.26	564.39	18235.0
2024-07-16 19:30:00	SPY	ETF	564.39	564.46	564.33	564.4	14107.0
2024-07-16 04:00:00	QQQ	ETF	497.23	497.23	495.04	495.77	36439.0
2024-07-16 04:30:00	QQQ	ETF	495.6	496.54	495.55	496.54	14693.0
2024-07-16 05:00:00	QQQ	ETF	496.6	496.68	496.25	496.4	11610.0
2024-07-16 05:30:00	QQQ	ETF	496.35	496.47	495.91	496.41	9561.0
2024-07-16 06:00:00	QQQ	ETF	496.5	497.03	496.37	497.03	10367.0
2024-07-16 06:30:00	QQQ	ETF	497.11	497.28	496.83	496.85	28932.0
2024-07-16 07:00:00	QQQ	ETF	496.93	497.32	496.86	497.05	29844.0
2024-07-16 07:30:00	QQQ	ETF	497.1	497.28	496.87	497.15	16183.0
2024-07-16 08:00:00	QQQ	ETF	497.12	497.59	495.67	497.13	58720.0
2024-07-16 08:30:00	QQQ	ETF	496.98	497.7	495.9	497.35	135131.0
2024-07-16 09:00:00	QQQ	ETF	497.35	497.63	496.98	497.63	84299.0
2024-07-16 09:30:00	QQQ	ETF	497.62	498.44	495.6	495.91	2391599.0
2024-07-16 10:00:00	QQQ	ETF	495.94	496.26	493.64	494.53	2447676.0
2024-07-16 10:30:00	QQQ	ETF	494.52	495.88	494.22	494.98	1162018.0
2024-07-16 11:00:00	QQQ	ETF	494.96	496.58	494.55	495.36	1106477.0
2024-07-16 11:30:00	QQQ	ETF	495.345	495.79	494.61	495.22	708156.0
2024-07-16 12:00:00	QQQ	ETF	495.26	495.59	493.28	493.68	1239534.0
2024-07-16 12:30:00	QQQ	ETF	493.679	495.16	493.15	495.0916	1212427.0

> showing 50 of 33,996 rows — these rows as CSV

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