PREVIEW / etf_1hour / 2009-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-31.parquet
  size:    140 KB
  rows:    4,305

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
2009-07-31 04:00:00	SPY	ETF	98.78	98.78	98.78	98.78	1000.0
2009-07-31 05:00:00	SPY	ETF	98.8	98.88	98.8	98.88	5180.0
2009-07-31 06:00:00	SPY	ETF	98.92	99.09	98.92	98.96	8600.0
2009-07-31 07:00:00	SPY	ETF	99.01	99.11	98.96	99.02	1010380.0
2009-07-31 08:00:00	SPY	ETF	99.03	99.53	98.27	98.33	10120606.0
2009-07-31 09:00:00	SPY	ETF	98.33	99.46	98.3	98.92	34053519.0
2009-07-31 10:00:00	SPY	ETF	98.92	99.27	98.38	99.09	43317142.0
2009-07-31 11:00:00	SPY	ETF	99.08	99.16	98.72	99.03	19035994.0
2009-07-31 12:00:00	SPY	ETF	99.035	99.09	98.78	98.9	11995881.0
2009-07-31 13:00:00	SPY	ETF	98.9	99.18	98.78	99.1	12413640.0
2009-07-31 14:00:00	SPY	ETF	99.09	99.38	98.89	99.0	16904632.0
2009-07-31 15:00:00	SPY	ETF	98.99	99.47	98.69	98.83	41573384.0
2009-07-31 16:00:00	SPY	ETF	98.83	99.39	98.58	98.8113	14463653.0
2009-07-31 17:00:00	SPY	ETF	98.75	98.77	98.68	98.71	57320.0
2009-07-31 18:00:00	SPY	ETF	98.7	98.74	98.6	98.68	31634.0
2009-07-31 19:00:00	SPY	ETF	98.68	98.7	98.63	98.68	26407.0
2009-07-31 05:00:00	QQQ	ETF	39.61	39.61	39.61	39.61	3000.0
2009-07-31 06:00:00	QQQ	ETF	39.61	39.66	39.61	39.66	2600.0
2009-07-31 07:00:00	QQQ	ETF	39.63	39.71	39.63	39.69	25926.0
2009-07-31 08:00:00	QQQ	ETF	39.69	39.8	39.41	39.44	1412539.0
2009-07-31 09:00:00	QQQ	ETF	39.44	39.8522	39.42	39.6399	12631056.0
2009-07-31 10:00:00	QQQ	ETF	39.64	39.845	39.47	39.78	14339801.0
2009-07-31 11:00:00	QQQ	ETF	39.7899	39.81	39.6701	39.73	7906464.0
2009-07-31 12:00:00	QQQ	ETF	39.73	39.76	39.61	39.66	5553644.0
2009-07-31 13:00:00	QQQ	ETF	39.66	39.76	39.63	39.69	3854883.0
2009-07-31 14:00:00	QQQ	ETF	39.6999	39.79	39.56	39.58	7272869.0
2009-07-31 15:00:00	QQQ	ETF	39.588	39.75	39.41	39.44	17575524.0
2009-07-31 16:00:00	QQQ	ETF	39.44	39.74	39.36	39.44	4397119.0
2009-07-31 17:00:00	QQQ	ETF	39.44	39.45	39.42	39.44	9240.0
2009-07-31 18:00:00	QQQ	ETF	39.44	39.49	39.37	39.4	85479.0
2009-07-31 19:00:00	QQQ	ETF	39.4	39.42	39.39	39.4	7800.0
2009-07-31 06:00:00	IWM	ETF	55.9	55.9	55.9	55.9	3000.0
2009-07-31 07:00:00	IWM	ETF	55.83	55.93	55.82	55.82	41100.0
2009-07-31 08:00:00	IWM	ETF	55.82	56.06	55.31	55.33	1817785.0
2009-07-31 09:00:00	IWM	ETF	55.37	56.13	55.31	55.91	5000251.0
2009-07-31 10:00:00	IWM	ETF	55.91	56.14	55.64	56.01	7489778.0
2009-07-31 11:00:00	IWM	ETF	56.02	56.09	55.9	56.02	2574040.0
2009-07-31 12:00:00	IWM	ETF	56.03	56.1	55.91	55.9794	2114337.0
2009-07-31 13:00:00	IWM	ETF	55.9701	56.14	55.92	56.0898	1664970.0
2009-07-31 14:00:00	IWM	ETF	56.09	56.28	56.02	56.045	3037902.0
2009-07-31 15:00:00	IWM	ETF	56.04	56.28	55.58	55.58	8237066.0
2009-07-31 16:00:00	IWM	ETF	55.58	55.6837	55.28	55.62	6376582.0
2009-07-31 17:00:00	IWM	ETF	55.62	55.63	55.58	55.59	27986.0
2009-07-31 18:00:00	IWM	ETF	55.57	55.57	55.52	55.52	3400.0
2009-07-31 19:00:00	IWM	ETF	55.52	55.56	55.51	55.55	1829.0
2009-07-31 06:00:00	DIA	ETF	91.73	91.73	91.73	91.73	100.0
2009-07-31 07:00:00	DIA	ETF	91.66	91.84	91.66	91.84	2500.0
2009-07-31 08:00:00	DIA	ETF	91.78	92.25	91.19	91.21	100458.0
2009-07-31 09:00:00	DIA	ETF	91.24	92.19	91.19	91.78	2008356.0
2009-07-31 10:00:00	DIA	ETF	91.78	92.12	91.36	91.92	2153599.0

> showing 50 of 4,305 rows — these rows as CSV

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