PREVIEW / etf_1hour / 2019-05-13

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-13.parquet
  size:    344 KB
  rows:    11,315

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-13 04:00:00	SPY	ETF	284.34	284.96	284.11	284.66	79225.0
2019-05-13 05:00:00	SPY	ETF	284.71	285.1	284.71	285.1	53869.0
2019-05-13 06:00:00	SPY	ETF	285.11	285.11	284.57	284.89	230904.0
2019-05-13 07:00:00	SPY	ETF	284.91	284.95	284.06	284.11	697776.0
2019-05-13 08:00:00	SPY	ETF	284.14	285.53	282.54	282.72	3628737.0
2019-05-13 09:00:00	SPY	ETF	282.71	283.49	281.85	282.16	15141197.0
2019-05-13 10:00:00	SPY	ETF	282.16	282.54	281.07	281.86	17618905.0
2019-05-13 11:00:00	SPY	ETF	281.85	282.1	280.67	281.5	11540221.0
2019-05-13 12:00:00	SPY	ETF	281.49	281.51	280.3	280.32	8291203.0
2019-05-13 13:00:00	SPY	ETF	280.31	281.19	279.93	281.12	13684604.0
2019-05-13 14:00:00	SPY	ETF	281.12	282.21	280.54	281.79	15222000.0
2019-05-13 15:00:00	SPY	ETF	281.78	282.24	280.2	280.96	26217737.0
2019-05-13 16:00:00	SPY	ETF	281.0	287.9383	280.19	280.54	11337214.0
2019-05-13 17:00:00	SPY	ETF	280.51	287.9383	280.36	280.86	336886.0
2019-05-13 18:00:00	SPY	ETF	280.4	280.56	279.74	280.44	131703.0
2019-05-13 19:00:00	SPY	ETF	280.43	280.5	280.07	280.11	55684.0
2019-05-13 04:00:00	QQQ	ETF	182.07	182.4	181.9	182.11	74670.0
2019-05-13 05:00:00	QQQ	ETF	182.24	182.45	182.2	182.37	52096.0
2019-05-13 06:00:00	QQQ	ETF	182.43	182.43	181.97	182.23	77666.0
2019-05-13 07:00:00	QQQ	ETF	182.32	182.32	181.5	181.59	253166.0
2019-05-13 08:00:00	QQQ	ETF	182.15	183.64	180.24	180.49	1658593.0
2019-05-13 09:00:00	QQQ	ETF	180.49	181.26	179.57	179.9699	8529987.0
2019-05-13 10:00:00	QQQ	ETF	179.93	180.11	179.01	179.625	8400650.0
2019-05-13 11:00:00	QQQ	ETF	179.63	179.86	178.55	179.189	6109204.0
2019-05-13 12:00:00	QQQ	ETF	179.1799	179.21	178.59	178.62	3779173.0
2019-05-13 13:00:00	QQQ	ETF	178.62	179.26	178.21	179.18	5355970.0
2019-05-13 14:00:00	QQQ	ETF	179.18	179.81	178.64	179.51	8077179.0
2019-05-13 15:00:00	QQQ	ETF	179.51	179.83	178.06	178.56	13492668.0
2019-05-13 16:00:00	QQQ	ETF	178.59	178.65	177.87	178.07	3877712.0
2019-05-13 17:00:00	QQQ	ETF	178.12	184.9708	177.9	178.58	1998558.0
2019-05-13 18:00:00	QQQ	ETF	178.01	178.12	177.56	178.1	70075.0
2019-05-13 19:00:00	QQQ	ETF	178.06	178.19	177.89	177.9	66394.0
2019-05-13 04:00:00	IWM	ETF	154.56	154.78	154.55	154.69	11434.0
2019-05-13 05:00:00	IWM	ETF	154.95	155.05	154.89	155.05	5490.0
2019-05-13 06:00:00	IWM	ETF	155.04	155.04	154.77	154.92	5420.0
2019-05-13 07:00:00	IWM	ETF	154.95	154.95	154.5	154.52	20127.0
2019-05-13 08:00:00	IWM	ETF	154.65	154.81	153.56	154.04	398727.0
2019-05-13 09:00:00	IWM	ETF	153.9	154.04	152.73	152.84	3670638.0
2019-05-13 10:00:00	IWM	ETF	152.82	152.85	152.1	152.465	3909384.0
2019-05-13 11:00:00	IWM	ETF	152.47	152.623	151.77	152.2	2806921.0
2019-05-13 12:00:00	IWM	ETF	152.2	152.2	151.41	151.42	1895559.0
2019-05-13 13:00:00	IWM	ETF	151.41	151.96	151.18	151.93	1886594.0
2019-05-13 14:00:00	IWM	ETF	151.92	152.58	151.74	152.29	2664682.0
2019-05-13 15:00:00	IWM	ETF	152.29	152.555	151.16	151.64	5863604.0
2019-05-13 16:00:00	IWM	ETF	151.64	151.73	151.04	151.27	927858.0
2019-05-13 17:00:00	IWM	ETF	151.48	151.48	151.11	151.4	310436.0
2019-05-13 18:00:00	IWM	ETF	151.19	151.63	150.91	151.15	21423.0
2019-05-13 19:00:00	IWM	ETF	151.2	151.2	150.94	150.94	5175.0
2019-05-13 04:00:00	DIA	ETF	257.5	257.5	256.58	256.58	400.0
2019-05-13 05:00:00	DIA	ETF	257.14	257.3	257.1	257.3	2845.0

> showing 50 of 11,315 rows — these rows as CSV

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