PREVIEW / etf_30min / 2002-08-19

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-08-19.parquet
  size:    21 KB
  rows:    595

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
2002-08-19 09:30:00	SPY	ETF	93.46	93.73	93.18	93.64	1993000.0
2002-08-19 10:00:00	SPY	ETF	93.6	94.45	93.57	94.2	4574000.0
2002-08-19 10:30:00	SPY	ETF	94.2	94.7	94.14	94.63	3067800.0
2002-08-19 11:00:00	SPY	ETF	94.7	95.0	94.55	94.85	2679000.0
2002-08-19 11:30:00	SPY	ETF	94.85	95.0	94.55	94.76	1394600.0
2002-08-19 12:00:00	SPY	ETF	94.79	95.0	94.68	94.76	1138200.0
2002-08-19 12:30:00	SPY	ETF	94.76	94.85	94.55	94.74	933200.0
2002-08-19 13:00:00	SPY	ETF	94.74	95.25	94.72	95.12	2076900.0
2002-08-19 13:30:00	SPY	ETF	95.08	95.36	95.0	95.36	1362700.0
2002-08-19 14:00:00	SPY	ETF	95.34	95.49	95.05	95.12	2485600.0
2002-08-19 14:30:00	SPY	ETF	95.12	95.3	94.76	95.04	3139400.0
2002-08-19 15:00:00	SPY	ETF	95.0	95.4	94.85	95.16	2121800.0
2002-08-19 15:30:00	SPY	ETF	95.17	95.75	95.12	95.52	3963200.0
2002-08-19 16:00:00	SPY	ETF	95.49	95.6	95.35	95.4	1245100.0
2002-08-19 09:30:00	QQQ	ETF	24.77	24.92	24.68	24.89	8577400.0
2002-08-19 10:00:00	QQQ	ETF	24.89	25.09	24.84	24.91	11615400.0
2002-08-19 10:30:00	QQQ	ETF	24.91	25.14	24.87	25.1	6268200.0
2002-08-19 11:00:00	QQQ	ETF	25.1	25.27	25.07	25.21	5951400.0
2002-08-19 11:30:00	QQQ	ETF	25.22	25.29	25.11	25.19	4788900.0
2002-08-19 12:00:00	QQQ	ETF	25.18	25.27	25.1	25.17	2050200.0
2002-08-19 12:30:00	QQQ	ETF	25.17	25.24	25.12	25.22	1897600.0
2002-08-19 13:00:00	QQQ	ETF	25.23	25.45	25.2	25.4	4799200.0
2002-08-19 13:30:00	QQQ	ETF	25.37	25.55	25.37	25.52	4284300.0
2002-08-19 14:00:00	QQQ	ETF	25.54	25.59	25.36	25.41	4177900.0
2002-08-19 14:30:00	QQQ	ETF	25.41	25.45	25.21	25.35	5189200.0
2002-08-19 15:00:00	QQQ	ETF	25.35	25.46	25.28	25.38	4616400.0
2002-08-19 15:30:00	QQQ	ETF	25.35	25.56	25.35	25.47	8544000.0
2002-08-19 16:00:00	QQQ	ETF	25.46	25.48	25.3	25.3	490000.0
2002-08-19 09:30:00	IWM	ETF	39.705	39.75	39.535	39.68	562600.0
2002-08-19 10:00:00	IWM	ETF	39.68	40.0	39.675	39.87	299800.0
2002-08-19 10:30:00	IWM	ETF	39.87	40.0	39.87	39.995	83600.0
2002-08-19 11:00:00	IWM	ETF	39.98	40.125	39.935	40.09	106600.0
2002-08-19 11:30:00	IWM	ETF	40.05	40.095	39.9	39.935	131600.0
2002-08-19 12:00:00	IWM	ETF	39.955	39.955	39.885	39.925	28800.0
2002-08-19 12:30:00	IWM	ETF	39.91	39.93	39.845	39.875	144000.0
2002-08-19 13:00:00	IWM	ETF	39.875	40.05	39.875	40.005	382200.0
2002-08-19 13:30:00	IWM	ETF	40.05	40.05	39.95	40.0	125200.0
2002-08-19 14:00:00	IWM	ETF	40.01	40.075	39.905	39.93	945400.0
2002-08-19 14:30:00	IWM	ETF	39.925	40.0	39.875	39.885	93200.0
2002-08-19 15:00:00	IWM	ETF	39.9	40.03	39.895	40.02	66400.0
2002-08-19 15:30:00	IWM	ETF	39.955	40.14	39.955	40.09	129200.0
2002-08-19 16:00:00	IWM	ETF	40.05	40.05	39.99	40.025	8000.0
2002-08-19 09:30:00	DIA	ETF	87.53	88.2	87.5	88.0	727500.0
2002-08-19 10:00:00	DIA	ETF	88.0	89.0	87.96	88.78	1187300.0
2002-08-19 10:30:00	DIA	ETF	88.8	89.33	88.68	89.26	1098300.0
2002-08-19 11:00:00	DIA	ETF	89.25	89.58	89.1	89.49	783100.0
2002-08-19 11:30:00	DIA	ETF	89.41	89.55	89.0	89.33	581600.0
2002-08-19 12:00:00	DIA	ETF	89.32	89.48	89.16	89.22	295100.0
2002-08-19 12:30:00	DIA	ETF	89.2	89.35	89.03	89.32	304400.0
2002-08-19 13:00:00	DIA	ETF	89.31	89.73	89.18	89.5	557600.0

> showing 50 of 595 rows — these rows as CSV

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