PREVIEW / etf_1hour / 2018-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-09.parquet
  size:    295 KB
  rows:    9,673

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-09 04:00:00	SPY	ETF	285.28	285.45	285.23	285.45	6602.0
2018-08-09 05:00:00	SPY	ETF	285.46	285.49	285.39	285.41	12500.0
2018-08-09 06:00:00	SPY	ETF	285.44	285.7	285.35	285.39	15302.0
2018-08-09 07:00:00	SPY	ETF	285.39	285.59	285.35	285.59	45827.0
2018-08-09 08:00:00	SPY	ETF	285.38	285.59	285.2	285.58	1081819.0
2018-08-09 09:00:00	SPY	ETF	285.6	285.71	285.32	285.5098	3548535.0
2018-08-09 10:00:00	SPY	ETF	285.5	285.97	285.465	285.73	4891837.0
2018-08-09 11:00:00	SPY	ETF	285.74	285.925	285.21	285.345	4572797.0
2018-08-09 12:00:00	SPY	ETF	285.35	285.77	285.32	285.72	2902943.0
2018-08-09 13:00:00	SPY	ETF	285.72	285.86	285.59	285.79	1907132.0
2018-08-09 14:00:00	SPY	ETF	285.78	285.79	285.55	285.605	2839814.0
2018-08-09 15:00:00	SPY	ETF	285.61	285.65	284.915	285.06	9782615.0
2018-08-09 16:00:00	SPY	ETF	285.05	285.6686	284.76	284.93	3413639.0
2018-08-09 17:00:00	SPY	ETF	284.97	285.0	284.83	284.86	70994.0
2018-08-09 18:00:00	SPY	ETF	284.89	284.98	284.7	284.76	86365.0
2018-08-09 19:00:00	SPY	ETF	284.74	284.92	284.74	284.82	26379.0
2018-08-09 04:00:00	QQQ	ETF	181.79	181.92	181.74	181.92	10191.0
2018-08-09 05:00:00	QQQ	ETF	181.93	182.02	181.88	181.94	8570.0
2018-08-09 06:00:00	QQQ	ETF	181.94	182.2	181.83	181.85	17611.0
2018-08-09 07:00:00	QQQ	ETF	181.85	181.99	181.79	181.89	79548.0
2018-08-09 08:00:00	QQQ	ETF	181.9601	182.09	181.82	181.91	94368.0
2018-08-09 09:00:00	QQQ	ETF	181.95	182.23	181.64	181.9459	2606131.0
2018-08-09 10:00:00	QQQ	ETF	181.95	182.53	181.92	182.26	2349073.0
2018-08-09 11:00:00	QQQ	ETF	182.27	182.44	181.98	182.11	1935447.0
2018-08-09 12:00:00	QQQ	ETF	182.11	182.4498	182.1	182.4225	1143550.0
2018-08-09 13:00:00	QQQ	ETF	182.42	182.63	182.26	182.58	1164435.0
2018-08-09 14:00:00	QQQ	ETF	182.58	182.62	182.34	182.41	1240529.0
2018-08-09 15:00:00	QQQ	ETF	182.4	182.43	181.76	181.85	4568811.0
2018-08-09 16:00:00	QQQ	ETF	181.86	182.51	181.67	181.77	1237947.0
2018-08-09 17:00:00	QQQ	ETF	181.8	181.91	181.75	181.8	26139.0
2018-08-09 18:00:00	QQQ	ETF	181.83	181.83	181.55	181.61	54317.0
2018-08-09 19:00:00	QQQ	ETF	181.64	181.7	181.6	181.7	30560.0
2018-08-09 04:00:00	IWM	ETF	167.62	167.62	167.62	167.62	300.0
2018-08-09 05:00:00	IWM	ETF	167.64	167.64	167.64	167.64	375.0
2018-08-09 06:00:00	IWM	ETF	167.7	167.7	167.64	167.64	4000.0
2018-08-09 07:00:00	IWM	ETF	167.57	167.74	167.57	167.74	11500.0
2018-08-09 08:00:00	IWM	ETF	167.69	167.79	167.69	167.74	16142.0
2018-08-09 09:00:00	IWM	ETF	167.77	168.38	167.55	168.17	2062985.0
2018-08-09 10:00:00	IWM	ETF	168.18	168.71	168.15	168.37	1504006.0
2018-08-09 11:00:00	IWM	ETF	168.3784	168.69	168.005	168.19	1504341.0
2018-08-09 12:00:00	IWM	ETF	168.2	168.7	168.17	168.645	642821.0
2018-08-09 13:00:00	IWM	ETF	168.65	168.66	168.44	168.625	576103.0
2018-08-09 14:00:00	IWM	ETF	168.62	168.63	168.31	168.37	624373.0
2018-08-09 15:00:00	IWM	ETF	168.37	168.415	167.86	168.0	1832718.0
2018-08-09 16:00:00	IWM	ETF	167.99	168.14	167.81	167.94	847661.0
2018-08-09 17:00:00	IWM	ETF	167.9	167.9	167.9	167.9	140.0
2018-08-09 18:00:00	IWM	ETF	167.99	167.99	167.86	167.88	1400.0
2018-08-09 19:00:00	IWM	ETF	167.88	167.92	167.88	167.92	613.0
2018-08-09 08:00:00	DIA	ETF	255.66	255.82	255.66	255.77	1650.0
2018-08-09 09:00:00	DIA	ETF	255.78	256.12	255.68	255.9293	266008.0

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

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