PREVIEW / etf_30min / 2005-06-01

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-06-01.parquet
  size:    46 KB
  rows:    1,537

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-06-01 07:30:00	SPY	ETF	119.59	119.59	119.55	119.55	12900.0
2005-06-01 08:00:00	SPY	ETF	119.6	119.62	119.55	119.62	13100.0
2005-06-01 08:30:00	SPY	ETF	119.61	119.61	119.48	119.5	97600.0
2005-06-01 09:00:00	SPY	ETF	119.49	119.55	119.48	119.5	180100.0
2005-06-01 09:30:00	SPY	ETF	119.52	119.7	119.45	119.7	4501000.0
2005-06-01 10:00:00	SPY	ETF	119.7	120.71	119.68	120.59	15089100.0
2005-06-01 10:30:00	SPY	ETF	120.59	120.74	120.4	120.51	5603600.0
2005-06-01 11:00:00	SPY	ETF	120.51	120.92	120.45	120.85	5881100.0
2005-06-01 11:30:00	SPY	ETF	120.85	120.9	120.75	120.82	1564500.0
2005-06-01 12:00:00	SPY	ETF	120.83	120.88	120.55	120.59	5196900.0
2005-06-01 12:30:00	SPY	ETF	120.59	120.84	120.56	120.75	2549100.0
2005-06-01 13:00:00	SPY	ETF	120.76	120.89	120.71	120.83	2566500.0
2005-06-01 13:30:00	SPY	ETF	120.86	120.88	120.67	120.84	2754900.0
2005-06-01 14:00:00	SPY	ETF	120.84	120.92	120.47	120.53	3953100.0
2005-06-01 14:30:00	SPY	ETF	120.53	120.81	120.0	120.13	6248100.0
2005-06-01 15:00:00	SPY	ETF	120.13	120.34	120.06	120.16	5700700.0
2005-06-01 15:30:00	SPY	ETF	120.15	120.58	120.15	120.54	3322200.0
2005-06-01 16:00:00	SPY	ETF	120.38	120.55	120.35	120.4	1075900.0
2005-06-01 16:30:00	SPY	ETF	120.39	120.5	120.33	120.45	359700.0
2005-06-01 17:00:00	SPY	ETF	120.46	120.48	120.42	120.47	72100.0
2005-06-01 17:30:00	SPY	ETF	120.47	120.47	120.4	120.4	52500.0
2005-06-01 18:00:00	SPY	ETF	120.4	120.54	120.4	120.54	109400.0
2005-06-01 18:30:00	SPY	ETF	120.54	120.55	120.54	120.55	1100.0
2005-06-01 19:00:00	SPY	ETF	120.5	120.5	120.5	120.5	1300.0
2005-06-01 19:30:00	SPY	ETF	120.53	120.53	120.52	120.52	500.0
2005-06-01 09:30:00	QQQ	ETF	38.04	38.17	38.02	38.15	7738000.0
2005-06-01 10:00:00	QQQ	ETF	38.15	38.6	38.15	38.52	26965000.0
2005-06-01 10:30:00	QQQ	ETF	38.52	38.56	38.46	38.47	6254500.0
2005-06-01 11:00:00	QQQ	ETF	38.47	38.68	38.46	38.64	12248500.0
2005-06-01 11:30:00	QQQ	ETF	38.63	38.65	38.5	38.6	3242600.0
2005-06-01 12:00:00	QQQ	ETF	38.6	38.61	38.52	38.52	4420100.0
2005-06-01 12:30:00	QQQ	ETF	38.52	38.6	38.51	38.58	2470200.0
2005-06-01 13:00:00	QQQ	ETF	38.58	38.64	38.56	38.6	3723700.0
2005-06-01 13:30:00	QQQ	ETF	38.61	38.63	38.55	38.6	4067100.0
2005-06-01 14:00:00	QQQ	ETF	38.61	38.63	38.47	38.49	6177900.0
2005-06-01 14:30:00	QQQ	ETF	38.48	38.52	38.31	38.33	11508900.0
2005-06-01 15:00:00	QQQ	ETF	38.33	38.41	38.31	38.33	5819600.0
2005-06-01 15:30:00	QQQ	ETF	38.34	38.49	38.33	38.43	6833800.0
2005-06-01 07:30:00	IWM	ETF	61.34	61.34	61.34	61.34	400.0
2005-06-01 08:30:00	IWM	ETF	61.345	61.38	61.3	61.3	8800.0
2005-06-01 09:00:00	IWM	ETF	61.3	61.345	61.3	61.325	18400.0
2005-06-01 09:30:00	IWM	ETF	61.34	61.665	61.32	61.665	1839400.0
2005-06-01 10:00:00	IWM	ETF	61.665	62.195	61.62	62.14	6716000.0
2005-06-01 10:30:00	IWM	ETF	62.14	62.185	62.04	62.04	1453600.0
2005-06-01 11:00:00	IWM	ETF	62.05	62.25	61.565	62.19	3699200.0
2005-06-01 11:30:00	IWM	ETF	62.185	62.23	62.155	62.175	327800.0
2005-06-01 12:00:00	IWM	ETF	62.175	62.19	62.015	62.045	1345200.0
2005-06-01 12:30:00	IWM	ETF	62.035	62.135	62.025	62.12	529400.0
2005-06-01 13:00:00	IWM	ETF	62.12	62.225	62.095	62.165	512800.0
2005-06-01 13:30:00	IWM	ETF	62.165	62.205	62.08	62.205	712400.0

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

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