PREVIEW / etf_1hour / 2011-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-27.parquet
  size:    181 KB
  rows:    5,491

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-04-27 04:00:00	SPY	ETF	134.62	134.73	134.57	134.73	500.0
2011-04-27 05:00:00	SPY	ETF	134.88	135.0	134.86	135.0	650.0
2011-04-27 06:00:00	SPY	ETF	134.92	135.04	134.92	135.0	32750.0
2011-04-27 07:00:00	SPY	ETF	135.01	135.06	134.89	134.93	499255.0
2011-04-27 08:00:00	SPY	ETF	134.93	135.05	134.84	135.03	2670453.0
2011-04-27 09:00:00	SPY	ETF	135.03	135.11	134.83	134.91	13724636.0
2011-04-27 10:00:00	SPY	ETF	134.91	134.92	134.5	134.52	17687100.0
2011-04-27 11:00:00	SPY	ETF	134.53	134.8	134.52	134.7101	10265282.0
2011-04-27 12:00:00	SPY	ETF	134.72	135.06	134.57	134.96	17862515.0
2011-04-27 13:00:00	SPY	ETF	134.96	135.16	134.89	135.14	11531574.0
2011-04-27 14:00:00	SPY	ETF	135.12	135.3	134.87	135.2738	18792580.0
2011-04-27 15:00:00	SPY	ETF	135.28	135.87	135.25	135.62	32330876.0
2011-04-27 16:00:00	SPY	ETF	135.62	135.68	134.66	135.6	14708355.0
2011-04-27 17:00:00	SPY	ETF	135.63	135.65	135.58	135.61	215119.0
2011-04-27 18:00:00	SPY	ETF	135.63	135.65	135.6	135.64	126258.0
2011-04-27 19:00:00	SPY	ETF	135.64	135.64	135.56	135.64	76611.0
2011-04-27 04:00:00	QQQ	ETF	58.81	58.81	58.81	58.81	2000.0
2011-04-27 06:00:00	QQQ	ETF	58.92	59.0	58.92	59.0	27200.0
2011-04-27 07:00:00	QQQ	ETF	58.97	59.01	58.92	58.92	603575.0
2011-04-27 08:00:00	QQQ	ETF	58.92	58.96	58.88	58.96	3902270.0
2011-04-27 09:00:00	QQQ	ETF	58.96	59.02	58.83	58.92	5462576.0
2011-04-27 10:00:00	QQQ	ETF	58.92	58.93	58.66	58.695	5012907.0
2011-04-27 11:00:00	QQQ	ETF	58.6933	58.86	58.69	58.801	2391763.0
2011-04-27 12:00:00	QQQ	ETF	58.8	58.95	58.74	58.94	4955532.0
2011-04-27 13:00:00	QQQ	ETF	58.94	59.0	58.89	58.9784	3731569.0
2011-04-27 14:00:00	QQQ	ETF	58.98	59.09	58.89	59.0885	5232759.0
2011-04-27 15:00:00	QQQ	ETF	59.08	59.29	59.0705	59.23	11660889.0
2011-04-27 16:00:00	QQQ	ETF	59.23	59.25	58.7945	59.18	5264227.0
2011-04-27 17:00:00	QQQ	ETF	59.17	59.22	58.7945	59.2	514621.0
2011-04-27 18:00:00	QQQ	ETF	59.17	59.22	59.17	59.19	42117.0
2011-04-27 19:00:00	QQQ	ETF	59.2	59.2	59.17	59.18	8440.0
2011-04-27 05:00:00	IWM	ETF	85.1	85.22	85.1	85.22	1100.0
2011-04-27 07:00:00	IWM	ETF	85.22	85.27	85.18	85.18	22200.0
2011-04-27 08:00:00	IWM	ETF	85.18	85.21	85.14	85.17	483884.0
2011-04-27 09:00:00	IWM	ETF	85.17	85.37	85.09	85.24	4285748.0
2011-04-27 10:00:00	IWM	ETF	85.24	85.24	84.89	84.98	4900550.0
2011-04-27 11:00:00	IWM	ETF	84.98	85.16	84.91	85.129	2591984.0
2011-04-27 12:00:00	IWM	ETF	85.13	85.3	84.97	85.25	4458124.0
2011-04-27 13:00:00	IWM	ETF	85.24	85.37	85.17	85.37	4132710.0
2011-04-27 14:00:00	IWM	ETF	85.37	85.51	85.14	85.51	5552095.0
2011-04-27 15:00:00	IWM	ETF	85.5	85.77	85.47	85.71	8396098.0
2011-04-27 16:00:00	IWM	ETF	85.72	85.84	85.65	85.77	1918098.0
2011-04-27 17:00:00	IWM	ETF	85.78	85.81	85.78	85.81	400.0
2011-04-27 18:00:00	IWM	ETF	85.76	85.78	85.76	85.78	1700.0
2011-04-27 19:00:00	IWM	ETF	85.81	85.81	85.78	85.78	400.0
2011-04-27 05:00:00	DIA	ETF	125.8	125.85	125.8	125.85	5100.0
2011-04-27 07:00:00	DIA	ETF	125.87	125.87	125.76	125.76	2100.0
2011-04-27 08:00:00	DIA	ETF	125.77	125.8	125.73	125.78	7067.0
2011-04-27 09:00:00	DIA	ETF	125.84	126.05	125.76	125.9135	596877.0
2011-04-27 10:00:00	DIA	ETF	125.91	125.93	125.67	125.69	618200.0

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

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