PREVIEW / etf_1hour / 2011-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-20.parquet
  size:    177 KB
  rows:    5,389

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
2011-05-20 04:00:00	SPY	ETF	134.7	134.8	134.7	134.8	1500.0
2011-05-20 06:00:00	SPY	ETF	134.68	134.68	134.23	134.32	41275.0
2011-05-20 07:00:00	SPY	ETF	134.29	134.32	134.15	134.3	554099.0
2011-05-20 08:00:00	SPY	ETF	134.3	134.46	134.23	134.43	1551228.0
2011-05-20 09:00:00	SPY	ETF	134.43	134.49	133.8	133.89	20523643.0
2011-05-20 10:00:00	SPY	ETF	133.89	134.5744	133.36	133.51	36656209.0
2011-05-20 11:00:00	SPY	ETF	133.5294	134.0	133.46	133.7	18014956.0
2011-05-20 12:00:00	SPY	ETF	133.71	134.4	133.66	134.12	21701718.0
2011-05-20 13:00:00	SPY	ETF	134.125	134.52	134.12	134.3	11711491.0
2011-05-20 14:00:00	SPY	ETF	134.3	134.39	133.98	134.0	10617542.0
2011-05-20 15:00:00	SPY	ETF	133.99	134.09	133.5	133.62	32292700.0
2011-05-20 16:00:00	SPY	ETF	133.64	134.6781	133.22	133.4	24639179.0
2011-05-20 17:00:00	SPY	ETF	133.41	133.53	133.28	133.32	339711.0
2011-05-20 18:00:00	SPY	ETF	133.28	133.67	133.23	133.32	163535.0
2011-05-20 19:00:00	SPY	ETF	133.27	133.33	133.23	133.33	30682.0
2011-05-20 04:00:00	QQQ	ETF	58.17	58.17	58.17	58.17	100.0
2011-05-20 06:00:00	QQQ	ETF	58.15	58.15	58.15	58.15	300.0
2011-05-20 07:00:00	QQQ	ETF	58.06	58.09	57.99	58.04	16963.0
2011-05-20 08:00:00	QQQ	ETF	58.09	58.15	58.06	58.13	199242.0
2011-05-20 09:00:00	QQQ	ETF	58.13	58.21	57.93	57.95	5712654.0
2011-05-20 10:00:00	QQQ	ETF	57.96	57.9794	57.69	57.745	7403946.0
2011-05-20 11:00:00	QQQ	ETF	57.74	57.84	57.72	57.751	3718441.0
2011-05-20 12:00:00	QQQ	ETF	57.75	58.11	57.74	57.97	6001388.0
2011-05-20 13:00:00	QQQ	ETF	57.97	58.19	57.97	58.1	3369580.0
2011-05-20 14:00:00	QQQ	ETF	58.105	58.14	57.9	57.9	1614151.0
2011-05-20 15:00:00	QQQ	ETF	57.91	57.94	57.72	57.79	7897276.0
2011-05-20 16:00:00	QQQ	ETF	57.76	57.795	57.58	57.72	4869159.0
2011-05-20 17:00:00	QQQ	ETF	57.71	57.75	57.65	57.65	49586.0
2011-05-20 18:00:00	QQQ	ETF	57.65	57.65	57.58	57.6	11975.0
2011-05-20 19:00:00	QQQ	ETF	57.58	57.61	57.57	57.58	4098.0
2011-05-20 05:00:00	IWM	ETF	83.73	83.73	83.73	83.73	100.0
2011-05-20 06:00:00	IWM	ETF	83.28	83.28	83.19	83.19	1400.0
2011-05-20 07:00:00	IWM	ETF	83.19	83.31	83.13	83.28	45000.0
2011-05-20 08:00:00	IWM	ETF	83.28	83.42	83.19	83.4	1120900.0
2011-05-20 09:00:00	IWM	ETF	83.41	83.43	82.75	82.841	5645527.0
2011-05-20 10:00:00	IWM	ETF	82.84	82.89	82.3	82.44	12041861.0
2011-05-20 11:00:00	IWM	ETF	82.43	82.815	82.385	82.57	4597335.0
2011-05-20 12:00:00	IWM	ETF	82.56	83.22	82.56	83.01	6429047.0
2011-05-20 13:00:00	IWM	ETF	83.0	83.45	82.99	83.29	4711466.0
2011-05-20 14:00:00	IWM	ETF	83.29	83.35	83.01	83.02	2887481.0
2011-05-20 15:00:00	IWM	ETF	83.02	83.2	82.82	82.85	8629768.0
2011-05-20 16:00:00	IWM	ETF	82.86	82.92	82.3387	82.64	3090307.0
2011-05-20 17:00:00	IWM	ETF	82.64	82.67	82.61	82.63	5561.0
2011-05-20 18:00:00	IWM	ETF	82.65	82.67	82.6	82.6	2100.0
2011-05-20 19:00:00	IWM	ETF	82.63	82.64	82.58	82.58	1700.0
2011-05-20 05:00:00	DIA	ETF	125.98	125.98	125.73	125.73	2500.0
2011-05-20 06:00:00	DIA	ETF	125.78	125.78	125.41	125.41	2800.0
2011-05-20 07:00:00	DIA	ETF	125.44	125.48	125.42	125.45	8350.0
2011-05-20 08:00:00	DIA	ETF	125.51	125.61	125.47	125.61	54200.0
2011-05-20 09:00:00	DIA	ETF	125.61	125.67	124.96	125.0699	835619.0

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

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