PREVIEW / etf_1hour / 2018-08-21

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-21.parquet
  size:    310 KB
  rows:    10,098

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-21 04:00:00	SPY	ETF	285.98	286.05	285.9	286.05	8285.0
2018-08-21 05:00:00	SPY	ETF	286.1	286.33	286.06	286.33	13798.0
2018-08-21 06:00:00	SPY	ETF	286.28	286.33	286.21	286.28	7480.0
2018-08-21 07:00:00	SPY	ETF	286.28	286.32	286.17	286.29	98063.0
2018-08-21 08:00:00	SPY	ETF	286.2899	286.2899	286.1	286.14	767972.0
2018-08-21 09:00:00	SPY	ETF	286.14	286.86	286.02	286.825	6489405.0
2018-08-21 10:00:00	SPY	ETF	286.83	286.88	286.56	286.65	8674572.0
2018-08-21 11:00:00	SPY	ETF	286.65	287.0	286.29	286.97	5578895.0
2018-08-21 12:00:00	SPY	ETF	286.97	287.31	286.96	287.22	5106517.0
2018-08-21 13:00:00	SPY	ETF	287.225	287.285	286.98	287.11	6459668.0
2018-08-21 14:00:00	SPY	ETF	287.11	287.14	286.48	286.685	7598456.0
2018-08-21 15:00:00	SPY	ETF	286.68	286.83	286.105	286.25	16933885.0
2018-08-21 16:00:00	SPY	ETF	286.26	286.34	285.13	285.36	7387092.0
2018-08-21 17:00:00	SPY	ETF	285.36	285.45	285.18	285.27	350726.0
2018-08-21 18:00:00	SPY	ETF	285.25	286.34	284.89	284.91	243421.0
2018-08-21 19:00:00	SPY	ETF	284.91	284.95	284.64	284.68	244476.0
2018-08-21 04:00:00	QQQ	ETF	180.01	180.14	180.0	180.14	4492.0
2018-08-21 05:00:00	QQQ	ETF	180.18	180.3	180.17	180.3	14123.0
2018-08-21 06:00:00	QQQ	ETF	180.35	180.39	180.28	180.34	15665.0
2018-08-21 07:00:00	QQQ	ETF	180.29	180.36	180.18	180.31	37518.0
2018-08-21 08:00:00	QQQ	ETF	180.3	180.3	179.92	180.21	70769.0
2018-08-21 09:00:00	QQQ	ETF	180.23	180.88	180.13	180.805	2444647.0
2018-08-21 10:00:00	QQQ	ETF	180.81	180.93	180.6	180.76	2707180.0
2018-08-21 11:00:00	QQQ	ETF	180.76	181.1	180.395	181.07	1909282.0
2018-08-21 12:00:00	QQQ	ETF	181.07	181.44	181.0501	181.3365	1900780.0
2018-08-21 13:00:00	QQQ	ETF	181.34	181.37	181.06	181.07	1995300.0
2018-08-21 14:00:00	QQQ	ETF	181.06	181.1	180.325	180.48	2078700.0
2018-08-21 15:00:00	QQQ	ETF	180.48	180.62	180.15	180.34	5471386.0
2018-08-21 16:00:00	QQQ	ETF	180.35	180.38	179.47	179.63	2169189.0
2018-08-21 17:00:00	QQQ	ETF	179.78	179.78	179.35	179.45	63122.0
2018-08-21 18:00:00	QQQ	ETF	179.45	179.7	179.28	179.28	62265.0
2018-08-21 19:00:00	QQQ	ETF	179.33	179.33	179.02	179.25	116199.0
2018-08-21 04:00:00	IWM	ETF	168.9	169.0	168.9	169.0	1323.0
2018-08-21 05:00:00	IWM	ETF	169.09	169.09	169.09	169.09	221.0
2018-08-21 06:00:00	IWM	ETF	169.07	169.07	169.05	169.05	690.0
2018-08-21 07:00:00	IWM	ETF	169.02	169.07	169.02	169.06	9950.0
2018-08-21 08:00:00	IWM	ETF	169.08	169.08	168.89	168.92	181661.0
2018-08-21 09:00:00	IWM	ETF	168.96	170.29	168.9	170.285	2387085.0
2018-08-21 10:00:00	IWM	ETF	170.29	170.64	170.23	170.49	2808779.0
2018-08-21 11:00:00	IWM	ETF	170.49	170.93	170.2	170.87	2915867.0
2018-08-21 12:00:00	IWM	ETF	170.86	171.31	170.83	171.11	2242109.0
2018-08-21 13:00:00	IWM	ETF	171.1051	171.36	170.95	171.09	1823672.0
2018-08-21 14:00:00	IWM	ETF	171.09	171.31	170.735	170.85	2256386.0
2018-08-21 15:00:00	IWM	ETF	170.85	170.97	170.72	170.73	2991791.0
2018-08-21 16:00:00	IWM	ETF	170.74	170.76	170.04	170.23	602007.0
2018-08-21 17:00:00	IWM	ETF	170.37	170.37	170.04	170.17	8547.0
2018-08-21 18:00:00	IWM	ETF	170.18	170.21	169.97	169.97	29415.0
2018-08-21 19:00:00	IWM	ETF	169.81	169.99	169.77	169.87	12630.0
2018-08-21 04:00:00	DIA	ETF	257.75	257.75	257.75	257.75	100.0
2018-08-21 05:00:00	DIA	ETF	257.95	257.95	257.92	257.94	1200.0

> showing 50 of 10,098 rows — these rows as CSV

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