PREVIEW / etf_1hour / 2010-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-12.parquet
  size:    163 KB
  rows:    5,005

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-08-12 04:00:00	SPY	ETF	109.05	109.2	108.68	108.9	22270.0
2010-08-12 05:00:00	SPY	ETF	108.8	109.08	108.67	108.67	44100.0
2010-08-12 06:00:00	SPY	ETF	108.67	109.02	108.67	108.85	42352.0
2010-08-12 07:00:00	SPY	ETF	108.86	109.04	108.56	108.64	587334.0
2010-08-12 08:00:00	SPY	ETF	108.56	108.84	107.81	108.01	10175801.0
2010-08-12 09:00:00	SPY	ETF	108.01	109.3	107.58	108.35	48182914.0
2010-08-12 10:00:00	SPY	ETF	108.36	108.91	108.25	108.74	35895355.0
2010-08-12 11:00:00	SPY	ETF	108.73	109.0	108.48	108.76	25396910.0
2010-08-12 12:00:00	SPY	ETF	108.76	108.9866	108.58	108.93	12118420.0
2010-08-12 13:00:00	SPY	ETF	108.93	109.0	108.37	108.43	17411104.0
2010-08-12 14:00:00	SPY	ETF	108.42	108.68	108.27	108.58	18139637.0
2010-08-12 15:00:00	SPY	ETF	108.58	109.02	108.48	108.64	44294351.0
2010-08-12 16:00:00	SPY	ETF	108.65	109.2656	108.2015	108.52	16679345.0
2010-08-12 17:00:00	SPY	ETF	108.5	109.2685	108.48	108.53	5106902.0
2010-08-12 18:00:00	SPY	ETF	108.53	108.62	108.5	108.62	60482.0
2010-08-12 19:00:00	SPY	ETF	108.63	108.76	108.62	108.7	127480.0
2010-08-12 04:00:00	QQQ	ETF	45.14	45.18	45.11	45.13	4800.0
2010-08-12 05:00:00	QQQ	ETF	45.13	45.13	45.03	45.03	24400.0
2010-08-12 06:00:00	QQQ	ETF	45.04	45.11	45.04	45.08	16987.0
2010-08-12 07:00:00	QQQ	ETF	45.07	45.14	45.01	45.01	258932.0
2010-08-12 08:00:00	QQQ	ETF	45.23	45.23	44.62	44.69	1131699.0
2010-08-12 09:00:00	QQQ	ETF	44.68	44.96	44.45	44.9	15623878.0
2010-08-12 10:00:00	QQQ	ETF	44.9	45.2	44.867	45.11	13542328.0
2010-08-12 11:00:00	QQQ	ETF	45.105	45.21	45.0	45.12	5541350.0
2010-08-12 12:00:00	QQQ	ETF	45.13	45.21	45.02	45.19	3671095.0
2010-08-12 13:00:00	QQQ	ETF	45.19	45.24	44.91	44.9619	4913314.0
2010-08-12 14:00:00	QQQ	ETF	44.96	45.06	44.86	45.01	6274471.0
2010-08-12 15:00:00	QQQ	ETF	45.01	45.21	44.96	45.04	10421476.0
2010-08-12 16:00:00	QQQ	ETF	45.04	45.1239	44.5	45.02	3485611.0
2010-08-12 17:00:00	QQQ	ETF	45.0	45.04	45.0	45.04	88691.0
2010-08-12 18:00:00	QQQ	ETF	45.03	45.06	45.0	45.06	41074.0
2010-08-12 19:00:00	QQQ	ETF	45.06	45.1	45.06	45.07	52720.0
2010-08-12 04:00:00	IWM	ETF	61.76	61.84	61.76	61.84	200.0
2010-08-12 05:00:00	IWM	ETF	61.75	61.76	61.74	61.74	11800.0
2010-08-12 06:00:00	IWM	ETF	61.87	61.91	61.86	61.86	1900.0
2010-08-12 07:00:00	IWM	ETF	61.8	61.84	61.55	61.6	105490.0
2010-08-12 08:00:00	IWM	ETF	61.62	61.62	60.91	60.96	1680505.0
2010-08-12 09:00:00	IWM	ETF	60.95	61.76	60.73	61.43	9880122.0
2010-08-12 10:00:00	IWM	ETF	61.42	61.95	61.24	61.73	13158806.0
2010-08-12 11:00:00	IWM	ETF	61.735	62.15	61.62	61.86	5588871.0
2010-08-12 12:00:00	IWM	ETF	61.86	61.98	61.66	61.94	4055222.0
2010-08-12 13:00:00	IWM	ETF	61.95	61.99	61.37	61.43	7416115.0
2010-08-12 14:00:00	IWM	ETF	61.43	61.71	61.35	61.63	5888757.0
2010-08-12 15:00:00	IWM	ETF	61.63	62.0	61.55	61.76	9693300.0
2010-08-12 16:00:00	IWM	ETF	61.77	62.0733	61.4258	61.66	3047653.0
2010-08-12 17:00:00	IWM	ETF	61.61	61.73	61.61	61.69	13853.0
2010-08-12 18:00:00	IWM	ETF	61.69	61.7	61.69	61.7	500.0
2010-08-12 19:00:00	IWM	ETF	61.71	61.86	61.71	61.81	7100.0
2010-08-12 04:00:00	DIA	ETF	103.95	104.0	103.95	104.0	2460.0
2010-08-12 07:00:00	DIA	ETF	103.91	103.93	103.6	103.6	5112.0

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

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