PREVIEW / etf_1hour / 2018-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-17.parquet
  size:    306 KB
  rows:    9,910

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
2018-08-17 04:00:00	SPY	ETF	284.3	284.57	284.25	284.4	16132.0
2018-08-17 05:00:00	SPY	ETF	284.35	284.35	283.79	283.79	24276.0
2018-08-17 06:00:00	SPY	ETF	283.77	284.06	283.7	284.06	22864.0
2018-08-17 07:00:00	SPY	ETF	284.08	284.19	283.88	283.88	112313.0
2018-08-17 08:00:00	SPY	ETF	283.96	284.04	283.4	283.88	604978.0
2018-08-17 09:00:00	SPY	ETF	283.91	284.27	283.56	283.91	4988118.0
2018-08-17 10:00:00	SPY	ETF	283.91	284.0101	283.37	283.87	6174088.0
2018-08-17 11:00:00	SPY	ETF	283.87	284.68	283.66	284.605	6203709.0
2018-08-17 12:00:00	SPY	ETF	284.6	284.62	284.09	284.11	3808737.0
2018-08-17 13:00:00	SPY	ETF	284.12	284.535	284.01	284.45	7292638.0
2018-08-17 14:00:00	SPY	ETF	284.45	285.5601	284.42	285.47	13497193.0
2018-08-17 15:00:00	SPY	ETF	285.47	285.51	284.9	285.02	12290438.0
2018-08-17 16:00:00	SPY	ETF	285.03	285.2	284.9	285.18	8271395.0
2018-08-17 17:00:00	SPY	ETF	285.2	285.22	284.92	284.92	96222.0
2018-08-17 18:00:00	SPY	ETF	285.04	285.14	284.95	285.05	62543.0
2018-08-17 19:00:00	SPY	ETF	285.04	285.13	284.96	285.06	7166.0
2018-08-17 04:00:00	QQQ	ETF	179.85	180.01	179.85	179.89	5478.0
2018-08-17 05:00:00	QQQ	ETF	179.86	179.86	179.45	179.5	37942.0
2018-08-17 06:00:00	QQQ	ETF	179.44	179.61	179.31	179.6	19744.0
2018-08-17 07:00:00	QQQ	ETF	179.6	179.72	179.48	179.52	44135.0
2018-08-17 08:00:00	QQQ	ETF	179.82	179.82	179.13	179.43	196190.0
2018-08-17 09:00:00	QQQ	ETF	179.39	179.73	178.9148	179.11	3875342.0
2018-08-17 10:00:00	QQQ	ETF	179.11	179.24	178.2679	178.67	4938859.0
2018-08-17 11:00:00	QQQ	ETF	178.67	179.6	178.47	179.5327	2916715.0
2018-08-17 12:00:00	QQQ	ETF	179.54	179.56	178.9	178.9766	2134655.0
2018-08-17 13:00:00	QQQ	ETF	178.97	179.375	178.94	179.31	1690918.0
2018-08-17 14:00:00	QQQ	ETF	179.32	180.31	179.27	180.2	5084218.0
2018-08-17 15:00:00	QQQ	ETF	180.19	180.23	179.79	179.87	6438257.0
2018-08-17 16:00:00	QQQ	ETF	179.87	179.94	179.05	179.89	993189.0
2018-08-17 17:00:00	QQQ	ETF	179.84	179.88	179.76	179.85	11470.0
2018-08-17 18:00:00	QQQ	ETF	179.89	179.93	179.83	179.91	9776.0
2018-08-17 19:00:00	QQQ	ETF	179.85	179.88	179.79	179.88	10808.0
2018-08-17 04:00:00	IWM	ETF	167.75	167.92	167.75	167.92	300.0
2018-08-17 05:00:00	IWM	ETF	167.68	167.68	167.65	167.65	300.0
2018-08-17 06:00:00	IWM	ETF	167.5	167.5	167.5	167.5	100.0
2018-08-17 07:00:00	IWM	ETF	167.52	167.57	167.5	167.5	2480.0
2018-08-17 08:00:00	IWM	ETF	167.46	167.62	167.25	167.62	36760.0
2018-08-17 09:00:00	IWM	ETF	167.39	167.61	166.93	167.42	1516098.0
2018-08-17 10:00:00	IWM	ETF	167.41	167.58	166.96	167.24	1629474.0
2018-08-17 11:00:00	IWM	ETF	167.25	167.93	167.07	167.915	1103330.0
2018-08-17 12:00:00	IWM	ETF	167.92	167.97	167.695	167.7	771079.0
2018-08-17 13:00:00	IWM	ETF	167.7	167.98	167.6501	167.9334	697349.0
2018-08-17 14:00:00	IWM	ETF	167.93	168.47	167.91	168.45	2407685.0
2018-08-17 15:00:00	IWM	ETF	168.46	168.46	168.15	168.38	3569383.0
2018-08-17 16:00:00	IWM	ETF	168.36	168.59	168.0214	168.58	1247622.0
2018-08-17 17:00:00	IWM	ETF	168.54	168.55	168.35	168.51	117580.0
2018-08-17 18:00:00	IWM	ETF	168.53	168.53	168.5	168.5	1300.0
2018-08-17 19:00:00	IWM	ETF	168.58	168.6	168.53	168.53	4129.0
2018-08-17 05:00:00	DIA	ETF	255.79	255.79	255.5	255.5	250.0
2018-08-17 07:00:00	DIA	ETF	255.54	255.7	255.33	255.33	3577.0

> showing 50 of 9,910 rows — these rows as CSV

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