PREVIEW / etf_1hour / 2009-04-02

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-02.parquet
  size:    137 KB
  rows:    4,237

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-04-02 04:00:00	SPY	ETF	82.91	82.97	82.75	82.77	4200.0
2009-04-02 05:00:00	SPY	ETF	82.85	83.2	82.85	83.2	7102.0
2009-04-02 06:00:00	SPY	ETF	83.24	83.31	82.92	82.99	250346.0
2009-04-02 07:00:00	SPY	ETF	82.94	83.07	82.43	82.85	1609801.0
2009-04-02 08:00:00	SPY	ETF	82.83	83.12	82.48	82.7	8909456.0
2009-04-02 09:00:00	SPY	ETF	82.7	83.39	82.67	83.37	49403834.0
2009-04-02 10:00:00	SPY	ETF	83.37	83.71	83.01	83.66	75322712.0
2009-04-02 11:00:00	SPY	ETF	83.66	84.25	83.618	84.03	57741793.0
2009-04-02 12:00:00	SPY	ETF	84.03	84.61	83.87	84.17	46208686.0
2009-04-02 13:00:00	SPY	ETF	84.18	84.25	83.51	83.68	50166805.0
2009-04-02 14:00:00	SPY	ETF	83.68	84.46	83.58	84.03	46911379.0
2009-04-02 15:00:00	SPY	ETF	84.03	84.24	83.02	83.41	92556212.0
2009-04-02 16:00:00	SPY	ETF	83.43	84.09	82.84	83.95	32588054.0
2009-04-02 17:00:00	SPY	ETF	83.98	84.07	83.93	84.0	231637.0
2009-04-02 18:00:00	SPY	ETF	84.02	84.02	83.84	83.89	148800.0
2009-04-02 19:00:00	SPY	ETF	83.89	83.97	83.83	83.92	45738.0
2009-04-02 04:00:00	QQQ	ETF	31.35	31.35	31.3	31.3	901.0
2009-04-02 05:00:00	QQQ	ETF	31.4	31.53	31.4	31.52	44100.0
2009-04-02 06:00:00	QQQ	ETF	31.56	31.6	31.43	31.45	352742.0
2009-04-02 07:00:00	QQQ	ETF	31.42	31.5	31.32	31.37	796474.0
2009-04-02 08:00:00	QQQ	ETF	31.36	31.46	31.19	31.3	3240133.0
2009-04-02 09:00:00	QQQ	ETF	31.29	31.6	31.23	31.6	27266386.0
2009-04-02 10:00:00	QQQ	ETF	31.6	31.89	31.54	31.87	34719331.0
2009-04-02 11:00:00	QQQ	ETF	31.87	32.11	31.86	32.0301	21098964.0
2009-04-02 12:00:00	QQQ	ETF	32.04	32.27	31.68	32.1	18062540.0
2009-04-02 13:00:00	QQQ	ETF	32.11	32.12	31.6657	31.9126	25383103.0
2009-04-02 14:00:00	QQQ	ETF	31.9	32.18	31.86	32.03	16880762.0
2009-04-02 15:00:00	QQQ	ETF	32.03	32.11	31.61	31.76	38337312.0
2009-04-02 16:00:00	QQQ	ETF	31.77	32.11	31.5	32.07	10912506.0
2009-04-02 17:00:00	QQQ	ETF	32.07	32.12	32.07	32.08	344260.0
2009-04-02 18:00:00	QQQ	ETF	32.09	32.1	32.05	32.07	227938.0
2009-04-02 19:00:00	QQQ	ETF	32.07	32.11	32.05	32.09	38705.0
2009-04-02 06:00:00	IWM	ETF	44.03	44.03	43.85	43.92	5405.0
2009-04-02 07:00:00	IWM	ETF	43.93	43.93	43.57	43.84	71169.0
2009-04-02 08:00:00	IWM	ETF	43.92	44.0	43.62	43.8	297137.0
2009-04-02 09:00:00	IWM	ETF	43.8	44.5	43.79	44.45	10050294.0
2009-04-02 10:00:00	IWM	ETF	44.45	44.97	44.27	44.95	11880863.0
2009-04-02 11:00:00	IWM	ETF	44.95	45.39	44.93	45.1	12167480.0
2009-04-02 12:00:00	IWM	ETF	45.1	45.57	43.9	45.33	14297233.0
2009-04-02 13:00:00	IWM	ETF	45.33	45.37	44.84	44.97	9375238.0
2009-04-02 14:00:00	IWM	ETF	44.98	45.43	44.94	45.15	9306252.0
2009-04-02 15:00:00	IWM	ETF	45.16	45.51	44.5	44.9	14204219.0
2009-04-02 16:00:00	IWM	ETF	44.9	45.39	42.8943	45.2	4261466.0
2009-04-02 17:00:00	IWM	ETF	45.19	45.2	45.14	45.18	6918.0
2009-04-02 18:00:00	IWM	ETF	45.18	45.18	45.06	45.06	2059.0
2009-04-02 19:00:00	IWM	ETF	45.04	45.04	44.91	44.98	5300.0
2009-04-02 04:00:00	DIA	ETF	78.0	78.9	78.0	78.9	700.0
2009-04-02 05:00:00	DIA	ETF	79.28	79.28	79.28	79.28	100.0
2009-04-02 06:00:00	DIA	ETF	79.28	79.28	79.28	79.28	2000.0
2009-04-02 07:00:00	DIA	ETF	79.12	79.24	78.74	79.1	31562.0

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

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