PREVIEW / etf_1hour / 2005-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-27.parquet
  size:    31 KB
  rows:    926

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-27 07:00:00	SPY	ETF	123.33	123.4	123.33	123.35	6200.0
2005-07-27 08:00:00	SPY	ETF	123.44	123.53	123.37	123.49	290100.0
2005-07-27 09:00:00	SPY	ETF	123.53	123.53	123.29	123.37	3988200.0
2005-07-27 10:00:00	SPY	ETF	123.36	123.44	123.05	123.14	10129200.0
2005-07-27 11:00:00	SPY	ETF	123.14	123.35	123.09	123.19	3483900.0
2005-07-27 12:00:00	SPY	ETF	123.19	123.41	123.19	123.31	4001800.0
2005-07-27 13:00:00	SPY	ETF	123.32	123.41	123.22	123.38	3152700.0
2005-07-27 14:00:00	SPY	ETF	123.39	123.8	123.34	123.72	7294200.0
2005-07-27 15:00:00	SPY	ETF	123.71	123.85	123.66	123.79	7574900.0
2005-07-27 16:00:00	SPY	ETF	123.81	123.88	123.73	123.77	1848100.0
2005-07-27 17:00:00	SPY	ETF	123.74	123.81	123.69	123.72	1515000.0
2005-07-27 18:00:00	SPY	ETF	123.72	123.8	123.72	123.8	43300.0
2005-07-27 19:00:00	SPY	ETF	123.82	123.82	123.82	123.82	800.0
2005-07-27 09:00:00	QQQ	ETF	39.43	39.46	39.33	39.36	7782200.0
2005-07-27 10:00:00	QQQ	ETF	39.36	39.52	39.23	39.42	17482400.0
2005-07-27 11:00:00	QQQ	ETF	39.42	39.45	39.34	39.4	3861100.0
2005-07-27 12:00:00	QQQ	ETF	39.4	39.52	39.4	39.44	5861800.0
2005-07-27 13:00:00	QQQ	ETF	39.44	39.53	39.38	39.49	7068800.0
2005-07-27 14:00:00	QQQ	ETF	39.5	39.72	39.48	39.7	16411700.0
2005-07-27 15:00:00	QQQ	ETF	39.7	39.76	39.66	39.72	11082400.0
2005-07-27 08:00:00	IWM	ETF	67.25	67.26	67.15	67.25	11000.0
2005-07-27 09:00:00	IWM	ETF	67.29	67.29	66.81	66.87	2417900.0
2005-07-27 10:00:00	IWM	ETF	66.85	67.25	66.45	66.47	5242100.0
2005-07-27 11:00:00	IWM	ETF	66.47	66.7	66.47	66.59	1744200.0
2005-07-27 12:00:00	IWM	ETF	66.59	66.96	66.59	66.81	3492500.0
2005-07-27 13:00:00	IWM	ETF	66.8	66.86	66.63	66.85	1867300.0
2005-07-27 14:00:00	IWM	ETF	66.84	67.11	66.78	67.01	4078500.0
2005-07-27 15:00:00	IWM	ETF	67.01	67.22	66.86	67.22	4430600.0
2005-07-27 16:00:00	IWM	ETF	67.21	67.4	67.15	67.22	1054100.0
2005-07-27 17:00:00	IWM	ETF	67.23	67.28	67.13	67.21	1303300.0
2005-07-27 18:00:00	IWM	ETF	67.18	67.18	67.18	67.18	1400.0
2005-07-27 08:00:00	DIA	ETF	106.0	106.12	106.0	106.09	11100.0
2005-07-27 09:00:00	DIA	ETF	106.11	106.14	105.93	105.98	965100.0
2005-07-27 10:00:00	DIA	ETF	105.98	106.05	105.74	105.86	1248800.0
2005-07-27 11:00:00	DIA	ETF	105.86	105.96	105.79	105.85	652600.0
2005-07-27 12:00:00	DIA	ETF	105.85	106.04	105.85	105.92	322200.0
2005-07-27 13:00:00	DIA	ETF	105.9	106.06	105.84	106.02	792300.0
2005-07-27 14:00:00	DIA	ETF	106.01	106.39	105.99	106.35	906600.0
2005-07-27 15:00:00	DIA	ETF	106.34	106.43	106.25	106.36	1873400.0
2005-07-27 16:00:00	DIA	ETF	106.37	106.44	106.3	106.32	40900.0
2005-07-27 17:00:00	DIA	ETF	106.34	106.36	106.34	106.36	164400.0
2005-07-27 09:00:00	GLD	ETF	42.32	42.4	42.3	42.34	212800.0
2005-07-27 10:00:00	GLD	ETF	42.35	42.38	42.32	42.33	182200.0
2005-07-27 11:00:00	GLD	ETF	42.33	42.42	42.32	42.4	63500.0
2005-07-27 12:00:00	GLD	ETF	42.4	42.5	42.39	42.45	77300.0
2005-07-27 13:00:00	GLD	ETF	42.44	42.48	42.38	42.41	416700.0
2005-07-27 14:00:00	GLD	ETF	42.42	42.44	42.39	42.44	190600.0
2005-07-27 15:00:00	GLD	ETF	42.44	42.46	42.35	42.43	377200.0
2005-07-27 16:00:00	GLD	ETF	42.44	42.44	42.44	42.44	3800.0
2005-07-27 08:00:00	TLT	ETF	93.25	93.25	93.25	93.25	10000.0

> showing 50 of 926 rows — these rows as CSV

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