PREVIEW / etf_30min / 2023-05-16

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-16.parquet
  size:    663 KB
  rows:    26,896

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-05-16 04:00:00	SPY	ETF	412.83	412.9	412.62	412.79	16008.0
2023-05-16 04:30:00	SPY	ETF	412.85	412.94	412.53	412.67	8832.0
2023-05-16 05:00:00	SPY	ETF	412.7	412.89	412.4	412.54	14216.0
2023-05-16 05:30:00	SPY	ETF	412.65	412.77	412.55	412.58	10241.0
2023-05-16 06:00:00	SPY	ETF	412.37	412.65	412.07	412.63	43098.0
2023-05-16 06:30:00	SPY	ETF	412.59	412.7	412.44	412.64	21103.0
2023-05-16 07:00:00	SPY	ETF	412.62	412.79	412.35	412.43	56678.0
2023-05-16 07:30:00	SPY	ETF	412.5	412.5	412.22	412.27	69941.0
2023-05-16 08:00:00	SPY	ETF	412.26	413.17	411.8	412.34	183758.0
2023-05-16 08:30:00	SPY	ETF	412.43	412.77	411.7	411.86	322858.0
2023-05-16 09:00:00	SPY	ETF	411.86	412.0	411.6101	411.85	236368.0
2023-05-16 09:30:00	SPY	ETF	411.86	412.815	410.89	411.62	5575795.0
2023-05-16 10:00:00	SPY	ETF	411.6001	412.105	410.7	411.81	4739675.0
2023-05-16 10:30:00	SPY	ETF	411.81	412.11	410.968	411.47	3387288.0
2023-05-16 11:00:00	SPY	ETF	411.47	411.93	411.21	411.9174	2292887.0
2023-05-16 11:30:00	SPY	ETF	411.9205	412.0623	411.02	411.91	3063420.0
2023-05-16 12:00:00	SPY	ETF	411.92	412.04	411.56	411.866	1709548.0
2023-05-16 12:30:00	SPY	ETF	411.8699	412.32	411.59	412.05	2284184.0
2023-05-16 13:00:00	SPY	ETF	412.06	412.14	411.47	411.5719	1709801.0
2023-05-16 13:30:00	SPY	ETF	411.58	411.95	411.37	411.88	2016385.0
2023-05-16 14:00:00	SPY	ETF	411.89	411.97	411.17	411.29	2499141.0
2023-05-16 14:30:00	SPY	ETF	411.3	411.835	411.01	411.69	2162056.0
2023-05-16 15:00:00	SPY	ETF	411.69	411.85	411.38	411.7023	2346854.0
2023-05-16 15:30:00	SPY	ETF	411.7	411.78	410.24	410.25	7782980.0
2023-05-16 16:00:00	SPY	ETF	410.25	411.0	409.97	410.9	2844903.0
2023-05-16 16:30:00	SPY	ETF	410.9	411.11	410.68	410.74	238403.0
2023-05-16 17:00:00	SPY	ETF	410.83	410.83	410.66	410.76	28475.0
2023-05-16 17:30:00	SPY	ETF	410.81	410.81	410.34	410.47	226286.0
2023-05-16 18:00:00	SPY	ETF	410.47	410.81	410.45	410.45	124223.0
2023-05-16 18:30:00	SPY	ETF	410.5	410.6	410.38	410.6	41011.0
2023-05-16 19:00:00	SPY	ETF	410.66	410.86	410.63	410.86	22288.0
2023-05-16 19:30:00	SPY	ETF	410.85	410.9	410.7	410.83	17975.0
2023-05-16 04:00:00	QQQ	ETF	327.0	327.25	327.0	327.05	25421.0
2023-05-16 04:30:00	QQQ	ETF	327.12	327.12	326.86	326.99	12606.0
2023-05-16 05:00:00	QQQ	ETF	327.11	327.11	326.7	326.7	8729.0
2023-05-16 05:30:00	QQQ	ETF	326.75	326.77	326.68	326.68	1918.0
2023-05-16 06:00:00	QQQ	ETF	326.65	326.9	326.5	326.87	22574.0
2023-05-16 06:30:00	QQQ	ETF	326.86	326.98	326.77	326.98	21736.0
2023-05-16 07:00:00	QQQ	ETF	326.92	327.01	326.55	326.68	89600.0
2023-05-16 07:30:00	QQQ	ETF	326.65	326.75	326.54	326.68	73873.0
2023-05-16 08:00:00	QQQ	ETF	326.9619	327.17	326.32	326.65	50241.0
2023-05-16 08:30:00	QQQ	ETF	326.79	327.09	325.9	326.0	311829.0
2023-05-16 09:00:00	QQQ	ETF	325.98	326.18	325.83	326.07	293425.0
2023-05-16 09:30:00	QQQ	ETF	326.06	327.98	326.02	327.25	4824026.0
2023-05-16 10:00:00	QQQ	ETF	327.26	327.75	326.44	327.73	3220123.0
2023-05-16 10:30:00	QQQ	ETF	327.725	328.39	327.12	328.05	2380015.0
2023-05-16 11:00:00	QQQ	ETF	328.06	328.53	327.835	328.52	1732999.0
2023-05-16 11:30:00	QQQ	ETF	328.53	328.74	327.63	328.68	2147891.0
2023-05-16 12:00:00	QQQ	ETF	328.69	328.79	328.275	328.59	1568208.0
2023-05-16 12:30:00	QQQ	ETF	328.58	328.9025	328.31	328.78	1513814.0

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

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