PREVIEW / etf_1hour / 2009-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-02.parquet
  size:    135 KB
  rows:    4,211

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-03-02 04:00:00	SPY	ETF	72.5	72.8	72.39	72.8	4521.0
2009-03-02 05:00:00	SPY	ETF	72.78	72.78	72.33	72.4	3100.0
2009-03-02 06:00:00	SPY	ETF	72.36	72.45	71.62	72.1	104100.0
2009-03-02 07:00:00	SPY	ETF	72.12	72.33	71.89	72.29	1199006.0
2009-03-02 08:00:00	SPY	ETF	72.28	73.4	72.04	72.36	9826218.0
2009-03-02 09:00:00	SPY	ETF	72.35	72.92	72.19	72.55	41018374.0
2009-03-02 10:00:00	SPY	ETF	72.55	72.89	71.86	71.97	60971724.0
2009-03-02 11:00:00	SPY	ETF	71.96	72.13	71.06	71.24	54493327.0
2009-03-02 12:00:00	SPY	ETF	71.25	71.52	70.97	71.03	52115001.0
2009-03-02 13:00:00	SPY	ETF	71.03	71.44	70.81	71.43	37180519.0
2009-03-02 14:00:00	SPY	ETF	71.43	71.74	71.01	71.1114	49379918.0
2009-03-02 15:00:00	SPY	ETF	71.12	71.75	70.37	70.58	92063327.0
2009-03-02 16:00:00	SPY	ETF	70.67	73.9169	70.45	71.01	16541522.0
2009-03-02 17:00:00	SPY	ETF	71.02	73.93	70.95	70.96	488907.0
2009-03-02 18:00:00	SPY	ETF	70.97	71.15	70.93	71.1	120681.0
2009-03-02 19:00:00	SPY	ETF	71.1	71.34	71.1	71.23	105646.0
2009-03-02 04:00:00	QQQ	ETF	27.11	27.17	27.09	27.16	1750.0
2009-03-02 05:00:00	QQQ	ETF	27.03	27.04	27.02	27.04	2346.0
2009-03-02 06:00:00	QQQ	ETF	26.96	26.97	26.71	26.71	16552.0
2009-03-02 07:00:00	QQQ	ETF	26.87	27.04	26.84	27.03	913519.0
2009-03-02 08:00:00	QQQ	ETF	27.03	27.15	26.76	27.07	2569191.0
2009-03-02 09:00:00	QQQ	ETF	27.06	27.51	27.05	27.32	31665099.0
2009-03-02 10:00:00	QQQ	ETF	27.3213	27.47	26.98	27.03	22731858.0
2009-03-02 11:00:00	QQQ	ETF	27.02	27.11	26.73	26.81	16414169.0
2009-03-02 12:00:00	QQQ	ETF	26.81	26.94	26.65	26.68	17752581.0
2009-03-02 13:00:00	QQQ	ETF	26.67	26.83	26.56	26.821	16294980.0
2009-03-02 14:00:00	QQQ	ETF	26.8216	26.9	26.62	26.67	16184227.0
2009-03-02 15:00:00	QQQ	ETF	26.67	26.7599	26.47	26.61	36214511.0
2009-03-02 16:00:00	QQQ	ETF	26.61	27.5173	26.526	26.75	14204234.0
2009-03-02 17:00:00	QQQ	ETF	26.75	27.53	26.74	27.53	77262.0
2009-03-02 18:00:00	QQQ	ETF	26.74	26.78	26.73	26.77	58240.0
2009-03-02 19:00:00	QQQ	ETF	26.78	26.82	26.76	26.81	54374.0
2009-03-02 06:00:00	IWM	ETF	37.82	37.82	37.63	37.82	3100.0
2009-03-02 07:00:00	IWM	ETF	37.93	38.14	37.84	38.14	56030.0
2009-03-02 08:00:00	IWM	ETF	38.17	38.37	37.69	38.23	206818.0
2009-03-02 09:00:00	IWM	ETF	38.2	38.42	37.96	38.11	8448030.0
2009-03-02 10:00:00	IWM	ETF	38.12	38.35	37.66	37.71	10114363.0
2009-03-02 11:00:00	IWM	ETF	37.71	37.82	37.27	37.36	8194120.0
2009-03-02 12:00:00	IWM	ETF	37.36	37.5	37.135	37.2401	12697846.0
2009-03-02 13:00:00	IWM	ETF	37.24	37.48	37.08	37.46	6029314.0
2009-03-02 14:00:00	IWM	ETF	37.46	37.51	37.11	37.202	7950669.0
2009-03-02 15:00:00	IWM	ETF	37.2	37.76	36.82	36.9	21586149.0
2009-03-02 16:00:00	IWM	ETF	36.91	38.9244	36.74	38.9244	5072354.0
2009-03-02 17:00:00	IWM	ETF	37.11	39.15	37.06	39.15	33436.0
2009-03-02 18:00:00	IWM	ETF	37.06	37.06	37.03	37.03	3925.0
2009-03-02 19:00:00	IWM	ETF	37.14	37.14	37.05	37.05	2240.0
2009-03-02 04:00:00	DIA	ETF	69.46	69.46	69.46	69.46	100.0
2009-03-02 05:00:00	DIA	ETF	69.51	69.51	69.51	69.51	800.0
2009-03-02 06:00:00	DIA	ETF	69.44	69.44	68.93	69.2	7718.0
2009-03-02 07:00:00	DIA	ETF	69.2	69.42	69.07	69.4	20762.0

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

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