PREVIEW / etf_30min / 2006-01-19

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-01-19.parquet
  size:    61 KB
  rows:    2,180

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
2006-01-19 05:30:00	SPY	ETF	128.04	128.04	127.97	127.97	300.0
2006-01-19 06:30:00	SPY	ETF	128.1	128.11	128.1	128.11	4000.0
2006-01-19 07:00:00	SPY	ETF	128.07	128.1	128.0	128.1	17300.0
2006-01-19 07:30:00	SPY	ETF	128.1	128.14	128.1	128.13	31200.0
2006-01-19 08:00:00	SPY	ETF	128.13	128.26	128.02	128.2	650000.0
2006-01-19 08:30:00	SPY	ETF	128.22	128.26	128.15	128.2	603700.0
2006-01-19 09:00:00	SPY	ETF	128.22	128.25	128.08	128.09	403900.0
2006-01-19 09:30:00	SPY	ETF	128.09	128.2	127.97	128.02	6478100.0
2006-01-19 10:00:00	SPY	ETF	128.04	128.14	127.9	128.02	5050500.0
2006-01-19 10:30:00	SPY	ETF	128.01	128.12	127.86	127.92	9308900.0
2006-01-19 11:00:00	SPY	ETF	127.93	128.0	127.81	127.96	5526700.0
2006-01-19 11:30:00	SPY	ETF	127.95	128.16	127.92	128.12	3651400.0
2006-01-19 12:00:00	SPY	ETF	128.1	128.28	128.01	128.27	5343400.0
2006-01-19 12:30:00	SPY	ETF	128.28	128.45	128.23	128.41	3697200.0
2006-01-19 13:00:00	SPY	ETF	128.41	128.67	128.38	128.55	4783200.0
2006-01-19 13:30:00	SPY	ETF	128.55	128.77	128.54	128.71	4944700.0
2006-01-19 14:00:00	SPY	ETF	128.71	128.75	128.58	128.6	3030300.0
2006-01-19 14:30:00	SPY	ETF	128.6	128.67	128.43	128.62	5648800.0
2006-01-19 15:00:00	SPY	ETF	128.61	128.63	128.25	128.48	5236400.0
2006-01-19 15:30:00	SPY	ETF	128.47	128.53	128.37	128.38	6024900.0
2006-01-19 16:00:00	SPY	ETF	128.37	128.4	128.26	128.29	867200.0
2006-01-19 16:30:00	SPY	ETF	128.28	128.35	128.23	128.35	32500.0
2006-01-19 17:00:00	SPY	ETF	128.36	128.37	128.31	128.35	254900.0
2006-01-19 17:30:00	SPY	ETF	128.25	128.34	128.25	128.34	200.0
2006-01-19 18:00:00	SPY	ETF	128.36	128.36	128.33	128.33	264000.0
2006-01-19 18:30:00	SPY	ETF	128.3	128.36	128.3	128.32	1600.0
2006-01-19 19:00:00	SPY	ETF	128.35	128.36	128.29	128.29	27700.0
2006-01-19 19:30:00	SPY	ETF	128.31	128.31	128.31	128.31	300.0
2006-01-19 09:30:00	QQQ	ETF	42.4	42.45	42.33	42.37	16856700.0
2006-01-19 10:00:00	QQQ	ETF	42.37	42.49	42.34	42.43	8236200.0
2006-01-19 10:30:00	QQQ	ETF	42.43	42.46	42.34	42.35	4786600.0
2006-01-19 11:00:00	QQQ	ETF	42.35	42.39	42.29	42.38	6586800.0
2006-01-19 11:30:00	QQQ	ETF	42.38	42.5	42.36	42.48	4379800.0
2006-01-19 12:00:00	QQQ	ETF	42.49	42.57	42.44	42.55	11483100.0
2006-01-19 12:30:00	QQQ	ETF	42.55	42.69	42.55	42.66	5306200.0
2006-01-19 13:00:00	QQQ	ETF	42.66	42.78	42.65	42.67	7764800.0
2006-01-19 13:30:00	QQQ	ETF	42.67	42.78	42.65	42.75	3874800.0
2006-01-19 14:00:00	QQQ	ETF	42.75	42.82	42.66	42.68	6672100.0
2006-01-19 14:30:00	QQQ	ETF	42.68	42.69	42.6	42.66	6333600.0
2006-01-19 15:00:00	QQQ	ETF	42.66	42.67	42.46	42.57	7915100.0
2006-01-19 15:30:00	QQQ	ETF	42.57	42.57	42.5	42.53	6140600.0
2006-01-19 08:00:00	IWM	ETF	70.01	70.11	70.01	70.1	66700.0
2006-01-19 08:30:00	IWM	ETF	70.11	70.12	70.04	70.09	207000.0
2006-01-19 09:00:00	IWM	ETF	70.09	70.11	70.05	70.06	102700.0
2006-01-19 09:30:00	IWM	ETF	70.05	70.34	69.94	70.28	3723600.0
2006-01-19 10:00:00	IWM	ETF	70.28	70.41	70.19	70.35	2173400.0
2006-01-19 10:30:00	IWM	ETF	70.35	70.5	70.3	70.34	2533300.0
2006-01-19 11:00:00	IWM	ETF	70.34	70.44	70.28	70.43	969500.0
2006-01-19 11:30:00	IWM	ETF	70.42	70.69	70.42	70.68	1325700.0
2006-01-19 12:00:00	IWM	ETF	70.69	70.86	70.62	70.84	2372600.0

> showing 50 of 2,180 rows — these rows as CSV

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