PREVIEW / etf_1hour / 2019-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-09.parquet
  size:    330 KB
  rows:    10,896

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
2019-05-09 04:00:00	SPY	ETF	285.93	286.2	285.56	286.13	48671.0
2019-05-09 05:00:00	SPY	ETF	286.23	286.31	285.93	286.14	22238.0
2019-05-09 06:00:00	SPY	ETF	286.13	286.56	285.91	286.5	93199.0
2019-05-09 07:00:00	SPY	ETF	286.52	286.65	286.22	286.24	323734.0
2019-05-09 08:00:00	SPY	ETF	286.31	287.5403	285.38	285.52	1133515.0
2019-05-09 09:00:00	SPY	ETF	285.52	285.54	283.97	284.57	12186836.0
2019-05-09 10:00:00	SPY	ETF	284.58	284.585	283.35	283.67	14847516.0
2019-05-09 11:00:00	SPY	ETF	283.67	284.84	283.3	284.56	11716982.0
2019-05-09 12:00:00	SPY	ETF	284.56	287.12	284.17	286.29	20215531.0
2019-05-09 13:00:00	SPY	ETF	286.28	287.33	285.92	286.64	8547930.0
2019-05-09 14:00:00	SPY	ETF	286.67	287.31	286.15	286.225	7574594.0
2019-05-09 15:00:00	SPY	ETF	286.23	287.08	285.57	286.75	16404864.0
2019-05-09 16:00:00	SPY	ETF	286.73	287.18	286.65	286.85	7956099.0
2019-05-09 17:00:00	SPY	ETF	286.82	286.91	286.66	286.79	161672.0
2019-05-09 18:00:00	SPY	ETF	286.78	286.78	286.28	286.28	155723.0
2019-05-09 19:00:00	SPY	ETF	286.28	287.22	286.26	287.06	194164.0
2019-05-09 04:00:00	QQQ	ETF	184.34	184.49	184.03	184.49	30573.0
2019-05-09 05:00:00	QQQ	ETF	184.44	184.62	184.3	184.43	33728.0
2019-05-09 06:00:00	QQQ	ETF	184.52	184.7	184.27	184.66	68350.0
2019-05-09 07:00:00	QQQ	ETF	184.75	184.81	184.42	184.5	200776.0
2019-05-09 08:00:00	QQQ	ETF	184.62	185.1	183.8	183.83	381888.0
2019-05-09 09:00:00	QQQ	ETF	183.84	184.15	182.6	183.16	7683175.0
2019-05-09 10:00:00	QQQ	ETF	183.17	183.18	182.09	182.33	8450930.0
2019-05-09 11:00:00	QQQ	ETF	182.3	183.4868	182.26	183.35	5877941.0
2019-05-09 12:00:00	QQQ	ETF	183.31	185.4121	182.88	184.55	10674977.0
2019-05-09 13:00:00	QQQ	ETF	184.53	185.3701	184.21	184.89	4602925.0
2019-05-09 14:00:00	QQQ	ETF	184.89	185.23	184.28	184.3201	3556563.0
2019-05-09 15:00:00	QQQ	ETF	184.33	185.05	183.9	184.81	6863982.0
2019-05-09 16:00:00	QQQ	ETF	184.79	185.08	184.71	184.82	1620385.0
2019-05-09 17:00:00	QQQ	ETF	184.89	185.03	184.77	184.78	13426.0
2019-05-09 18:00:00	QQQ	ETF	184.79	184.79	184.4	184.4	48120.0
2019-05-09 19:00:00	QQQ	ETF	184.35	185.0	184.34	184.88	46840.0
2019-05-09 04:00:00	IWM	ETF	155.7	155.8	155.6	155.8	2245.0
2019-05-09 05:00:00	IWM	ETF	155.87	155.87	155.87	155.87	300.0
2019-05-09 06:00:00	IWM	ETF	155.9	156.1	155.9	156.1	3595.0
2019-05-09 07:00:00	IWM	ETF	156.18	156.23	155.99	156.0	16970.0
2019-05-09 08:00:00	IWM	ETF	156.14	156.14	155.4	155.55	59653.0
2019-05-09 09:00:00	IWM	ETF	155.56	155.66	154.18	154.48	2996100.0
2019-05-09 10:00:00	IWM	ETF	154.5	154.85	153.74	154.19	3643601.0
2019-05-09 11:00:00	IWM	ETF	154.18	155.32	153.95	155.2	2577045.0
2019-05-09 12:00:00	IWM	ETF	155.2001	156.49	155.03	156.24	4598044.0
2019-05-09 13:00:00	IWM	ETF	156.23	156.62	155.77	156.25	2154931.0
2019-05-09 14:00:00	IWM	ETF	156.26	156.65	155.7635	155.83	1691214.0
2019-05-09 15:00:00	IWM	ETF	155.83	156.52	155.45	156.19	4728668.0
2019-05-09 16:00:00	IWM	ETF	156.18	156.45	156.15	156.28	887072.0
2019-05-09 17:00:00	IWM	ETF	156.2	156.348	156.2	156.3	330.0
2019-05-09 18:00:00	IWM	ETF	156.1	156.19	155.94	155.95	263373.0
2019-05-09 19:00:00	IWM	ETF	155.96	156.37	155.96	156.32	7665.0
2019-05-09 04:00:00	DIA	ETF	258.62	258.66	258.44	258.44	2928.0
2019-05-09 05:00:00	DIA	ETF	258.6	258.6	258.6	258.6	3000.0

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

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