PREVIEW / etf_1hour / 2014-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-15.parquet
  size:    244 KB
  rows:    7,718

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
2014-12-15 04:00:00	SPY	ETF	201.52	202.1	201.52	202.1	65635.0
2014-12-15 05:00:00	SPY	ETF	202.08	202.16	201.75	201.89	42046.0
2014-12-15 06:00:00	SPY	ETF	201.89	201.97	201.57	201.85	210821.0
2014-12-15 07:00:00	SPY	ETF	201.75	201.88	201.57	201.66	251412.0
2014-12-15 08:00:00	SPY	ETF	201.77	201.9	201.04	201.51	1591624.0
2014-12-15 09:00:00	SPY	ETF	201.51	202.53	201.48	202.11	20044241.0
2014-12-15 10:00:00	SPY	ETF	202.1	202.11	200.38	200.9965	28416275.0
2014-12-15 11:00:00	SPY	ETF	201.0	201.02	198.78	198.96	35419033.0
2014-12-15 12:00:00	SPY	ETF	198.96	200.9	198.93	200.705	27869435.0
2014-12-15 13:00:00	SPY	ETF	200.71	200.86	199.75	199.97	17694835.0
2014-12-15 14:00:00	SPY	ETF	199.96	200.8	199.67	199.96	20929785.0
2014-12-15 15:00:00	SPY	ETF	199.95	200.47	199.44	199.48	27681297.0
2014-12-15 16:00:00	SPY	ETF	199.48	202.4	199.37	199.52	6198930.0
2014-12-15 17:00:00	SPY	ETF	199.54	199.74	199.51	199.74	350174.0
2014-12-15 18:00:00	SPY	ETF	199.75	199.95	199.67	199.94	262613.0
2014-12-15 19:00:00	SPY	ETF	199.94	200.17	199.84	199.92	241550.0
2014-12-15 04:00:00	QQQ	ETF	102.94	103.37	102.94	103.23	1150.0
2014-12-15 05:00:00	QQQ	ETF	103.4	103.4	103.25	103.25	27500.0
2014-12-15 06:00:00	QQQ	ETF	103.27	103.3	103.15	103.28	31088.0
2014-12-15 07:00:00	QQQ	ETF	103.19	103.3	103.15	103.21	43700.0
2014-12-15 08:00:00	QQQ	ETF	103.18	103.46	102.951	103.05	204022.0
2014-12-15 09:00:00	QQQ	ETF	103.04	103.58	103.01	103.19	5440883.0
2014-12-15 10:00:00	QQQ	ETF	103.18	103.2	102.1801	102.64	9027018.0
2014-12-15 11:00:00	QQQ	ETF	102.63	102.64	101.315	101.38	10243166.0
2014-12-15 12:00:00	QQQ	ETF	101.37	102.47	101.37	102.36	5878743.0
2014-12-15 13:00:00	QQQ	ETF	102.36	102.51	101.71	101.86	4208789.0
2014-12-15 14:00:00	QQQ	ETF	101.85	102.33	101.6822	101.88	5019018.0
2014-12-15 15:00:00	QQQ	ETF	101.87	102.135	101.5	101.64	8258877.0
2014-12-15 16:00:00	QQQ	ETF	101.64	102.28	101.57	101.67	614825.0
2014-12-15 17:00:00	QQQ	ETF	101.68	101.79	101.67	101.72	35817.0
2014-12-15 18:00:00	QQQ	ETF	101.72	101.86	101.72	101.86	28101.0
2014-12-15 19:00:00	QQQ	ETF	101.88	101.99	101.71	101.71	27807.0
2014-12-15 04:00:00	IWM	ETF	114.98	115.12	114.98	115.09	718.0
2014-12-15 05:00:00	IWM	ETF	115.38	115.4	115.37	115.4	1610.0
2014-12-15 06:00:00	IWM	ETF	115.3	115.3	115.24	115.24	200.0
2014-12-15 07:00:00	IWM	ETF	115.01	115.21	115.01	115.1	38798.0
2014-12-15 08:00:00	IWM	ETF	115.02	115.22	114.87	115.0	214403.0
2014-12-15 09:00:00	IWM	ETF	114.95	115.74	114.93	115.28	6068022.0
2014-12-15 10:00:00	IWM	ETF	115.28	115.28	113.95	114.31	8176536.0
2014-12-15 11:00:00	IWM	ETF	114.32	114.37	113.16	113.2	10387498.0
2014-12-15 12:00:00	IWM	ETF	113.2	114.39	113.16	114.32	6772478.0
2014-12-15 13:00:00	IWM	ETF	114.31	114.49	113.57	113.71	5299349.0
2014-12-15 14:00:00	IWM	ETF	113.7	114.17	113.43	113.58	4158307.0
2014-12-15 15:00:00	IWM	ETF	113.57	114.18	113.48	113.54	8218435.0
2014-12-15 16:00:00	IWM	ETF	113.54	113.95	113.44	113.57	8718733.0
2014-12-15 17:00:00	IWM	ETF	113.57	113.69	113.54	113.66	24756.0
2014-12-15 18:00:00	IWM	ETF	113.72	113.84	113.72	113.84	1183.0
2014-12-15 19:00:00	IWM	ETF	113.94	113.94	113.94	113.94	293.0
2014-12-15 06:00:00	DIA	ETF	174.7	174.7	174.7	174.7	150.0
2014-12-15 07:00:00	DIA	ETF	173.7	174.2	173.63	173.63	1918.0

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

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