PREVIEW / etf_1hour / 2018-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-09-26.parquet
  size:    307 KB
  rows:    10,094

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-09-26 04:00:00	SPY	ETF	291.45	291.46	291.22	291.39	5132.0
2018-09-26 05:00:00	SPY	ETF	291.32	291.4	291.3	291.37	1300.0
2018-09-26 06:00:00	SPY	ETF	291.37	291.48	291.3	291.4	17982.0
2018-09-26 07:00:00	SPY	ETF	291.4	291.4	291.17	291.17	67614.0
2018-09-26 08:00:00	SPY	ETF	291.34	291.36	291.06	291.15	194802.0
2018-09-26 09:00:00	SPY	ETF	291.12	291.31	290.84	291.13	3360994.0
2018-09-26 10:00:00	SPY	ETF	291.15	291.39	290.7	291.315	5297301.0
2018-09-26 11:00:00	SPY	ETF	291.32	291.55	291.32	291.405	3668724.0
2018-09-26 12:00:00	SPY	ETF	291.4	291.63	291.295	291.63	3960382.0
2018-09-26 13:00:00	SPY	ETF	291.6269	291.66	291.37	291.41	3047701.0
2018-09-26 14:00:00	SPY	ETF	291.41	292.24	291.28	291.385	14565562.0
2018-09-26 15:00:00	SPY	ETF	291.39	291.59	289.41	289.84	28000261.0
2018-09-26 16:00:00	SPY	ETF	289.84	289.98	289.43	289.81	15223975.0
2018-09-26 17:00:00	SPY	ETF	289.79	289.84	289.64	289.74	132312.0
2018-09-26 18:00:00	SPY	ETF	289.76	290.0	289.68	290.0	138130.0
2018-09-26 19:00:00	SPY	ETF	289.97	290.01	289.88	289.99	30082.0
2018-09-26 04:00:00	QQQ	ETF	184.6	184.92	184.6	184.91	3131.0
2018-09-26 05:00:00	QQQ	ETF	184.89	184.93	184.8	184.83	11977.0
2018-09-26 06:00:00	QQQ	ETF	184.79	184.9	184.75	184.75	13896.0
2018-09-26 07:00:00	QQQ	ETF	184.74	184.74	184.49	184.49	116919.0
2018-09-26 08:00:00	QQQ	ETF	184.67	184.7499	184.43	184.56	151678.0
2018-09-26 09:00:00	QQQ	ETF	184.58	184.78	184.17	184.675	2787971.0
2018-09-26 10:00:00	QQQ	ETF	184.67	185.03	184.3707	184.97	3892178.0
2018-09-26 11:00:00	QQQ	ETF	184.96	185.3899	184.96	185.24	2307640.0
2018-09-26 12:00:00	QQQ	ETF	185.24	185.25	184.98	185.21	2154838.0
2018-09-26 13:00:00	QQQ	ETF	185.22	185.33	184.975	185.1	1825665.0
2018-09-26 14:00:00	QQQ	ETF	185.08	185.99	185.03	185.42	6148346.0
2018-09-26 15:00:00	QQQ	ETF	185.43	185.59	183.905	184.21	10174794.0
2018-09-26 16:00:00	QQQ	ETF	184.22	184.27	183.83	184.11	2834246.0
2018-09-26 17:00:00	QQQ	ETF	184.19	184.19	184.05	184.1299	19915.0
2018-09-26 18:00:00	QQQ	ETF	184.12	184.41	184.07	184.37	40493.0
2018-09-26 19:00:00	QQQ	ETF	184.38	184.45	184.3	184.45	20282.0
2018-09-26 06:00:00	IWM	ETF	170.16	170.2	170.16	170.2	2400.0
2018-09-26 07:00:00	IWM	ETF	170.13	170.13	169.96	169.96	15106.0
2018-09-26 08:00:00	IWM	ETF	169.9999	170.02	169.89	169.99	122647.0
2018-09-26 09:00:00	IWM	ETF	169.99	170.03	169.25	169.3	1668139.0
2018-09-26 10:00:00	IWM	ETF	169.28	169.43	168.985	169.16	1603288.0
2018-09-26 11:00:00	IWM	ETF	169.16	169.335	169.04	169.0899	975079.0
2018-09-26 12:00:00	IWM	ETF	169.08	169.6399	168.89	169.62	947884.0
2018-09-26 13:00:00	IWM	ETF	169.62	169.67	169.281	169.35	844023.0
2018-09-26 14:00:00	IWM	ETF	169.36	169.79	169.01	169.2	2604425.0
2018-09-26 15:00:00	IWM	ETF	169.2	169.29	167.78	167.98	5588278.0
2018-09-26 16:00:00	IWM	ETF	167.98	168.03	167.69	167.98	997652.0
2018-09-26 17:00:00	IWM	ETF	167.87	169.6416	167.82	168.0	52440.0
2018-09-26 18:00:00	IWM	ETF	167.98	168.16	167.95	168.14	6345.0
2018-09-26 19:00:00	IWM	ETF	168.15	168.19	168.08	168.11	6300.0
2018-09-26 06:00:00	DIA	ETF	265.28	265.28	265.24	265.26	4900.0
2018-09-26 08:00:00	DIA	ETF	265.2	265.3	264.93	264.98	2162.0
2018-09-26 09:00:00	DIA	ETF	264.9	265.31	264.76	265.17	294298.0
2018-09-26 10:00:00	DIA	ETF	265.18	265.32	264.78	265.27	612657.0

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

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