PREVIEW / etf_30min / 2003-05-01

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-05-01.parquet
  size:    23 KB
  rows:    664

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-05-01 08:00:00	SPY	ETF	91.8	91.95	91.76	91.76	19100.0
2003-05-01 08:30:00	SPY	ETF	91.75	91.75	91.67	91.73	28200.0
2003-05-01 09:00:00	SPY	ETF	91.74	91.94	91.71	91.94	135500.0
2003-05-01 09:30:00	SPY	ETF	91.92	92.02	91.48	91.57	3550400.0
2003-05-01 10:00:00	SPY	ETF	91.48	91.52	90.5	90.64	8416100.0
2003-05-01 10:30:00	SPY	ETF	90.63	91.0	90.58	90.85	2918300.0
2003-05-01 11:00:00	SPY	ETF	90.85	91.07	90.81	90.84	1253000.0
2003-05-01 11:30:00	SPY	ETF	90.84	91.21	90.72	91.16	2027100.0
2003-05-01 12:00:00	SPY	ETF	91.16	91.3	90.97	91.22	1842100.0
2003-05-01 12:30:00	SPY	ETF	91.28	91.35	91.21	91.21	2190800.0
2003-05-01 13:00:00	SPY	ETF	91.23	91.29	91.15	91.29	679900.0
2003-05-01 13:30:00	SPY	ETF	91.27	91.78	91.27	91.65	3975300.0
2003-05-01 14:00:00	SPY	ETF	91.67	92.23	91.62	92.02	6897000.0
2003-05-01 14:30:00	SPY	ETF	92.03	92.38	92.0	92.09	2482100.0
2003-05-01 15:00:00	SPY	ETF	92.09	92.16	91.83	91.91	2903100.0
2003-05-01 15:30:00	SPY	ETF	91.91	92.06	91.72	91.92	4439100.0
2003-05-01 16:00:00	SPY	ETF	92.02	92.53	91.82	91.9	2241700.0
2003-05-01 16:30:00	SPY	ETF	91.91	91.96	91.8	91.81	141300.0
2003-05-01 17:00:00	SPY	ETF	91.84	91.96	91.81	91.91	13400.0
2003-05-01 17:30:00	SPY	ETF	91.92	91.92	91.85	91.85	2000.0
2003-05-01 18:00:00	SPY	ETF	91.94	91.94	91.84	91.93	150600.0
2003-05-01 18:30:00	SPY	ETF	91.95	91.96	91.9	91.9	7400.0
2003-05-01 19:00:00	SPY	ETF	91.87	92.26	91.87	92.15	7300.0
2003-05-01 19:30:00	SPY	ETF	92.15	92.15	92.03	92.1	4500.0
2003-05-01 08:00:00	QQQ	ETF	27.39	27.44	27.39	27.42	20500.0
2003-05-01 08:30:00	QQQ	ETF	27.42	27.43	27.35	27.37	47800.0
2003-05-01 09:00:00	QQQ	ETF	27.37	27.42	27.36	27.42	38200.0
2003-05-01 09:30:00	QQQ	ETF	27.44	27.56	27.37	27.44	7813000.0
2003-05-01 10:00:00	QQQ	ETF	27.45	27.46	27.19	27.28	11506700.0
2003-05-01 10:30:00	QQQ	ETF	27.27	27.38	27.22	27.31	3513000.0
2003-05-01 11:00:00	QQQ	ETF	27.31	27.4	27.28	27.29	3200500.0
2003-05-01 11:30:00	QQQ	ETF	27.29	27.39	27.2	27.34	2982900.0
2003-05-01 12:00:00	QQQ	ETF	27.35	27.39	27.29	27.36	2352800.0
2003-05-01 12:30:00	QQQ	ETF	27.37	27.43	27.35	27.37	2410900.0
2003-05-01 13:00:00	QQQ	ETF	27.37	27.4	27.33	27.38	821900.0
2003-05-01 13:30:00	QQQ	ETF	27.38	27.62	27.37	27.54	5573500.0
2003-05-01 14:00:00	QQQ	ETF	27.55	27.77	27.51	27.71	7411400.0
2003-05-01 14:30:00	QQQ	ETF	27.71	27.87	27.69	27.71	5197700.0
2003-05-01 15:00:00	QQQ	ETF	27.7	27.76	27.62	27.66	2747400.0
2003-05-01 15:30:00	QQQ	ETF	27.66	27.79	27.57	27.68	4551000.0
2003-05-01 16:00:00	QQQ	ETF	27.68	27.7	27.62	27.66	884700.0
2003-05-01 16:30:00	QQQ	ETF	27.66	27.7	27.64	27.65	134200.0
2003-05-01 17:00:00	QQQ	ETF	27.65	27.68	27.64	27.66	126600.0
2003-05-01 17:30:00	QQQ	ETF	27.65	27.67	27.63	27.66	21200.0
2003-05-01 18:00:00	QQQ	ETF	27.67	27.7	27.66	27.68	3800.0
2003-05-01 18:30:00	QQQ	ETF	27.7	27.72	27.7	27.7	9400.0
2003-05-01 19:00:00	QQQ	ETF	27.71	27.71	27.7	27.7	1600.0
2003-05-01 19:30:00	QQQ	ETF	27.74	27.75	27.71	27.72	7400.0
2003-05-01 09:30:00	IWM	ETF	39.75	39.75	39.54	39.555	253000.0
2003-05-01 10:00:00	IWM	ETF	39.535	39.535	39.245	39.28	250600.0

> showing 50 of 664 rows — these rows as CSV

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