PREVIEW / etf_30min / 2005-09-20

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-09-20.parquet
  size:    49 KB
  rows:    1,714

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-09-20 07:00:00	SPY	ETF	123.35	123.35	123.35	123.35	2000.0
2005-09-20 07:30:00	SPY	ETF	123.35	123.4	123.33	123.37	88400.0
2005-09-20 08:00:00	SPY	ETF	123.33	123.42	123.27	123.39	1326900.0
2005-09-20 08:30:00	SPY	ETF	123.36	123.36	123.24	123.24	347800.0
2005-09-20 09:00:00	SPY	ETF	123.25	123.28	123.17	123.2	563000.0
2005-09-20 09:30:00	SPY	ETF	123.21	123.39	123.18	123.27	4172100.0
2005-09-20 10:00:00	SPY	ETF	123.29	123.61	123.27	123.47	7207100.0
2005-09-20 10:30:00	SPY	ETF	123.47	123.55	123.43	123.45	3455500.0
2005-09-20 11:00:00	SPY	ETF	123.48	123.55	123.41	123.45	1134300.0
2005-09-20 11:30:00	SPY	ETF	123.45	123.47	123.33	123.36	969600.0
2005-09-20 12:00:00	SPY	ETF	123.36	123.37	123.21	123.29	1660400.0
2005-09-20 12:30:00	SPY	ETF	123.29	123.34	123.24	123.3	1396800.0
2005-09-20 13:00:00	SPY	ETF	123.3	123.31	123.18	123.2	1075100.0
2005-09-20 13:30:00	SPY	ETF	123.2	123.23	123.14	123.19	1702300.0
2005-09-20 14:00:00	SPY	ETF	123.19	123.33	122.75	122.88	14524700.0
2005-09-20 14:30:00	SPY	ETF	122.88	123.2	122.16	122.28	15429400.0
2005-09-20 15:00:00	SPY	ETF	122.28	122.29	121.87	122.23	15638400.0
2005-09-20 15:30:00	SPY	ETF	122.22	122.28	122.03	122.1	9698900.0
2005-09-20 16:00:00	SPY	ETF	122.11	122.11	122.0	122.05	2196600.0
2005-09-20 16:30:00	SPY	ETF	122.05	122.08	122.0	122.0	16400.0
2005-09-20 17:00:00	SPY	ETF	122.02	122.02	121.9	121.94	209100.0
2005-09-20 17:30:00	SPY	ETF	121.91	121.99	121.89	121.91	217600.0
2005-09-20 18:00:00	SPY	ETF	121.91	121.93	121.9	121.93	35100.0
2005-09-20 18:30:00	SPY	ETF	121.93	121.97	121.93	121.95	6900.0
2005-09-20 19:00:00	SPY	ETF	121.95	121.95	121.95	121.95	200.0
2005-09-20 19:30:00	SPY	ETF	121.95	121.95	121.95	121.95	2100.0
2005-09-20 09:30:00	QQQ	ETF	39.16	39.31	39.15	39.29	8269000.0
2005-09-20 10:00:00	QQQ	ETF	39.3	39.54	39.29	39.5	14553400.0
2005-09-20 10:30:00	QQQ	ETF	39.51	39.53	39.45	39.47	7097100.0
2005-09-20 11:00:00	QQQ	ETF	39.47	39.48	39.42	39.47	3037400.0
2005-09-20 11:30:00	QQQ	ETF	39.47	39.49	39.43	39.44	1929300.0
2005-09-20 12:00:00	QQQ	ETF	39.44	39.45	39.38	39.4	1872000.0
2005-09-20 12:30:00	QQQ	ETF	39.39	39.41	39.38	39.4	1626400.0
2005-09-20 13:00:00	QQQ	ETF	39.39	39.4	39.3	39.33	3350400.0
2005-09-20 13:30:00	QQQ	ETF	39.33	39.34	39.3	39.31	2824400.0
2005-09-20 14:00:00	QQQ	ETF	39.3	39.42	39.23	39.27	14424800.0
2005-09-20 14:30:00	QQQ	ETF	39.27	39.41	38.89	38.97	21702700.0
2005-09-20 15:00:00	QQQ	ETF	38.97	39.02	38.8	39.01	15951900.0
2005-09-20 15:30:00	QQQ	ETF	39.0	39.02	38.9	38.92	10353900.0
2005-09-20 08:00:00	IWM	ETF	66.76	66.8	66.71	66.71	513000.0
2005-09-20 08:30:00	IWM	ETF	66.8	66.8	66.8	66.8	5000.0
2005-09-20 09:00:00	IWM	ETF	66.76	66.76	66.73	66.73	9600.0
2005-09-20 09:30:00	IWM	ETF	66.76	66.81	66.7	66.71	1701100.0
2005-09-20 10:00:00	IWM	ETF	66.72	66.92	66.68	66.9	1621800.0
2005-09-20 10:30:00	IWM	ETF	66.9	66.91	66.81	66.87	1867700.0
2005-09-20 11:00:00	IWM	ETF	66.86	66.89	66.81	66.86	890600.0
2005-09-20 11:30:00	IWM	ETF	66.86	66.89	66.8	66.81	784300.0
2005-09-20 12:00:00	IWM	ETF	66.82	66.83	66.72	66.75	629800.0
2005-09-20 12:30:00	IWM	ETF	66.75	66.76	66.66	66.7	507300.0
2005-09-20 13:00:00	IWM	ETF	66.7	66.71	66.62	66.64	296300.0

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

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