PREVIEW / etf_1hour / 2015-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-03.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
2015-08-03 04:00:00	SPY	ETF	210.6	210.7	209.97	210.34	41801.0
2015-08-03 05:00:00	SPY	ETF	210.42	210.56	210.13	210.22	54401.0
2015-08-03 06:00:00	SPY	ETF	210.2	210.52	210.18	210.44	30955.0
2015-08-03 07:00:00	SPY	ETF	210.41	210.59	210.3	210.35	204639.0
2015-08-03 08:00:00	SPY	ETF	210.35	210.58	210.29	210.32	599762.0
2015-08-03 09:00:00	SPY	ETF	210.31	210.61	209.759	210.2697	11392629.0
2015-08-03 10:00:00	SPY	ETF	210.26	210.38	209.58	210.06	17375437.0
2015-08-03 11:00:00	SPY	ETF	210.055	210.43	209.97	210.15	9058192.0
2015-08-03 12:00:00	SPY	ETF	210.15	210.205	208.885	209.005	11431533.0
2015-08-03 13:00:00	SPY	ETF	209.005	209.22	208.65	209.05	11688985.0
2015-08-03 14:00:00	SPY	ETF	209.04	209.7699	208.7	208.89	12656946.0
2015-08-03 15:00:00	SPY	ETF	208.9	209.8	208.85	209.76	26970083.0
2015-08-03 16:00:00	SPY	ETF	209.75	209.82	209.3045	209.793	6620526.0
2015-08-03 17:00:00	SPY	ETF	209.77	209.79	209.62	209.66	488811.0
2015-08-03 18:00:00	SPY	ETF	209.71	209.73	209.58	209.7	48089.0
2015-08-03 19:00:00	SPY	ETF	209.65	209.65	209.36	209.4	67810.0
2015-08-03 04:00:00	QQQ	ETF	112.0	112.0	111.66	111.66	6650.0
2015-08-03 07:00:00	QQQ	ETF	111.98	111.98	111.92	111.92	3000.0
2015-08-03 08:00:00	QQQ	ETF	111.87	112.0	111.6175	111.89	302411.0
2015-08-03 09:00:00	QQQ	ETF	111.88	112.28	111.82	112.17	3481552.0
2015-08-03 10:00:00	QQQ	ETF	112.17	112.2	111.59	111.8186	3362051.0
2015-08-03 11:00:00	QQQ	ETF	111.81	112.15	111.775	112.04	2146680.0
2015-08-03 12:00:00	QQQ	ETF	112.06	112.08	110.97	111.0862	3146584.0
2015-08-03 13:00:00	QQQ	ETF	111.08	111.37	110.861	111.249	3210784.0
2015-08-03 14:00:00	QQQ	ETF	111.245	111.39	111.04	111.215	2117276.0
2015-08-03 15:00:00	QQQ	ETF	111.21	111.66	111.12	111.63	4364787.0
2015-08-03 16:00:00	QQQ	ETF	111.63	111.8899	111.5048	111.67	1530102.0
2015-08-03 17:00:00	QQQ	ETF	111.64	111.65	111.34	111.53	37271.0
2015-08-03 18:00:00	QQQ	ETF	111.55	111.59	111.5	111.57	27329.0
2015-08-03 19:00:00	QQQ	ETF	111.51	111.51	111.42	111.42	12125.0
2015-08-03 06:00:00	IWM	ETF	122.7	122.7	122.7	122.7	100.0
2015-08-03 07:00:00	IWM	ETF	122.85	122.85	122.73	122.73	39400.0
2015-08-03 08:00:00	IWM	ETF	122.73	122.9	122.72	122.79	93282.0
2015-08-03 09:00:00	IWM	ETF	122.81	123.16	122.33	122.99	4017212.0
2015-08-03 10:00:00	IWM	ETF	123.0	123.03	122.08	122.43	5811206.0
2015-08-03 11:00:00	IWM	ETF	122.44	122.75	122.325	122.47	2788384.0
2015-08-03 12:00:00	IWM	ETF	122.4715	122.53	121.54	121.66	3567934.0
2015-08-03 13:00:00	IWM	ETF	121.66	122.035	121.455	121.87	3813785.0
2015-08-03 14:00:00	IWM	ETF	121.86	122.17	121.58	121.89	3167075.0
2015-08-03 15:00:00	IWM	ETF	121.88	122.34	121.76	122.32	4993253.0
2015-08-03 16:00:00	IWM	ETF	122.32	122.4515	122.0801	122.38	2095140.0
2015-08-03 17:00:00	IWM	ETF	122.36	122.36	122.26	122.26	53320.0
2015-08-03 18:00:00	IWM	ETF	122.22	122.22	122.22	122.22	110.0
2015-08-03 08:00:00	DIA	ETF	176.73	176.73	176.73	176.73	300.0
2015-08-03 09:00:00	DIA	ETF	176.83	176.871	175.95	176.23	532996.0
2015-08-03 10:00:00	DIA	ETF	176.27	176.36	175.58	175.91	819241.0
2015-08-03 11:00:00	DIA	ETF	175.93	176.21	175.82	175.96	333798.0
2015-08-03 12:00:00	DIA	ETF	175.98	176.02	174.88	174.9866	631905.0
2015-08-03 13:00:00	DIA	ETF	175.0	175.13	174.735	175.02	495580.0
2015-08-03 14:00:00	DIA	ETF	175.0	175.17	174.79	174.97	466337.0

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

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