PREVIEW / etf_1hour / 2010-12-02

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-02.parquet
  size:    176 KB
  rows:    5,367

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
2010-12-02 04:00:00	SPY	ETF	121.25	121.6	121.25	121.56	6000.0
2010-12-02 05:00:00	SPY	ETF	121.43	121.43	121.33	121.35	11100.0
2010-12-02 06:00:00	SPY	ETF	121.32	121.38	121.21	121.37	37700.0
2010-12-02 07:00:00	SPY	ETF	121.37	121.58	121.33	121.49	685256.0
2010-12-02 08:00:00	SPY	ETF	121.5	121.57	120.8	120.87	6887041.0
2010-12-02 09:00:00	SPY	ETF	120.87	121.79	120.7	121.71	25597804.0
2010-12-02 10:00:00	SPY	ETF	121.78	122.17	121.695	122.143	31415054.0
2010-12-02 11:00:00	SPY	ETF	122.15	122.4	122.05	122.26	21612918.0
2010-12-02 12:00:00	SPY	ETF	122.26	122.43	122.18	122.26	13042504.0
2010-12-02 13:00:00	SPY	ETF	122.26	122.4	122.17	122.33	15299371.0
2010-12-02 14:00:00	SPY	ETF	122.33	122.65	122.31	122.4	19277124.0
2010-12-02 15:00:00	SPY	ETF	122.4	122.65	122.31	122.57	33443975.0
2010-12-02 16:00:00	SPY	ETF	122.56	122.8	121.425	122.73	16462613.0
2010-12-02 17:00:00	SPY	ETF	122.73	122.85	122.65	122.81	2130758.0
2010-12-02 18:00:00	SPY	ETF	122.79	122.79	122.7	122.7	101237.0
2010-12-02 19:00:00	SPY	ETF	122.69	122.77	122.61	122.77	116940.0
2010-12-02 04:00:00	QQQ	ETF	53.27	53.36	53.27	53.36	200.0
2010-12-02 06:00:00	QQQ	ETF	53.32	53.32	53.27	53.27	2925.0
2010-12-02 07:00:00	QQQ	ETF	53.31	53.43	53.3	53.43	83156.0
2010-12-02 08:00:00	QQQ	ETF	53.4	53.43	53.09	53.11	775792.0
2010-12-02 09:00:00	QQQ	ETF	53.09	53.48	53.07	53.48	13657281.0
2010-12-02 10:00:00	QQQ	ETF	53.48	53.61	53.37	53.51	11839813.0
2010-12-02 11:00:00	QQQ	ETF	53.5101	53.67	53.47	53.6399	7205509.0
2010-12-02 12:00:00	QQQ	ETF	53.639	53.7	53.57	53.62	3327482.0
2010-12-02 13:00:00	QQQ	ETF	53.62	53.72	53.59	53.6727	3206164.0
2010-12-02 14:00:00	QQQ	ETF	53.68	53.78	53.6599	53.68	3732438.0
2010-12-02 15:00:00	QQQ	ETF	53.68	53.81	53.67	53.74	9322586.0
2010-12-02 16:00:00	QQQ	ETF	53.73	53.83	53.71	53.8	1221828.0
2010-12-02 17:00:00	QQQ	ETF	53.78	53.84	53.77	53.8	34959.0
2010-12-02 18:00:00	QQQ	ETF	53.8	53.83	53.78	53.79	17353.0
2010-12-02 19:00:00	QQQ	ETF	53.77	53.84	53.76	53.84	19167.0
2010-12-02 04:00:00	IWM	ETF	74.57	74.75	74.57	74.75	5500.0
2010-12-02 06:00:00	IWM	ETF	74.61	74.64	74.57	74.6	2700.0
2010-12-02 07:00:00	IWM	ETF	74.58	74.7	74.56	74.67	262585.0
2010-12-02 08:00:00	IWM	ETF	74.66	74.7	74.23	74.27	764224.0
2010-12-02 09:00:00	IWM	ETF	74.29	74.67	74.19	74.65	7888056.0
2010-12-02 10:00:00	IWM	ETF	74.66	74.99	74.63	74.93	7203680.0
2010-12-02 11:00:00	IWM	ETF	74.92	75.08	74.86	74.919	3396081.0
2010-12-02 12:00:00	IWM	ETF	74.92	75.03	74.76	74.96	3036831.0
2010-12-02 13:00:00	IWM	ETF	74.96	75.0101	74.87	74.931	1991225.0
2010-12-02 14:00:00	IWM	ETF	74.94	75.15	74.93	75.08	2408568.0
2010-12-02 15:00:00	IWM	ETF	75.08	75.29	74.905	75.16	7665233.0
2010-12-02 16:00:00	IWM	ETF	75.15	75.36	74.4161	75.3	2715175.0
2010-12-02 17:00:00	IWM	ETF	75.3	75.34	75.27	75.34	18600.0
2010-12-02 18:00:00	IWM	ETF	75.3	75.33	75.29	75.3	1400.0
2010-12-02 19:00:00	IWM	ETF	75.29	75.33	75.29	75.31	800.0
2010-12-02 04:00:00	DIA	ETF	113.01	113.01	113.01	113.01	100.0
2010-12-02 05:00:00	DIA	ETF	112.89	112.89	112.89	112.89	100.0
2010-12-02 06:00:00	DIA	ETF	112.85	112.85	112.85	112.85	200.0
2010-12-02 07:00:00	DIA	ETF	113.04	113.07	112.99	113.05	3000.0

> showing 50 of 5,367 rows — these rows as CSV

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