PREVIEW / etf_1hour / 2016-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-10.parquet
  size:    250 KB
  rows:    7,965

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
2016-03-10 04:00:00	SPY	ETF	199.93	200.13	199.69	199.72	42901.0
2016-03-10 05:00:00	SPY	ETF	199.6	199.94	199.59	199.78	19753.0
2016-03-10 06:00:00	SPY	ETF	199.76	200.22	199.72	200.01	41765.0
2016-03-10 07:00:00	SPY	ETF	200.07	201.59	200.0	201.41	2503939.0
2016-03-10 08:00:00	SPY	ETF	201.39	201.49	199.41	200.74	3219547.0
2016-03-10 09:00:00	SPY	ETF	200.73	200.89	199.6	200.79	19354670.0
2016-03-10 10:00:00	SPY	ETF	200.8	201.07	199.01	199.095	24657812.0
2016-03-10 11:00:00	SPY	ETF	199.11	199.27	198.01	198.58	25836054.0
2016-03-10 12:00:00	SPY	ETF	198.58	198.94	197.45	197.885	18132535.0
2016-03-10 13:00:00	SPY	ETF	197.88	198.38	197.38	198.07	14323794.0
2016-03-10 14:00:00	SPY	ETF	198.07	199.32	197.74	198.95	13711642.0
2016-03-10 15:00:00	SPY	ETF	198.958	199.83	198.74	199.54	23999649.0
2016-03-10 16:00:00	SPY	ETF	199.54	199.78	199.43	199.6	6227403.0
2016-03-10 17:00:00	SPY	ETF	199.66	199.66	199.49	199.49	101065.0
2016-03-10 18:00:00	SPY	ETF	199.49	199.88	199.38	199.52	142178.0
2016-03-10 19:00:00	SPY	ETF	199.56	199.67	199.46	199.62	76339.0
2016-03-10 04:00:00	QQQ	ETF	105.0	105.0	105.0	105.0	100.0
2016-03-10 05:00:00	QQQ	ETF	104.96	104.96	104.96	104.96	339.0
2016-03-10 06:00:00	QQQ	ETF	104.95	105.18	104.95	105.17	2502.0
2016-03-10 07:00:00	QQQ	ETF	105.15	106.15	105.15	106.07	107311.0
2016-03-10 08:00:00	QQQ	ETF	106.03	106.06	105.28	105.65	332804.0
2016-03-10 09:00:00	QQQ	ETF	105.65	105.82	104.99	105.78	5698202.0
2016-03-10 10:00:00	QQQ	ETF	105.7701	105.86	104.5399	104.58	6669546.0
2016-03-10 11:00:00	QQQ	ETF	104.59	104.7	103.98	104.33	5538728.0
2016-03-10 12:00:00	QQQ	ETF	104.33	104.57	103.47	103.7	4560588.0
2016-03-10 13:00:00	QQQ	ETF	103.68	103.8835	103.31	103.6395	3548433.0
2016-03-10 14:00:00	QQQ	ETF	103.64	104.63	103.5	104.439	3615211.0
2016-03-10 15:00:00	QQQ	ETF	104.43	104.97	104.27	104.6801	5286063.0
2016-03-10 16:00:00	QQQ	ETF	104.68	104.86	104.64	104.76	1778576.0
2016-03-10 17:00:00	QQQ	ETF	104.73	104.73	104.66	104.66	4878.0
2016-03-10 18:00:00	QQQ	ETF	104.68	104.8	104.6	104.69	17532.0
2016-03-10 19:00:00	QQQ	ETF	104.66	104.75	104.64	104.72	5808.0
2016-03-10 07:00:00	IWM	ETF	107.22	108.04	107.21	107.97	245183.0
2016-03-10 08:00:00	IWM	ETF	107.32	108.0	107.32	107.58	330848.0
2016-03-10 09:00:00	IWM	ETF	107.58	107.66	106.91	107.28	5224177.0
2016-03-10 10:00:00	IWM	ETF	107.28	107.35	106.04	106.1	7568118.0
2016-03-10 11:00:00	IWM	ETF	106.11	106.14	105.28	105.63	6842247.0
2016-03-10 12:00:00	IWM	ETF	105.63	105.83	105.02	105.25	4687628.0
2016-03-10 13:00:00	IWM	ETF	105.25	105.595	104.81	105.4	4299770.0
2016-03-10 14:00:00	IWM	ETF	105.4	105.98	105.005	105.78	4557546.0
2016-03-10 15:00:00	IWM	ETF	105.77	106.15	105.605	105.94	7095213.0
2016-03-10 16:00:00	IWM	ETF	105.93	106.02	105.82	105.93	2326298.0
2016-03-10 17:00:00	IWM	ETF	105.92	106.8	105.88	105.95	34603.0
2016-03-10 18:00:00	IWM	ETF	105.87	105.95	105.87	105.95	2813.0
2016-03-10 19:00:00	IWM	ETF	105.97	105.97	105.88	105.93	7707.0
2016-03-10 07:00:00	DIA	ETF	170.87	171.97	170.71	171.97	5138.0
2016-03-10 08:00:00	DIA	ETF	171.59	171.65	170.86	171.06	26468.0
2016-03-10 09:00:00	DIA	ETF	171.17	171.27	170.25	171.17	613926.0
2016-03-10 10:00:00	DIA	ETF	171.17	171.4	169.63	169.68	911936.0
2016-03-10 11:00:00	DIA	ETF	169.67	169.74	168.661	169.23	802275.0

> showing 50 of 7,965 rows — these rows as CSV

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