PREVIEW / etf_30min / 2005-07-21

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-07-21.parquet
  size:    48 KB
  rows:    1,656

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
2005-07-21 07:00:00	SPY	ETF	123.5	124.33	123.5	123.97	307000.0
2005-07-21 07:30:00	SPY	ETF	123.92	124.02	123.42	123.69	589700.0
2005-07-21 08:00:00	SPY	ETF	123.98	123.98	123.15	123.38	4257600.0
2005-07-21 08:30:00	SPY	ETF	123.41	123.85	123.12	123.61	3325700.0
2005-07-21 09:00:00	SPY	ETF	123.64	123.77	123.49	123.58	691400.0
2005-07-21 09:30:00	SPY	ETF	123.55	123.6	123.2	123.31	7882900.0
2005-07-21 10:00:00	SPY	ETF	123.29	123.41	122.77	122.93	9810500.0
2005-07-21 10:30:00	SPY	ETF	122.94	122.96	122.47	122.64	9029900.0
2005-07-21 11:00:00	SPY	ETF	122.63	122.94	122.56	122.75	5110100.0
2005-07-21 11:30:00	SPY	ETF	122.74	122.99	122.65	122.74	2477900.0
2005-07-21 12:00:00	SPY	ETF	122.74	122.93	122.66	122.89	3737100.0
2005-07-21 12:30:00	SPY	ETF	122.9	123.55	122.88	123.37	10832900.0
2005-07-21 13:00:00	SPY	ETF	123.39	123.61	123.19	123.26	3717600.0
2005-07-21 13:30:00	SPY	ETF	123.27	123.37	123.12	123.15	2763500.0
2005-07-21 14:00:00	SPY	ETF	123.14	123.18	122.78	122.83	7370600.0
2005-07-21 14:30:00	SPY	ETF	122.83	123.03	122.57	122.72	13629600.0
2005-07-21 15:00:00	SPY	ETF	122.7	123.0	122.66	122.97	4411300.0
2005-07-21 15:30:00	SPY	ETF	122.95	123.0	122.67	122.69	6899000.0
2005-07-21 16:00:00	SPY	ETF	122.7	122.93	122.61	122.65	1209000.0
2005-07-21 16:30:00	SPY	ETF	122.62	122.66	122.49	122.52	534500.0
2005-07-21 17:00:00	SPY	ETF	122.52	122.54	122.51	122.52	37600.0
2005-07-21 17:30:00	SPY	ETF	122.52	122.52	122.52	122.52	400.0
2005-07-21 18:00:00	SPY	ETF	122.57	122.65	122.57	122.65	1100.0
2005-07-21 18:30:00	SPY	ETF	122.65	122.65	122.65	122.65	2000.0
2005-07-21 19:00:00	SPY	ETF	122.66	122.66	122.64	122.64	1600.0
2005-07-21 19:30:00	SPY	ETF	122.63	122.63	122.63	122.63	500.0
2005-07-21 09:30:00	QQQ	ETF	39.56	39.57	38.49	39.51	11137900.0
2005-07-21 10:00:00	QQQ	ETF	39.51	39.53	39.25	39.31	12282000.0
2005-07-21 10:30:00	QQQ	ETF	39.32	39.36	39.21	39.27	9640000.0
2005-07-21 11:00:00	QQQ	ETF	39.27	39.44	39.25	39.37	7094700.0
2005-07-21 11:30:00	QQQ	ETF	39.37	39.43	39.3	39.37	7219000.0
2005-07-21 12:00:00	QQQ	ETF	39.38	39.43	39.31	39.42	4826800.0
2005-07-21 12:30:00	QQQ	ETF	39.42	39.67	39.42	39.62	12175900.0
2005-07-21 13:00:00	QQQ	ETF	39.62	39.69	39.55	39.58	6158700.0
2005-07-21 13:30:00	QQQ	ETF	39.58	39.62	39.52	39.58	5156000.0
2005-07-21 14:00:00	QQQ	ETF	39.58	39.61	39.45	39.46	3857800.0
2005-07-21 14:30:00	QQQ	ETF	39.47	39.53	39.35	39.37	7490400.0
2005-07-21 15:00:00	QQQ	ETF	39.38	39.53	39.36	39.51	8344600.0
2005-07-21 15:30:00	QQQ	ETF	39.51	39.52	39.42	39.46	7236900.0
2005-07-21 07:00:00	IWM	ETF	67.32	67.71	67.32	67.71	1300.0
2005-07-21 07:30:00	IWM	ETF	67.42	67.46	67.4	67.4	25900.0
2005-07-21 08:00:00	IWM	ETF	67.39	67.46	67.06	67.34	29800.0
2005-07-21 08:30:00	IWM	ETF	67.4	67.46	67.23	67.46	8700.0
2005-07-21 09:00:00	IWM	ETF	67.5	67.5	67.34	67.34	8800.0
2005-07-21 09:30:00	IWM	ETF	67.45	67.45	66.96	67.16	3005400.0
2005-07-21 10:00:00	IWM	ETF	67.16	67.18	66.65	66.74	4115300.0
2005-07-21 10:30:00	IWM	ETF	66.76	66.79	66.26	66.33	3851200.0
2005-07-21 11:00:00	IWM	ETF	66.32	67.27	66.29	66.45	4266300.0
2005-07-21 11:30:00	IWM	ETF	66.45	66.6	66.35	66.45	933600.0
2005-07-21 12:00:00	IWM	ETF	66.45	66.78	66.43	66.742	1183600.0

> showing 50 of 1,656 rows — these rows as CSV

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