PREVIEW / etf_1hour / 2010-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-14.parquet
  size:    174 KB
  rows:    5,320

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-14 04:00:00	SPY	ETF	124.68	124.68	124.59	124.67	1200.0
2010-12-14 05:00:00	SPY	ETF	124.74	124.92	124.74	124.92	32200.0
2010-12-14 06:00:00	SPY	ETF	124.84	124.87	124.75	124.79	68700.0
2010-12-14 07:00:00	SPY	ETF	124.79	124.96	124.76	124.91	397410.0
2010-12-14 08:00:00	SPY	ETF	124.79	124.93	124.52	124.79	2724249.0
2010-12-14 09:00:00	SPY	ETF	124.78	124.899	124.62	124.78	16304710.0
2010-12-14 10:00:00	SPY	ETF	124.78	125.07	124.775	124.86	21116933.0
2010-12-14 11:00:00	SPY	ETF	124.87	125.08	124.84	125.01	9862996.0
2010-12-14 12:00:00	SPY	ETF	125.01	125.11	124.99	125.05	13924275.0
2010-12-14 13:00:00	SPY	ETF	125.06	125.15	125.04	125.08	11743183.0
2010-12-14 14:00:00	SPY	ETF	125.07	125.23	124.72	124.94	24460951.0
2010-12-14 15:00:00	SPY	ETF	124.94	124.98	124.29	124.65	34554286.0
2010-12-14 16:00:00	SPY	ETF	124.65	124.995	124.325	124.64	8343664.0
2010-12-14 17:00:00	SPY	ETF	124.64	124.73	124.64	124.7	86998.0
2010-12-14 18:00:00	SPY	ETF	124.7	124.7	124.5	124.57	124792.0
2010-12-14 19:00:00	SPY	ETF	124.57	124.61	124.45	124.51	120538.0
2010-12-14 04:00:00	QQQ	ETF	54.44	54.44	54.41	54.41	40000.0
2010-12-14 05:00:00	QQQ	ETF	54.43	54.43	54.43	54.43	4622.0
2010-12-14 06:00:00	QQQ	ETF	54.49	54.49	54.45	54.45	1300.0
2010-12-14 07:00:00	QQQ	ETF	54.47	54.53	54.45	54.49	135516.0
2010-12-14 08:00:00	QQQ	ETF	54.48	54.48	54.3	54.42	1225148.0
2010-12-14 09:00:00	QQQ	ETF	54.43	54.52	54.3	54.45	8509202.0
2010-12-14 10:00:00	QQQ	ETF	54.45	54.6	54.44	54.48	8546526.0
2010-12-14 11:00:00	QQQ	ETF	54.48	54.57	54.46	54.5395	2657759.0
2010-12-14 12:00:00	QQQ	ETF	54.54	54.56	54.5	54.51	1709544.0
2010-12-14 13:00:00	QQQ	ETF	54.5	54.61	54.5	54.565	2043650.0
2010-12-14 14:00:00	QQQ	ETF	54.56	54.62	54.42	54.5236	8238325.0
2010-12-14 15:00:00	QQQ	ETF	54.52	54.54	54.23	54.39	12742877.0
2010-12-14 16:00:00	QQQ	ETF	54.39	54.52	54.292	54.292	13887748.0
2010-12-14 17:00:00	QQQ	ETF	54.49	54.51	54.47	54.48	149987.0
2010-12-14 18:00:00	QQQ	ETF	54.49	54.49	54.42	54.42	33434.0
2010-12-14 19:00:00	QQQ	ETF	54.44	54.44	54.33	54.33	8725.0
2010-12-14 05:00:00	IWM	ETF	77.58	77.58	77.58	77.58	328.0
2010-12-14 06:00:00	IWM	ETF	77.64	77.64	77.61	77.61	400.0
2010-12-14 07:00:00	IWM	ETF	77.63	77.72	77.61	77.63	60023.0
2010-12-14 08:00:00	IWM	ETF	77.6	77.67	77.37	77.61	361131.0
2010-12-14 09:00:00	IWM	ETF	77.62	77.72	77.37	77.53	4621312.0
2010-12-14 10:00:00	IWM	ETF	77.52	77.72	77.5	77.6	3479065.0
2010-12-14 11:00:00	IWM	ETF	77.6	77.72	77.56	77.6399	3244893.0
2010-12-14 12:00:00	IWM	ETF	77.64	77.71	77.61	77.64	1808269.0
2010-12-14 13:00:00	IWM	ETF	77.64	77.7	77.59	77.66	3065244.0
2010-12-14 14:00:00	IWM	ETF	77.66	77.67	77.39	77.59	6294242.0
2010-12-14 15:00:00	IWM	ETF	77.59	77.6	77.18	77.32	12678780.0
2010-12-14 16:00:00	IWM	ETF	77.32	77.46	77.31	77.4	2602231.0
2010-12-14 17:00:00	IWM	ETF	77.42	77.5	77.31	77.49	2099824.0
2010-12-14 18:00:00	IWM	ETF	77.42	77.45	77.36	77.36	4800.0
2010-12-14 19:00:00	IWM	ETF	77.37	77.37	77.33	77.33	7200.0
2010-12-14 07:00:00	DIA	ETF	114.7	114.76	114.7	114.76	12000.0
2010-12-14 08:00:00	DIA	ETF	114.68	114.69	114.45	114.63	8762.0
2010-12-14 09:00:00	DIA	ETF	114.58	114.918	114.58	114.87	418812.0

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

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