PREVIEW / etf_1hour / 2010-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-19.parquet
  size:    169 KB
  rows:    5,192

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-05-19 04:00:00	SPY	ETF	111.43	111.61	111.12	111.23	17716.0
2010-05-19 05:00:00	SPY	ETF	111.32	111.43	111.0	111.05	42932.0
2010-05-19 06:00:00	SPY	ETF	111.05	111.38	111.04	111.3	126165.0
2010-05-19 07:00:00	SPY	ETF	111.36	111.7	111.29	111.63	1799886.0
2010-05-19 08:00:00	SPY	ETF	111.61	112.19	111.3667	112.13	8810607.0
2010-05-19 09:00:00	SPY	ETF	112.11	112.77	111.31	112.34	46567587.0
2010-05-19 10:00:00	SPY	ETF	112.35	112.6	110.82	111.58	87880170.0
2010-05-19 11:00:00	SPY	ETF	111.58	111.67	110.36	110.925	53167486.0
2010-05-19 12:00:00	SPY	ETF	110.93	111.82	110.5208	111.82	39884654.0
2010-05-19 13:00:00	SPY	ETF	111.8	112.23	111.47	111.93	37368787.0
2010-05-19 14:00:00	SPY	ETF	111.93	112.29	111.47	111.76	35724601.0
2010-05-19 15:00:00	SPY	ETF	111.77	112.31	111.22	111.79	66308230.0
2010-05-19 16:00:00	SPY	ETF	111.8	112.72	110.863	112.02	14214707.0
2010-05-19 17:00:00	SPY	ETF	112.01	112.03	111.76	111.98	214938.0
2010-05-19 18:00:00	SPY	ETF	112.0	112.05	111.74	111.87	248428.0
2010-05-19 19:00:00	SPY	ETF	111.87	112.12	111.85	112.05	157709.0
2010-05-19 04:00:00	QQQ	ETF	46.03	46.03	46.0	46.0	300.0
2010-05-19 05:00:00	QQQ	ETF	46.05	46.05	45.98	45.98	300.0
2010-05-19 06:00:00	QQQ	ETF	45.95	46.1	45.94	46.08	52379.0
2010-05-19 07:00:00	QQQ	ETF	46.11	46.2	46.05	46.2	194686.0
2010-05-19 08:00:00	QQQ	ETF	46.19	46.45	46.06	46.41	2542634.0
2010-05-19 09:00:00	QQQ	ETF	46.4	46.63	46.22	46.39	20618782.0
2010-05-19 10:00:00	QQQ	ETF	46.39	46.4067	45.64	46.08	34378749.0
2010-05-19 11:00:00	QQQ	ETF	46.08	46.13	45.55	45.7501	23201200.0
2010-05-19 12:00:00	QQQ	ETF	45.75	46.12	45.7	46.11	14505653.0
2010-05-19 13:00:00	QQQ	ETF	46.11	46.31	45.97	46.18	12966855.0
2010-05-19 14:00:00	QQQ	ETF	46.17	46.34	45.94	46.07	13683260.0
2010-05-19 15:00:00	QQQ	ETF	46.06	46.29	45.79	46.07	26800067.0
2010-05-19 16:00:00	QQQ	ETF	46.06	46.15	45.93	46.11	2306571.0
2010-05-19 17:00:00	QQQ	ETF	46.12	46.17	46.05	46.12	111773.0
2010-05-19 18:00:00	QQQ	ETF	46.13	46.13	46.08	46.12	22595.0
2010-05-19 19:00:00	QQQ	ETF	46.13	46.15	46.09	46.15	2631.0
2010-05-19 04:00:00	IWM	ETF	67.99	67.99	67.99	67.99	569.0
2010-05-19 06:00:00	IWM	ETF	67.67	67.76	67.67	67.76	30524.0
2010-05-19 07:00:00	IWM	ETF	67.78	67.93	67.68	67.87	67515.0
2010-05-19 08:00:00	IWM	ETF	67.85	68.22	67.78	68.14	1233212.0
2010-05-19 09:00:00	IWM	ETF	68.17	68.8	67.58	68.2725	11903824.0
2010-05-19 10:00:00	IWM	ETF	68.27	68.3	67.0	67.44	19792292.0
2010-05-19 11:00:00	IWM	ETF	67.44	67.494	66.58	66.92	12166271.0
2010-05-19 12:00:00	IWM	ETF	66.91	67.63	66.88	67.61	12207892.0
2010-05-19 13:00:00	IWM	ETF	67.62	67.97	67.37	67.75	10752890.0
2010-05-19 14:00:00	IWM	ETF	67.75	67.94	67.31	67.58	10111016.0
2010-05-19 15:00:00	IWM	ETF	67.57	67.69	67.1	67.54	20329720.0
2010-05-19 16:00:00	IWM	ETF	67.54	67.7	66.8	67.7	4051991.0
2010-05-19 17:00:00	IWM	ETF	67.7	68.3405	67.52	67.65	576616.0
2010-05-19 18:00:00	IWM	ETF	67.58	67.62	67.58	67.58	3000.0
2010-05-19 19:00:00	IWM	ETF	67.62	67.73	67.62	67.7	5400.0
2010-05-19 04:00:00	DIA	ETF	104.5	104.5	104.5	104.5	150.0
2010-05-19 05:00:00	DIA	ETF	104.59	104.59	104.39	104.39	5800.0
2010-05-19 06:00:00	DIA	ETF	104.46	104.57	104.46	104.57	1400.0

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

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