PREVIEW / etf_30min / 2003-07-14

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-07-14.parquet
  size:    23 KB
  rows:    703

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-07-14 09:30:00	SPY	ETF	101.2	101.4	101.07	101.39	4023900.0
2003-07-14 10:00:00	SPY	ETF	101.37	101.83	101.32	101.77	4207100.0
2003-07-14 10:30:00	SPY	ETF	101.77	101.88	101.62	101.83	2812300.0
2003-07-14 11:00:00	SPY	ETF	101.83	101.9	101.63	101.69	1322100.0
2003-07-14 11:30:00	SPY	ETF	101.71	101.78	101.56	101.72	1024900.0
2003-07-14 12:00:00	SPY	ETF	101.74	101.8	101.39	101.54	1769300.0
2003-07-14 12:30:00	SPY	ETF	101.52	101.64	101.37	101.55	999400.0
2003-07-14 13:00:00	SPY	ETF	101.55	101.62	101.46	101.52	635700.0
2003-07-14 13:30:00	SPY	ETF	101.53	101.73	101.45	101.69	1054000.0
2003-07-14 14:00:00	SPY	ETF	101.7	101.78	101.59	101.75	1706500.0
2003-07-14 14:30:00	SPY	ETF	101.75	101.8	101.43	101.52	1315600.0
2003-07-14 15:00:00	SPY	ETF	101.52	101.55	99.915	101.265	6969500.0
2003-07-14 15:30:00	SPY	ETF	101.2	101.338	100.45	100.73	5479700.0
2003-07-14 16:00:00	SPY	ETF	100.72	101.4787	100.49	101.4787	1965500.0
2003-07-14 16:30:00	SPY	ETF	100.64	100.75	100.62	100.75	149100.0
2003-07-14 17:00:00	SPY	ETF	100.75	100.83	100.75	100.81	16800.0
2003-07-14 17:30:00	SPY	ETF	100.78	100.82	100.7	100.71	15300.0
2003-07-14 18:00:00	SPY	ETF	100.72	100.76	100.72	100.76	16100.0
2003-07-14 18:30:00	SPY	ETF	100.76	100.8	100.75	100.8	3500.0
2003-07-14 19:00:00	SPY	ETF	100.78	100.78	100.78	100.78	600.0
2003-07-14 19:30:00	SPY	ETF	100.78	100.78	100.74	100.78	13000.0
2003-07-14 09:30:00	QQQ	ETF	32.344	32.46	32.29	32.437	12995400.0
2003-07-14 10:00:00	QQQ	ETF	32.44	32.72	32.41	32.65	14490900.0
2003-07-14 10:30:00	QQQ	ETF	32.65	32.74	32.6	32.73	4277600.0
2003-07-14 11:00:00	QQQ	ETF	32.71	32.75	32.57	32.589	3313500.0
2003-07-14 11:30:00	QQQ	ETF	32.589	32.64	32.52	32.6	2990300.0
2003-07-14 12:00:00	QQQ	ETF	32.61	32.63	32.4	32.46	3900600.0
2003-07-14 12:30:00	QQQ	ETF	32.46	32.53	32.43	32.49	2123600.0
2003-07-14 13:00:00	QQQ	ETF	32.49	32.56	32.47	32.523	2643800.0
2003-07-14 13:30:00	QQQ	ETF	32.523	32.63	32.5	32.58	2495900.0
2003-07-14 14:00:00	QQQ	ETF	32.58	32.65	32.57	32.65	2915500.0
2003-07-14 14:30:00	QQQ	ETF	32.63	32.66	32.47	32.53	2784000.0
2003-07-14 15:00:00	QQQ	ETF	32.53	32.54	32.099	32.43	9691900.0
2003-07-14 15:30:00	QQQ	ETF	32.432	32.47	32.07	32.22	9173700.0
2003-07-14 16:00:00	QQQ	ETF	32.21	32.5166	32.15	32.21	2332600.0
2003-07-14 16:30:00	QQQ	ETF	32.22	32.3	32.22	32.29	65800.0
2003-07-14 17:00:00	QQQ	ETF	32.29	32.31	32.28	32.29	28100.0
2003-07-14 17:30:00	QQQ	ETF	32.29	32.31	32.28	32.28	15800.0
2003-07-14 18:00:00	QQQ	ETF	32.3	32.3	32.28	32.3	23000.0
2003-07-14 18:30:00	QQQ	ETF	32.3	32.31	32.28	32.29	6500.0
2003-07-14 19:00:00	QQQ	ETF	32.32	32.32	32.32	32.32	700.0
2003-07-14 19:30:00	QQQ	ETF	32.3	32.31	32.27	32.31	17000.0
2003-07-14 09:30:00	IWM	ETF	47.735	47.9	47.3	47.775	636400.0
2003-07-14 10:00:00	IWM	ETF	47.795	48.15	47.775	48.04	568000.0
2003-07-14 10:30:00	IWM	ETF	48.035	48.12	47.94	48.01	241000.0
2003-07-14 11:00:00	IWM	ETF	48.01	48.05	47.9	47.93	104600.0
2003-07-14 11:30:00	IWM	ETF	47.93	47.97	47.89	47.97	85000.0
2003-07-14 12:00:00	IWM	ETF	47.98	47.98	47.77	47.8	331600.0
2003-07-14 12:30:00	IWM	ETF	47.8	47.84	47.765	47.795	419200.0
2003-07-14 13:00:00	IWM	ETF	47.815	47.855	47.795	47.825	93200.0

> showing 50 of 703 rows — these rows as CSV

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