PREVIEW / etf_1hour / 2010-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-07.parquet
  size:    183 KB
  rows:    5,576

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-07 04:00:00	SPY	ETF	123.15	123.6	123.15	123.6	2917.0
2010-12-07 05:00:00	SPY	ETF	123.75	123.92	123.74	123.84	8750.0
2010-12-07 06:00:00	SPY	ETF	123.83	123.9	123.68	123.77	106570.0
2010-12-07 07:00:00	SPY	ETF	123.77	123.9	123.71	123.8	658228.0
2010-12-07 08:00:00	SPY	ETF	123.78	123.97	123.52	123.93	3848256.0
2010-12-07 09:00:00	SPY	ETF	123.93	124.01	122.7597	123.62	26215700.0
2010-12-07 10:00:00	SPY	ETF	123.62	123.67	123.3	123.54	27898619.0
2010-12-07 11:00:00	SPY	ETF	123.54	123.6	123.31	123.37	18497510.0
2010-12-07 12:00:00	SPY	ETF	123.37	123.49	123.18	123.47	14426915.0
2010-12-07 13:00:00	SPY	ETF	123.46	123.68	123.42	123.55	14778076.0
2010-12-07 14:00:00	SPY	ETF	123.56	123.82	123.12	123.19	24325847.0
2010-12-07 15:00:00	SPY	ETF	123.19	123.29	122.76	122.83	51036770.0
2010-12-07 16:00:00	SPY	ETF	122.83	123.91	122.66	122.67	19301423.0
2010-12-07 17:00:00	SPY	ETF	122.66	122.7597	122.44	122.58	3959781.0
2010-12-07 18:00:00	SPY	ETF	122.55	122.75	122.46	122.69	187113.0
2010-12-07 19:00:00	SPY	ETF	122.71	122.89	122.68	122.84	121773.0
2010-12-07 04:00:00	QQQ	ETF	54.0	54.27	54.0	54.27	1000.0
2010-12-07 05:00:00	QQQ	ETF	54.32	54.38	54.3	54.37	7400.0
2010-12-07 06:00:00	QQQ	ETF	54.36	54.4	54.32	54.33	96682.0
2010-12-07 07:00:00	QQQ	ETF	54.34	54.39	54.31	54.38	154023.0
2010-12-07 08:00:00	QQQ	ETF	54.35	54.52	54.32	54.5	986145.0
2010-12-07 09:00:00	QQQ	ETF	54.5	54.53	54.27	54.27	8814164.0
2010-12-07 10:00:00	QQQ	ETF	54.27	54.2725	54.08	54.2199	8836781.0
2010-12-07 11:00:00	QQQ	ETF	54.22	54.245	54.13	54.16	4340498.0
2010-12-07 12:00:00	QQQ	ETF	54.169	54.19	54.1	54.18	2821968.0
2010-12-07 13:00:00	QQQ	ETF	54.1895	54.27	54.16	54.24	3640583.0
2010-12-07 14:00:00	QQQ	ETF	54.2381	54.38	54.07	54.1	5816220.0
2010-12-07 15:00:00	QQQ	ETF	54.09	54.14	53.82	53.87	17565444.0
2010-12-07 16:00:00	QQQ	ETF	53.87	54.1968	53.81	53.84	1915168.0
2010-12-07 17:00:00	QQQ	ETF	53.81	53.84	53.75	53.8	20857.0
2010-12-07 18:00:00	QQQ	ETF	53.79	53.84	53.75	53.81	101326.0
2010-12-07 19:00:00	QQQ	ETF	53.83	53.92	53.83	53.91	43487.0
2010-12-07 04:00:00	IWM	ETF	76.53	76.53	76.53	76.53	258.0
2010-12-07 05:00:00	IWM	ETF	76.82	76.87	76.8	76.87	4500.0
2010-12-07 06:00:00	IWM	ETF	76.8	76.8	76.75	76.77	3200.0
2010-12-07 07:00:00	IWM	ETF	76.77	76.9	76.76	76.85	88900.0
2010-12-07 08:00:00	IWM	ETF	76.85	76.97	76.73	76.95	393636.0
2010-12-07 09:00:00	IWM	ETF	76.96	77.2	76.79	76.82	14516167.0
2010-12-07 10:00:00	IWM	ETF	76.82	76.879	76.572	76.78	7351260.0
2010-12-07 11:00:00	IWM	ETF	76.78	77.04	76.78	76.92	5426249.0
2010-12-07 12:00:00	IWM	ETF	76.92	76.96	76.7099	76.9099	2830162.0
2010-12-07 13:00:00	IWM	ETF	76.9	77.15	76.89	77.11	6136037.0
2010-12-07 14:00:00	IWM	ETF	77.11	77.24	76.71	76.75	5646335.0
2010-12-07 15:00:00	IWM	ETF	76.75	76.85	76.41	76.58	10995315.0
2010-12-07 16:00:00	IWM	ETF	76.58	76.97	76.1925	76.49	1946113.0
2010-12-07 17:00:00	IWM	ETF	76.49	76.49	76.35	76.4	49415.0
2010-12-07 18:00:00	IWM	ETF	76.42	76.46	76.41	76.46	4400.0
2010-12-07 19:00:00	IWM	ETF	76.47	76.55	76.47	76.54	5600.0
2010-12-07 04:00:00	DIA	ETF	114.07	114.49	114.07	114.49	400.0
2010-12-07 06:00:00	DIA	ETF	114.59	114.59	114.56	114.56	400.0

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

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