PREVIEW / etf_1hour / 2019-02-12

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-12.parquet
  size:    318 KB
  rows:    10,638

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-02-12 04:00:00	SPY	ETF	272.1	272.36	272.04	272.05	33453.0
2019-02-12 05:00:00	SPY	ETF	272.13	272.43	272.13	272.4	10066.0
2019-02-12 06:00:00	SPY	ETF	272.35	272.6	272.29	272.57	83120.0
2019-02-12 07:00:00	SPY	ETF	272.54	272.72	272.42	272.43	259017.0
2019-02-12 08:00:00	SPY	ETF	272.44	272.63	271.79	272.39	374138.0
2019-02-12 09:00:00	SPY	ETF	272.36	273.15	272.34	273.01	7877985.0
2019-02-12 10:00:00	SPY	ETF	273.02	273.64	272.72	273.56	10956294.0
2019-02-12 11:00:00	SPY	ETF	273.56	274.12	273.55	274.08	7753621.0
2019-02-12 12:00:00	SPY	ETF	274.08	274.2	273.62	273.88	6419829.0
2019-02-12 13:00:00	SPY	ETF	273.89	274.515	273.83	274.5	7560803.0
2019-02-12 14:00:00	SPY	ETF	274.505	274.52	274.12	274.1599	7522253.0
2019-02-12 15:00:00	SPY	ETF	274.14	274.47	273.9	274.12	14286107.0
2019-02-12 16:00:00	SPY	ETF	274.12	274.35	273.95	274.24	7718930.0
2019-02-12 17:00:00	SPY	ETF	274.27	274.27	274.11	274.11	65413.0
2019-02-12 18:00:00	SPY	ETF	274.14	274.46	274.04	274.4	83165.0
2019-02-12 19:00:00	SPY	ETF	274.41	275.19	274.32	274.79	175184.0
2019-02-12 04:00:00	QQQ	ETF	169.53	169.69	169.46	169.55	25473.0
2019-02-12 05:00:00	QQQ	ETF	169.54	169.82	169.54	169.74	23446.0
2019-02-12 06:00:00	QQQ	ETF	169.75	169.86	169.71	169.85	69979.0
2019-02-12 07:00:00	QQQ	ETF	169.84	169.94	169.73	169.73	199216.0
2019-02-12 08:00:00	QQQ	ETF	169.8	169.92	169.53	169.58	182978.0
2019-02-12 09:00:00	QQQ	ETF	169.61	170.16	169.33	170.02	3497262.0
2019-02-12 10:00:00	QQQ	ETF	170.03	170.75	170.015	170.71	4648543.0
2019-02-12 11:00:00	QQQ	ETF	170.7	170.875	170.595	170.77	3047755.0
2019-02-12 12:00:00	QQQ	ETF	170.77	170.86	170.53	170.66	2202230.0
2019-02-12 13:00:00	QQQ	ETF	170.65	171.0	170.59	170.97	1877833.0
2019-02-12 14:00:00	QQQ	ETF	170.97	171.09	170.77	170.7988	2333775.0
2019-02-12 15:00:00	QQQ	ETF	170.8	171.14	170.76	170.92	4270812.0
2019-02-12 16:00:00	QQQ	ETF	170.91	171.0	170.76	170.95	1535041.0
2019-02-12 17:00:00	QQQ	ETF	170.93	170.95	170.81	170.88	69835.0
2019-02-12 18:00:00	QQQ	ETF	170.83	171.09	170.8	171.08	45384.0
2019-02-12 19:00:00	QQQ	ETF	171.08	171.58	171.05	171.44	84256.0
2019-02-12 04:00:00	IWM	ETF	151.9	151.91	151.8	151.85	4000.0
2019-02-12 05:00:00	IWM	ETF	151.85	151.98	151.85	151.95	1240.0
2019-02-12 06:00:00	IWM	ETF	151.97	152.02	151.95	152.02	1218.0
2019-02-12 07:00:00	IWM	ETF	152.05	152.15	152.03	152.04	21750.0
2019-02-12 08:00:00	IWM	ETF	152.0901	152.1299	151.68	151.93	25387.0
2019-02-12 09:00:00	IWM	ETF	151.89	152.59	151.8815	152.45	2222164.0
2019-02-12 10:00:00	IWM	ETF	152.47	153.0101	152.27	152.95	2309541.0
2019-02-12 11:00:00	IWM	ETF	152.96	153.19	152.58	152.89	1985316.0
2019-02-12 12:00:00	IWM	ETF	152.9	152.96	152.55	152.64	1465857.0
2019-02-12 13:00:00	IWM	ETF	152.64	152.87	152.55	152.83	1060564.0
2019-02-12 14:00:00	IWM	ETF	152.84	152.85	152.58	152.71	1927967.0
2019-02-12 15:00:00	IWM	ETF	152.71	153.03	152.69	152.96	3651147.0
2019-02-12 16:00:00	IWM	ETF	152.97	153.08	152.67	153.0	3615640.0
2019-02-12 17:00:00	IWM	ETF	153.0	153.02	152.92	152.93	25775.0
2019-02-12 18:00:00	IWM	ETF	152.96	153.15	152.95	153.15	5100.0
2019-02-12 19:00:00	IWM	ETF	153.14	153.5	153.14	153.31	14234.0
2019-02-12 04:00:00	DIA	ETF	252.44	252.44	252.24	252.3	1020.0
2019-02-12 05:00:00	DIA	ETF	252.56	252.56	252.56	252.56	3000.0

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

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