PREVIEW / etf_30min / 2005-07-13

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-07-13.parquet
  size:    43 KB
  rows:    1,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
2005-07-13 07:00:00	SPY	ETF	122.33	122.33	122.29	122.29	3500.0
2005-07-13 07:30:00	SPY	ETF	122.3	122.38	122.3	122.38	2400.0
2005-07-13 08:00:00	SPY	ETF	122.36	122.36	122.31	122.31	50400.0
2005-07-13 08:30:00	SPY	ETF	122.3	122.31	122.25	122.27	21000.0
2005-07-13 09:00:00	SPY	ETF	122.26	122.3	122.24	122.27	42300.0
2005-07-13 09:30:00	SPY	ETF	122.27	122.47	122.23	122.31	5443300.0
2005-07-13 10:00:00	SPY	ETF	122.31	122.39	122.0	122.14	6512700.0
2005-07-13 10:30:00	SPY	ETF	122.14	122.33	121.99	122.02	5828700.0
2005-07-13 11:00:00	SPY	ETF	122.02	122.38	122.01	122.34	3027300.0
2005-07-13 11:30:00	SPY	ETF	122.35	122.36	122.18	122.25	2442900.0
2005-07-13 12:00:00	SPY	ETF	122.24	122.37	122.19	122.32	1030900.0
2005-07-13 12:30:00	SPY	ETF	122.32	122.47	122.16	122.2	1378900.0
2005-07-13 13:00:00	SPY	ETF	122.2	122.27	122.1	122.22	747600.0
2005-07-13 13:30:00	SPY	ETF	122.22	122.32	122.14	122.27	765000.0
2005-07-13 14:00:00	SPY	ETF	122.27	122.41	122.23	122.3	1835900.0
2005-07-13 14:30:00	SPY	ETF	122.3	122.41	122.23	122.25	3127500.0
2005-07-13 15:00:00	SPY	ETF	122.25	122.47	122.1	122.41	3495100.0
2005-07-13 15:30:00	SPY	ETF	122.42	122.52	122.31	122.34	3558500.0
2005-07-13 16:00:00	SPY	ETF	122.32	122.51	122.31	122.47	742400.0
2005-07-13 16:30:00	SPY	ETF	122.51	122.54	122.281	122.53	119500.0
2005-07-13 17:00:00	SPY	ETF	122.5	122.58	122.5	122.52	23100.0
2005-07-13 17:30:00	SPY	ETF	122.51	122.52	122.47	122.52	1100.0
2005-07-13 18:00:00	SPY	ETF	122.53	122.53	122.5	122.5	300.0
2005-07-13 18:30:00	SPY	ETF	122.51	122.52	122.5	122.52	4300.0
2005-07-13 19:00:00	SPY	ETF	122.52	122.53	122.51	122.53	6700.0
2005-07-13 19:30:00	SPY	ETF	122.53	122.58	122.53	122.58	20700.0
2005-07-13 09:30:00	QQQ	ETF	38.32	38.39	38.26	38.28	9786800.0
2005-07-13 10:00:00	QQQ	ETF	38.27	38.33	38.17	38.25	10800400.0
2005-07-13 10:30:00	QQQ	ETF	38.25	38.38	38.2	38.24	9323100.0
2005-07-13 11:00:00	QQQ	ETF	38.24	38.42	38.23	38.4	6766500.0
2005-07-13 11:30:00	QQQ	ETF	38.4	38.41	38.32	38.33	3586800.0
2005-07-13 12:00:00	QQQ	ETF	38.34	38.39	38.31	38.37	2485400.0
2005-07-13 12:30:00	QQQ	ETF	38.37	38.41	38.29	38.31	2638400.0
2005-07-13 13:00:00	QQQ	ETF	38.31	38.32	38.25	38.32	2090200.0
2005-07-13 13:30:00	QQQ	ETF	38.32	38.36	38.29	38.32	2377300.0
2005-07-13 14:00:00	QQQ	ETF	38.33	38.38	38.3	38.33	3353100.0
2005-07-13 14:30:00	QQQ	ETF	38.33	38.39	38.31	38.33	2643600.0
2005-07-13 15:00:00	QQQ	ETF	38.32	38.41	38.28	38.38	3889200.0
2005-07-13 15:30:00	QQQ	ETF	38.38	38.9	38.34	38.4	7623000.0
2005-07-13 07:00:00	IWM	ETF	66.64	66.64	66.64	66.64	200.0
2005-07-13 08:30:00	IWM	ETF	66.65	66.7	66.65	66.65	3700.0
2005-07-13 09:00:00	IWM	ETF	66.62	66.62	66.61	66.61	1500.0
2005-07-13 09:30:00	IWM	ETF	66.65	66.82	66.62	66.63	1347700.0
2005-07-13 10:00:00	IWM	ETF	66.63	66.71	66.25	66.38	3459100.0
2005-07-13 10:30:00	IWM	ETF	66.38	66.48	66.17	66.29	2068000.0
2005-07-13 11:00:00	IWM	ETF	66.28	66.59	66.28	66.57	1552800.0
2005-07-13 11:30:00	IWM	ETF	66.56	66.61	66.42	66.49	747500.0
2005-07-13 12:00:00	IWM	ETF	66.5	66.64	66.46	66.61	654400.0
2005-07-13 12:30:00	IWM	ETF	66.62	66.64	66.42	66.44	598100.0
2005-07-13 13:00:00	IWM	ETF	66.43	66.56	66.35	66.5	492900.0

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

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