PREVIEW / etf_1hour / 2006-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-13.parquet
  size:    47 KB
  rows:    1,420

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-06-13 05:00:00	SPY	ETF	123.66	123.66	123.66	123.66	100.0
2006-06-13 06:00:00	SPY	ETF	123.56	123.56	123.4	123.52	11600.0
2006-06-13 07:00:00	SPY	ETF	123.58	123.59	123.3	123.41	198600.0
2006-06-13 08:00:00	SPY	ETF	123.47	124.14	123.28	123.73	7738200.0
2006-06-13 09:00:00	SPY	ETF	123.71	124.84	123.63	124.39	24745800.0
2006-06-13 10:00:00	SPY	ETF	124.38	124.39	123.45	123.6	24398400.0
2006-06-13 11:00:00	SPY	ETF	123.6	124.76	123.39	124.42	28040200.0
2006-06-13 12:00:00	SPY	ETF	124.41	124.46	123.81	124.02	12092500.0
2006-06-13 13:00:00	SPY	ETF	124.0	124.02	123.34	123.854	15144000.0
2006-06-13 14:00:00	SPY	ETF	123.85	123.89	122.86	123.03	23327600.0
2006-06-13 15:00:00	SPY	ETF	123.03	123.83	122.66	122.73	36675400.0
2006-06-13 16:00:00	SPY	ETF	122.72	123.792	121.5928	122.58	5887200.0
2006-06-13 17:00:00	SPY	ETF	122.58	122.61	122.54	122.55	185700.0
2006-06-13 18:00:00	SPY	ETF	122.6	122.68	122.59	122.59	11500.0
2006-06-13 19:00:00	SPY	ETF	122.63	122.63	122.59	122.59	1700.0
2006-06-13 09:00:00	QQQ	ETF	37.52	38.2	37.31	37.62	35773200.0
2006-06-13 10:00:00	QQQ	ETF	37.61	37.72	37.31	37.4	35801700.0
2006-06-13 11:00:00	QQQ	ETF	37.4	37.76	37.33	37.75	23557300.0
2006-06-13 12:00:00	QQQ	ETF	37.74	37.76	37.52	37.57	17703700.0
2006-06-13 13:00:00	QQQ	ETF	37.57	37.61	37.36	37.57	19719000.0
2006-06-13 14:00:00	QQQ	ETF	37.57	37.57	37.24	37.3	22295500.0
2006-06-13 15:00:00	QQQ	ETF	37.31	37.61	37.16	37.27	39707900.0
2006-06-13 07:00:00	IWM	ETF	67.5	67.5	67.3	67.32	7600.0
2006-06-13 08:00:00	IWM	ETF	67.6	68.09	67.32	67.63	2610000.0
2006-06-13 09:00:00	IWM	ETF	67.62	68.85	67.29	68.48	21761000.0
2006-06-13 10:00:00	IWM	ETF	68.48	68.51	67.33	67.54	18845600.0
2006-06-13 11:00:00	IWM	ETF	67.54	68.32	67.2	68.25	16487400.0
2006-06-13 12:00:00	IWM	ETF	68.26	68.34	67.93	68.02	10876700.0
2006-06-13 13:00:00	IWM	ETF	68.01	68.01	67.36	67.64	18284700.0
2006-06-13 14:00:00	IWM	ETF	67.64	67.66	66.76	67.05	15649000.0
2006-06-13 15:00:00	IWM	ETF	67.06	67.7	66.6	66.88	26193700.0
2006-06-13 16:00:00	IWM	ETF	66.86	67.08	66.1	66.7	3183100.0
2006-06-13 17:00:00	IWM	ETF	66.71	66.71	66.61	66.68	1035400.0
2006-06-13 18:00:00	IWM	ETF	66.75	66.8	66.75	66.8	16300.0
2006-06-13 19:00:00	IWM	ETF	66.72	66.72	66.68	66.68	4700.0
2006-06-13 07:00:00	DIA	ETF	107.57	107.57	107.4	107.4	1100.0
2006-06-13 08:00:00	DIA	ETF	107.49	108.03	107.4	107.96	287800.0
2006-06-13 09:00:00	DIA	ETF	107.93	108.69	107.74	108.38	1725000.0
2006-06-13 10:00:00	DIA	ETF	108.39	108.41	107.62	107.74	2146100.0
2006-06-13 11:00:00	DIA	ETF	107.71	108.41	107.56	108.34	1792200.0
2006-06-13 12:00:00	DIA	ETF	108.33	108.36	107.93	108.09	1023000.0
2006-06-13 13:00:00	DIA	ETF	108.08	108.1	107.6	107.97	1229900.0
2006-06-13 14:00:00	DIA	ETF	107.97	107.97	107.16	107.35	1443700.0
2006-06-13 15:00:00	DIA	ETF	107.36	108.1	107.09	107.1	3182300.0
2006-06-13 16:00:00	DIA	ETF	107.06	108.078	106.96	106.97	128400.0
2006-06-13 17:00:00	DIA	ETF	107.0	107.0	106.95	106.95	500.0
2006-06-13 18:00:00	DIA	ETF	107.0	107.0	107.0	107.0	400.0
2006-06-13 06:00:00	GLD	ETF	59.0	59.0	59.0	59.0	300.0
2006-06-13 07:00:00	GLD	ETF	58.51	59.5	58.36	58.46	53600.0
2006-06-13 08:00:00	GLD	ETF	58.46	58.71	57.93	58.05	597400.0

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

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