PREVIEW / etf_1hour / 2018-01-24

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-24.parquet
  size:    315 KB
  rows:    10,347

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-01-24 04:00:00	SPY	ETF	283.53	283.62	283.43	283.53	4720.0
2018-01-24 05:00:00	SPY	ETF	283.58	283.79	283.58	283.66	12300.0
2018-01-24 06:00:00	SPY	ETF	283.64	283.64	283.48	283.53	35193.0
2018-01-24 07:00:00	SPY	ETF	283.54	283.92	283.52	283.67	194826.0
2018-01-24 08:00:00	SPY	ETF	283.72	284.18	283.45	284.0	728551.0
2018-01-24 09:00:00	SPY	ETF	283.99	284.34	283.75	284.28	9070358.0
2018-01-24 10:00:00	SPY	ETF	284.28	284.7	284.07	284.19	14197868.0
2018-01-24 11:00:00	SPY	ETF	284.18	284.35	282.38	283.19	18990067.0
2018-01-24 12:00:00	SPY	ETF	283.18	283.36	282.26	282.68	8600876.0
2018-01-24 13:00:00	SPY	ETF	282.68	283.42	281.84	283.14	20239432.0
2018-01-24 14:00:00	SPY	ETF	283.14	283.76	282.99	283.46	17320145.0
2018-01-24 15:00:00	SPY	ETF	283.48	283.77	283.06	283.18	19681724.0
2018-01-24 16:00:00	SPY	ETF	283.17	284.05	283.05	283.34	21629010.0
2018-01-24 17:00:00	SPY	ETF	283.26	283.35	283.21	283.25	2521048.0
2018-01-24 18:00:00	SPY	ETF	283.26	283.26	282.76	282.95	217699.0
2018-01-24 19:00:00	SPY	ETF	282.95	283.29	282.81	283.24	50215.0
2018-01-24 04:00:00	QQQ	ETF	169.51	169.58	169.48	169.51	18833.0
2018-01-24 05:00:00	QQQ	ETF	169.53	169.8	169.52	169.71	35442.0
2018-01-24 06:00:00	QQQ	ETF	169.5	169.67	169.4	169.45	96937.0
2018-01-24 07:00:00	QQQ	ETF	169.48	169.58	169.43	169.43	146418.0
2018-01-24 08:00:00	QQQ	ETF	169.47	169.98	169.43	169.85	177172.0
2018-01-24 09:00:00	QQQ	ETF	169.83	169.9699	169.29	169.7189	4771036.0
2018-01-24 10:00:00	QQQ	ETF	169.72	170.24	169.6	169.73	6234300.0
2018-01-24 11:00:00	QQQ	ETF	169.73	169.82	168.08	168.67	9137874.0
2018-01-24 12:00:00	QQQ	ETF	168.67	168.81	167.91	168.28	4807687.0
2018-01-24 13:00:00	QQQ	ETF	168.27	168.78	167.44	168.5	7450051.0
2018-01-24 14:00:00	QQQ	ETF	168.51	169.15	168.43	168.895	3589051.0
2018-01-24 15:00:00	QQQ	ETF	168.9	168.93	168.29	168.46	8223524.0
2018-01-24 16:00:00	QQQ	ETF	168.44	168.8	168.32	168.57	1015687.0
2018-01-24 17:00:00	QQQ	ETF	168.55	168.59	168.52	168.59	8198.0
2018-01-24 18:00:00	QQQ	ETF	168.56	168.56	168.28	168.39	52890.0
2018-01-24 19:00:00	QQQ	ETF	168.41	168.71	168.35	168.66	143604.0
2018-01-24 04:00:00	IWM	ETF	160.1	160.1	160.1	160.1	500.0
2018-01-24 05:00:00	IWM	ETF	160.25	160.25	160.25	160.25	5000.0
2018-01-24 06:00:00	IWM	ETF	160.15	160.17	160.14	160.15	5247.0
2018-01-24 07:00:00	IWM	ETF	160.06	160.24	160.0	160.04	17433.0
2018-01-24 08:00:00	IWM	ETF	160.08	160.49	160.08	160.44	52484.0
2018-01-24 09:00:00	IWM	ETF	160.38	160.49	159.92	160.42	1630373.0
2018-01-24 10:00:00	IWM	ETF	160.43	160.625	159.53	159.84	2201059.0
2018-01-24 11:00:00	IWM	ETF	159.83	160.05	158.71	159.04	3900832.0
2018-01-24 12:00:00	IWM	ETF	159.05	159.11	158.48	158.82	2097309.0
2018-01-24 13:00:00	IWM	ETF	158.82	159.41	158.4	159.25	2227708.0
2018-01-24 14:00:00	IWM	ETF	159.26	159.37	158.92	159.14	1590534.0
2018-01-24 15:00:00	IWM	ETF	159.15	159.16	158.8	158.95	4049370.0
2018-01-24 16:00:00	IWM	ETF	158.94	159.96	158.73	159.96	980548.0
2018-01-24 17:00:00	IWM	ETF	158.97	158.97	158.83	158.86	4585.0
2018-01-24 18:00:00	IWM	ETF	158.85	158.85	158.51	158.62	19871.0
2018-01-24 19:00:00	IWM	ETF	158.61	158.92	158.58	158.92	5080.0
2018-01-24 07:00:00	DIA	ETF	262.36	262.88	262.36	262.6	1600.0
2018-01-24 08:00:00	DIA	ETF	262.75	262.99	262.66	262.92	3217.0

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

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