PREVIEW / etf_1hour / 2006-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-30.parquet
  size:    38 KB
  rows:    1,201

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-30 05:00:00	SPY	ETF	128.3	128.34	128.3	128.34	400.0
2006-01-30 06:00:00	SPY	ETF	128.37	128.37	128.37	128.37	1100.0
2006-01-30 07:00:00	SPY	ETF	128.41	128.48	128.4	128.41	27600.0
2006-01-30 08:00:00	SPY	ETF	128.43	128.58	128.43	128.44	417800.0
2006-01-30 09:00:00	SPY	ETF	128.43	128.68	128.35	128.5	4318900.0
2006-01-30 10:00:00	SPY	ETF	128.5	128.68	128.41	128.52	4724600.0
2006-01-30 11:00:00	SPY	ETF	128.51	128.52	128.35	128.4	4946200.0
2006-01-30 12:00:00	SPY	ETF	128.41	128.78	128.37	128.61	3522900.0
2006-01-30 13:00:00	SPY	ETF	128.61	128.81	128.56	128.71	3167500.0
2006-01-30 14:00:00	SPY	ETF	128.73	128.76	128.58	128.7005	3336500.0
2006-01-30 15:00:00	SPY	ETF	128.71	128.71	128.3657	128.53	7113500.0
2006-01-30 16:00:00	SPY	ETF	128.52	128.53	128.38	128.42	519900.0
2006-01-30 17:00:00	SPY	ETF	128.42	128.44	128.42	128.44	5300.0
2006-01-30 18:00:00	SPY	ETF	128.43	128.49	128.43	128.49	1700.0
2006-01-30 19:00:00	SPY	ETF	128.48	128.51	128.45	128.51	3900.0
2006-01-30 09:00:00	QQQ	ETF	42.15	42.29	42.12	42.15	14260600.0
2006-01-30 10:00:00	QQQ	ETF	42.15	42.23	42.11	42.19	6479600.0
2006-01-30 11:00:00	QQQ	ETF	42.19	42.19	42.1	42.13	4008500.0
2006-01-30 12:00:00	QQQ	ETF	42.13	42.31	42.11	42.24	5545100.0
2006-01-30 13:00:00	QQQ	ETF	42.24	42.32	42.21	42.27	4160200.0
2006-01-30 14:00:00	QQQ	ETF	42.27	42.29	42.19	42.21	6163700.0
2006-01-30 15:00:00	QQQ	ETF	42.21	42.21	42.07	42.19	9938300.0
2006-01-30 07:00:00	IWM	ETF	72.63	72.63	72.63	72.63	400.0
2006-01-30 08:00:00	IWM	ETF	72.64	72.75	72.64	72.71	122500.0
2006-01-30 09:00:00	IWM	ETF	72.67	72.9	72.59	72.72	2808300.0
2006-01-30 10:00:00	IWM	ETF	72.72	72.91	72.64	72.75	2660800.0
2006-01-30 11:00:00	IWM	ETF	72.74	72.78	72.62	72.7	1861000.0
2006-01-30 12:00:00	IWM	ETF	72.7	72.98	72.67	72.91	3248400.0
2006-01-30 13:00:00	IWM	ETF	72.92	72.94	72.75	72.84	2744700.0
2006-01-30 14:00:00	IWM	ETF	72.84	72.87	72.6	72.67	4998700.0
2006-01-30 15:00:00	IWM	ETF	72.67	72.68	72.47	72.53	7331100.0
2006-01-30 16:00:00	IWM	ETF	72.54	73.09	72.51	72.51	2163600.0
2006-01-30 17:00:00	IWM	ETF	72.56	72.58	72.53	72.53	1100.0
2006-01-30 08:00:00	DIA	ETF	109.06	109.19	109.06	109.11	28700.0
2006-01-30 09:00:00	DIA	ETF	109.11	109.2	109.01	109.07	1171100.0
2006-01-30 10:00:00	DIA	ETF	109.04	109.17	108.95	109.03	663600.0
2006-01-30 11:00:00	DIA	ETF	109.01	109.04	108.85	108.92	248900.0
2006-01-30 12:00:00	DIA	ETF	108.92	109.14	108.86	109.02	243200.0
2006-01-30 13:00:00	DIA	ETF	108.99	109.14	108.94	109.06	226300.0
2006-01-30 14:00:00	DIA	ETF	109.06	109.08	108.95	109.05	468400.0
2006-01-30 15:00:00	DIA	ETF	109.04	109.04	108.76	108.91	539200.0
2006-01-30 16:00:00	DIA	ETF	108.9	108.91	108.81	108.81	1213900.0
2006-01-30 18:00:00	DIA	ETF	108.9	108.9	108.9	108.9	4000.0
2006-01-30 07:00:00	GLD	ETF	56.03	56.03	55.98	55.98	400.0
2006-01-30 08:00:00	GLD	ETF	55.98	56.08	55.89	56.05	15000.0
2006-01-30 09:00:00	GLD	ETF	55.95	56.18	55.93	56.12	519500.0
2006-01-30 10:00:00	GLD	ETF	56.11	56.28	55.96	56.0	849000.0
2006-01-30 11:00:00	GLD	ETF	56.0	56.23	55.99	56.2	503200.0
2006-01-30 12:00:00	GLD	ETF	56.19	56.3	56.16	56.22	423200.0
2006-01-30 13:00:00	GLD	ETF	56.22	56.46	56.21	56.4	510000.0

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

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