PREVIEW / etf_1hour / 2019-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-20.parquet
  size:    321 KB
  rows:    10,716

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-20 04:00:00	SPY	ETF	286.61	287.06	285.49	285.6	23242.0
2019-05-20 05:00:00	SPY	ETF	285.61	285.96	285.4	285.86	67314.0
2019-05-20 06:00:00	SPY	ETF	285.84	285.85	284.25	284.28	182528.0
2019-05-20 07:00:00	SPY	ETF	284.32	284.6	284.15	284.48	443021.0
2019-05-20 08:00:00	SPY	ETF	284.44	287.02	283.51	283.85	1228528.0
2019-05-20 09:00:00	SPY	ETF	283.83	284.7	283.19	284.5	9522275.0
2019-05-20 10:00:00	SPY	ETF	284.5	285.43	284.07	285.17	9280818.0
2019-05-20 11:00:00	SPY	ETF	285.17	285.3498	284.25	284.638	6876207.0
2019-05-20 12:00:00	SPY	ETF	284.63	285.235	284.24	284.29	4983667.0
2019-05-20 13:00:00	SPY	ETF	284.29	284.72	284.09	284.495	3396872.0
2019-05-20 14:00:00	SPY	ETF	284.49	284.55	283.48	283.68	6012174.0
2019-05-20 15:00:00	SPY	ETF	283.6815	284.24	283.12	283.97	13411237.0
2019-05-20 16:00:00	SPY	ETF	283.98	284.64	283.83	284.62	5933854.0
2019-05-20 17:00:00	SPY	ETF	284.58	284.63	283.95	284.57	195670.0
2019-05-20 18:00:00	SPY	ETF	284.61	284.82	283.95	284.72	128116.0
2019-05-20 19:00:00	SPY	ETF	284.76	284.95	284.74	284.8	92808.0
2019-05-20 04:00:00	QQQ	ETF	183.1	183.64	182.14	182.32	48006.0
2019-05-20 05:00:00	QQQ	ETF	182.34	182.38	181.93	182.2	38293.0
2019-05-20 06:00:00	QQQ	ETF	182.16	182.17	180.71	180.8	128721.0
2019-05-20 07:00:00	QQQ	ETF	180.86	181.02	180.53	180.78	202279.0
2019-05-20 08:00:00	QQQ	ETF	181.01	183.71	179.76	180.09	685398.0
2019-05-20 09:00:00	QQQ	ETF	180.09	180.68	179.34	180.3	6240539.0
2019-05-20 10:00:00	QQQ	ETF	180.28	181.1799	179.735	180.93	5395347.0
2019-05-20 11:00:00	QQQ	ETF	180.93	181.1	180.09	180.49	4274790.0
2019-05-20 12:00:00	QQQ	ETF	180.48	181.11	180.19	180.23	2867882.0
2019-05-20 13:00:00	QQQ	ETF	180.22	180.54	180.03	180.32	1750161.0
2019-05-20 14:00:00	QQQ	ETF	180.32	180.362	179.62	179.8	2883954.0
2019-05-20 15:00:00	QQQ	ETF	179.79	180.3	179.38	179.96	7781622.0
2019-05-20 16:00:00	QQQ	ETF	179.96	180.41	179.9	180.4	1586710.0
2019-05-20 17:00:00	QQQ	ETF	180.4	180.46	179.95	180.4	31128.0
2019-05-20 18:00:00	QQQ	ETF	180.44	180.58	180.44	180.47	25611.0
2019-05-20 19:00:00	QQQ	ETF	180.56	180.69	180.47	180.63	35120.0
2019-05-20 04:00:00	IWM	ETF	152.96	152.96	152.96	152.96	500.0
2019-05-20 05:00:00	IWM	ETF	152.73	152.89	152.7	152.89	7410.0
2019-05-20 06:00:00	IWM	ETF	152.85	152.86	151.81	151.81	20425.0
2019-05-20 07:00:00	IWM	ETF	151.94	152.12	151.82	152.12	32140.0
2019-05-20 08:00:00	IWM	ETF	152.09	153.58	151.51	151.6	96060.0
2019-05-20 09:00:00	IWM	ETF	151.69	152.17	151.41	151.9	3025630.0
2019-05-20 10:00:00	IWM	ETF	151.92	152.385	151.47	152.32	3081785.0
2019-05-20 11:00:00	IWM	ETF	152.34	152.46	151.84	152.27	2221742.0
2019-05-20 12:00:00	IWM	ETF	152.26	152.82	152.185	152.3	1314723.0
2019-05-20 13:00:00	IWM	ETF	152.3	152.7074	152.21	152.565	900960.0
2019-05-20 14:00:00	IWM	ETF	152.57	152.57	151.73	151.81	1487906.0
2019-05-20 15:00:00	IWM	ETF	151.8	151.9872	151.4342	151.78	3155029.0
2019-05-20 16:00:00	IWM	ETF	151.77	152.06	151.7	152.04	773682.0
2019-05-20 17:00:00	IWM	ETF	151.88	152.05	151.88	151.99	4500.0
2019-05-20 18:00:00	IWM	ETF	152.0	152.15	152.0	152.11	20400.0
2019-05-20 19:00:00	IWM	ETF	152.11	152.2	152.1	152.14	7890.0
2019-05-20 04:00:00	DIA	ETF	258.36	258.5	258.36	258.5	200.0
2019-05-20 05:00:00	DIA	ETF	257.3	257.65	257.3	257.65	500.0

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

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