PREVIEW / etf_30min / 2003-08-07

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-08-07.parquet
  size:    23 KB
  rows:    669

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
2003-08-07 08:00:00	SPY	ETF	96.87	96.93	96.8	96.93	37700.0
2003-08-07 08:30:00	SPY	ETF	96.98	97.11	96.87	96.93	79800.0
2003-08-07 09:00:00	SPY	ETF	96.96	97.2	96.95	97.17	39500.0
2003-08-07 09:30:00	SPY	ETF	97.17	97.351	96.758	97.32	5003400.0
2003-08-07 10:00:00	SPY	ETF	97.31	97.45	96.828	97.11	3283900.0
2003-08-07 10:30:00	SPY	ETF	97.04	97.494	96.99	97.29	2575900.0
2003-08-07 11:00:00	SPY	ETF	97.3	97.53	97.22	97.45	1432400.0
2003-08-07 11:30:00	SPY	ETF	97.45	97.8	97.45	97.68	2614400.0
2003-08-07 12:00:00	SPY	ETF	97.68	97.74	97.411	97.44	1616400.0
2003-08-07 12:30:00	SPY	ETF	97.43	97.68	97.37	97.57	949700.0
2003-08-07 13:00:00	SPY	ETF	97.57	97.86	97.5	97.73	2419500.0
2003-08-07 13:30:00	SPY	ETF	97.72	97.93	97.52	97.82	2734100.0
2003-08-07 14:00:00	SPY	ETF	97.8	97.91	97.63	97.7	1166500.0
2003-08-07 14:30:00	SPY	ETF	97.7	97.884	97.4	97.54	2040300.0
2003-08-07 15:00:00	SPY	ETF	97.541	97.978	97.46	97.82	2935100.0
2003-08-07 15:30:00	SPY	ETF	97.81	97.94	97.66	97.89	2032000.0
2003-08-07 16:00:00	SPY	ETF	97.88	98.08	97.81	98.04	2702100.0
2003-08-07 16:30:00	SPY	ETF	98.03	98.1	97.95	97.97	118300.0
2003-08-07 17:00:00	SPY	ETF	97.97	97.97	97.66	97.96	137700.0
2003-08-07 17:30:00	SPY	ETF	97.92	97.95	97.91	97.95	10500.0
2003-08-07 18:00:00	SPY	ETF	97.95	98.0	97.94	97.94	15800.0
2003-08-07 18:30:00	SPY	ETF	97.94	97.94	97.92	97.92	2700.0
2003-08-07 19:00:00	SPY	ETF	97.96	97.99	97.96	97.99	700.0
2003-08-07 19:30:00	SPY	ETF	98.05	98.05	97.95	97.95	800.0
2003-08-07 08:00:00	QQQ	ETF	30.14	30.14	30.1	30.13	49900.0
2003-08-07 08:30:00	QQQ	ETF	30.14	30.19	30.11	30.16	91700.0
2003-08-07 09:00:00	QQQ	ETF	30.16	30.24	30.14	30.23	172900.0
2003-08-07 09:30:00	QQQ	ETF	30.22	30.37	30.1	30.23	9837200.0
2003-08-07 10:00:00	QQQ	ETF	30.24	30.28	30.03	30.12	6842200.0
2003-08-07 10:30:00	QQQ	ETF	30.11	30.3	30.07	30.21	5992100.0
2003-08-07 11:00:00	QQQ	ETF	30.22	30.283	30.16	30.254	2596900.0
2003-08-07 11:30:00	QQQ	ETF	30.26	30.5	30.25	30.42	5410800.0
2003-08-07 12:00:00	QQQ	ETF	30.42	30.48	30.3	30.32	2522400.0
2003-08-07 12:30:00	QQQ	ETF	30.33	30.4	30.27	30.36	2023800.0
2003-08-07 13:00:00	QQQ	ETF	30.36	30.46	30.32	30.36	3387300.0
2003-08-07 13:30:00	QQQ	ETF	30.36	30.43	30.26	30.39	3380300.0
2003-08-07 14:00:00	QQQ	ETF	30.4	30.422	30.27	30.27	2353000.0
2003-08-07 14:30:00	QQQ	ETF	30.3	30.37	30.11	30.19	4072600.0
2003-08-07 15:00:00	QQQ	ETF	30.189	30.33	30.15	30.255	3357200.0
2003-08-07 15:30:00	QQQ	ETF	30.249	30.34	30.17	30.29	4109000.0
2003-08-07 16:00:00	QQQ	ETF	30.3	30.34	30.26	30.33	2107400.0
2003-08-07 16:30:00	QQQ	ETF	30.31	30.35	30.28	30.29	210100.0
2003-08-07 17:00:00	QQQ	ETF	30.3	30.3	30.274	30.28	39200.0
2003-08-07 17:30:00	QQQ	ETF	30.27	30.3	30.27	30.3	14900.0
2003-08-07 18:00:00	QQQ	ETF	30.29	30.302	30.28	30.28	10200.0
2003-08-07 18:30:00	QQQ	ETF	30.29	30.32	30.29	30.29	2800.0
2003-08-07 19:00:00	QQQ	ETF	30.31	30.31	30.31	30.31	500.0
2003-08-07 19:30:00	QQQ	ETF	30.3	30.32	30.3	30.3	4100.0
2003-08-07 09:30:00	IWM	ETF	45.255	45.3	45.05	45.175	296400.0
2003-08-07 10:00:00	IWM	ETF	45.295	45.295	44.85	44.9	407800.0

> showing 50 of 669 rows — these rows as CSV

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