PREVIEW / etf_1hour / 2015-12-03

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-03.parquet
  size:    251 KB
  rows:    7,961

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
2015-12-03 04:00:00	SPY	ETF	209.54	210.01	209.37	209.83	73999.0
2015-12-03 05:00:00	SPY	ETF	209.92	210.23	209.83	210.16	89453.0
2015-12-03 06:00:00	SPY	ETF	210.12	210.17	209.96	209.97	53095.0
2015-12-03 07:00:00	SPY	ETF	209.98	210.05	209.09	209.5	1548530.0
2015-12-03 08:00:00	SPY	ETF	209.51	210.02	207.94	208.9	3989169.0
2015-12-03 09:00:00	SPY	ETF	208.84	209.47	207.93	208.12	18057182.0
2015-12-03 10:00:00	SPY	ETF	208.1038	208.11	207.24	207.76	19989353.0
2015-12-03 11:00:00	SPY	ETF	207.76	208.38	207.5	207.76	11112403.0
2015-12-03 12:00:00	SPY	ETF	207.74	207.8	206.44	206.5953	17342295.0
2015-12-03 13:00:00	SPY	ETF	206.59	207.0399	205.84	205.855	14087015.0
2015-12-03 14:00:00	SPY	ETF	205.855	205.92	204.7511	205.54	28344565.0
2015-12-03 15:00:00	SPY	ETF	205.54	205.7499	204.8	205.6	38351239.0
2015-12-03 16:00:00	SPY	ETF	205.58	206.16	205.4247	206.08	9582703.0
2015-12-03 17:00:00	SPY	ETF	206.08	206.1	205.58	206.03	1595049.0
2015-12-03 18:00:00	SPY	ETF	206.07	206.47	206.0	206.0	709996.0
2015-12-03 19:00:00	SPY	ETF	206.1	206.4	206.1	206.37	151888.0
2015-12-03 04:00:00	QQQ	ETF	114.92	115.38	114.92	115.37	1610.0
2015-12-03 05:00:00	QQQ	ETF	115.33	115.52	115.33	115.46	1600.0
2015-12-03 06:00:00	QQQ	ETF	115.46	115.5	115.39	115.39	3900.0
2015-12-03 07:00:00	QQQ	ETF	115.37	115.4	114.93	115.15	104019.0
2015-12-03 08:00:00	QQQ	ETF	115.12	115.39	114.2	114.75	452250.0
2015-12-03 09:00:00	QQQ	ETF	114.74	115.07	114.22	114.39	4764116.0
2015-12-03 10:00:00	QQQ	ETF	114.38	114.5	113.79	114.12	4882284.0
2015-12-03 11:00:00	QQQ	ETF	114.115	114.6211	113.92	114.07	2954024.0
2015-12-03 12:00:00	QQQ	ETF	114.05	114.1087	112.91	112.94	5102544.0
2015-12-03 13:00:00	QQQ	ETF	112.94	113.17	112.46	112.465	3550488.0
2015-12-03 14:00:00	QQQ	ETF	112.475	114.4411	111.8432	112.41	7723118.0
2015-12-03 15:00:00	QQQ	ETF	112.41	114.4411	112.025	112.54	7383200.0
2015-12-03 16:00:00	QQQ	ETF	112.54	112.79	112.155	112.78	688828.0
2015-12-03 17:00:00	QQQ	ETF	112.75	112.8	112.72	112.74	55964.0
2015-12-03 18:00:00	QQQ	ETF	112.78	112.95	112.73	112.75	48192.0
2015-12-03 19:00:00	QQQ	ETF	112.8	112.9	112.8	112.9	6000.0
2015-12-03 05:00:00	IWM	ETF	119.41	119.41	119.41	119.41	100.0
2015-12-03 06:00:00	IWM	ETF	119.54	119.54	119.54	119.54	200.0
2015-12-03 07:00:00	IWM	ETF	119.4	119.43	118.91	119.06	149512.0
2015-12-03 08:00:00	IWM	ETF	119.09	119.26	118.3	118.8	466941.0
2015-12-03 09:00:00	IWM	ETF	118.76	119.45	118.49	118.61	3771915.0
2015-12-03 10:00:00	IWM	ETF	118.61	118.71	117.81	118.46	6365393.0
2015-12-03 11:00:00	IWM	ETF	118.47	118.9175	118.285	118.46	3067917.0
2015-12-03 12:00:00	IWM	ETF	118.46	118.48	117.53	117.675	3490612.0
2015-12-03 13:00:00	IWM	ETF	117.67	118.0399	116.92	116.93	3417884.0
2015-12-03 14:00:00	IWM	ETF	116.92	116.94	116.14	116.78	6848703.0
2015-12-03 15:00:00	IWM	ETF	116.78	116.9	116.29	116.61	6977386.0
2015-12-03 16:00:00	IWM	ETF	116.61	118.8605	116.56	116.79	2401816.0
2015-12-03 17:00:00	IWM	ETF	116.81	116.81	116.81	116.81	1000.0
2015-12-03 18:00:00	IWM	ETF	116.88	116.88	116.88	116.88	100.0
2015-12-03 19:00:00	IWM	ETF	116.85	116.95	116.85	116.95	1500.0
2015-12-03 04:00:00	DIA	ETF	178.52	178.52	178.52	178.52	300.0
2015-12-03 05:00:00	DIA	ETF	178.72	178.72	178.72	178.72	100.0
2015-12-03 07:00:00	DIA	ETF	178.46	178.53	178.33	178.33	300.0

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

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