PREVIEW / etf_1hour / 2018-02-26

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-26.parquet
  size:    308 KB
  rows:    10,126

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-02-26 04:00:00	SPY	ETF	275.7	276.1	275.65	275.75	29900.0
2018-02-26 05:00:00	SPY	ETF	275.76	275.98	275.76	275.96	26154.0
2018-02-26 06:00:00	SPY	ETF	276.0	276.07	275.8	275.88	18234.0
2018-02-26 07:00:00	SPY	ETF	275.88	276.05	275.63	275.91	155189.0
2018-02-26 08:00:00	SPY	ETF	275.95	276.05	275.35	275.8	529593.0
2018-02-26 09:00:00	SPY	ETF	275.77	276.69	275.69	276.22	8589800.0
2018-02-26 10:00:00	SPY	ETF	276.21	276.39	275.26	275.62	7956994.0
2018-02-26 11:00:00	SPY	ETF	275.63	276.55	275.44	276.28	6560273.0
2018-02-26 12:00:00	SPY	ETF	276.29	277.21	276.28	277.12	6216458.0
2018-02-26 13:00:00	SPY	ETF	277.11	277.34	277.0	277.2499	4990916.0
2018-02-26 14:00:00	SPY	ETF	277.245	277.53	276.92	277.23	8416624.0
2018-02-26 15:00:00	SPY	ETF	277.22	278.01	277.13	277.89	28440409.0
2018-02-26 16:00:00	SPY	ETF	277.89	278.54	274.6616	278.35	10774357.0
2018-02-26 17:00:00	SPY	ETF	278.35	278.39	275.72	278.33	1340012.0
2018-02-26 18:00:00	SPY	ETF	278.34	278.51	278.26	278.36	128829.0
2018-02-26 19:00:00	SPY	ETF	278.36	278.39	278.15	278.36	60526.0
2018-02-26 04:00:00	QQQ	ETF	168.5	168.75	168.4	168.5	73945.0
2018-02-26 05:00:00	QQQ	ETF	168.49	169.0	168.49	168.56	16451.0
2018-02-26 06:00:00	QQQ	ETF	168.78	168.83	168.72	168.76	22490.0
2018-02-26 07:00:00	QQQ	ETF	168.77	169.0	168.77	169.0	100770.0
2018-02-26 08:00:00	QQQ	ETF	168.8	169.08	168.48	168.92	247168.0
2018-02-26 09:00:00	QQQ	ETF	168.94	169.67	168.82	169.515	4381205.0
2018-02-26 10:00:00	QQQ	ETF	169.515	169.71	168.92	169.11	4552165.0
2018-02-26 11:00:00	QQQ	ETF	169.11	169.7052	168.97	169.53	3646840.0
2018-02-26 12:00:00	QQQ	ETF	169.52	169.85	169.49	169.8	2422840.0
2018-02-26 13:00:00	QQQ	ETF	169.8	169.9034	169.7	169.83	1730759.0
2018-02-26 14:00:00	QQQ	ETF	169.84	170.159	169.84	169.9615	3019411.0
2018-02-26 15:00:00	QQQ	ETF	169.96	170.36	169.91	170.35	6704658.0
2018-02-26 16:00:00	QQQ	ETF	170.34	170.67	170.3	170.59	1509844.0
2018-02-26 17:00:00	QQQ	ETF	170.65	170.65	170.4	170.58	612643.0
2018-02-26 18:00:00	QQQ	ETF	170.56	170.61	170.5	170.57	14678.0
2018-02-26 19:00:00	QQQ	ETF	170.55	170.55	170.43	170.53	23947.0
2018-02-26 05:00:00	IWM	ETF	154.57	154.57	154.57	154.57	100.0
2018-02-26 06:00:00	IWM	ETF	154.54	154.54	154.54	154.54	100.0
2018-02-26 07:00:00	IWM	ETF	154.54	154.64	154.5	154.6	20914.0
2018-02-26 08:00:00	IWM	ETF	154.34	154.67	154.3	154.51	24248.0
2018-02-26 09:00:00	IWM	ETF	154.52	154.82	153.93	154.04	1699593.0
2018-02-26 10:00:00	IWM	ETF	154.03	154.15	153.47	153.89	1903139.0
2018-02-26 11:00:00	IWM	ETF	153.89	154.22	153.73	154.1031	1202533.0
2018-02-26 12:00:00	IWM	ETF	154.11	155.0	154.07	154.88	1508594.0
2018-02-26 13:00:00	IWM	ETF	154.88	155.01	154.64	154.87	908893.0
2018-02-26 14:00:00	IWM	ETF	154.88	154.97	154.6001	154.68	1250071.0
2018-02-26 15:00:00	IWM	ETF	154.67	155.26	154.62	154.96	3889424.0
2018-02-26 16:00:00	IWM	ETF	154.96	155.33	154.92	155.16	1216407.0
2018-02-26 17:00:00	IWM	ETF	155.17	155.17	154.99	155.12	44238.0
2018-02-26 18:00:00	IWM	ETF	155.2	155.24	155.1	155.24	4180.0
2018-02-26 19:00:00	IWM	ETF	155.11	155.14	155.02	155.14	5393.0
2018-02-26 04:00:00	DIA	ETF	253.87	255.0	253.87	254.75	1000.0
2018-02-26 05:00:00	DIA	ETF	254.69	254.73	254.69	254.73	3532.0
2018-02-26 06:00:00	DIA	ETF	254.8	254.85	254.64	254.64	1350.0

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

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