PREVIEW / etf_1hour / 2019-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-05.parquet
  size:    331 KB
  rows:    10,932

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-06-05 04:00:00	SPY	ETF	281.69	281.75	281.62	281.68	17112.0
2019-06-05 05:00:00	SPY	ETF	281.55	282.46	281.49	282.45	79858.0
2019-06-05 06:00:00	SPY	ETF	282.45	282.64	282.23	282.6	144571.0
2019-06-05 07:00:00	SPY	ETF	282.62	282.64	282.0	282.25	443451.0
2019-06-05 08:00:00	SPY	ETF	282.6101	282.63	280.53	281.53	1442793.0
2019-06-05 09:00:00	SPY	ETF	281.53	282.39	281.08	281.8175	8780920.0
2019-06-05 10:00:00	SPY	ETF	281.82	282.09	280.32	280.8249	11227748.0
2019-06-05 11:00:00	SPY	ETF	280.83	281.91	280.66	281.875	7929085.0
2019-06-05 12:00:00	SPY	ETF	281.88	282.24	281.38	281.98	7650046.0
2019-06-05 13:00:00	SPY	ETF	281.97	282.65	281.97	282.4884	6378155.0
2019-06-05 14:00:00	SPY	ETF	282.48	282.74	282.11	282.255	5582510.0
2019-06-05 15:00:00	SPY	ETF	282.25	282.99	281.75	282.9	14210945.0
2019-06-05 16:00:00	SPY	ETF	282.9	283.16	280.5743	283.0	5095411.0
2019-06-05 17:00:00	SPY	ETF	282.99	283.09	282.32	282.35	417856.0
2019-06-05 18:00:00	SPY	ETF	282.33	282.38	281.51	282.1	469026.0
2019-06-05 19:00:00	SPY	ETF	282.04	282.49	281.96	282.38	110541.0
2019-06-05 04:00:00	QQQ	ETF	175.93	176.01	175.78	175.81	24243.0
2019-06-05 05:00:00	QQQ	ETF	175.72	176.52	175.7	176.49	41906.0
2019-06-05 06:00:00	QQQ	ETF	176.47	176.7	176.43	176.56	19689.0
2019-06-05 07:00:00	QQQ	ETF	176.58	176.65	176.14	176.33	158089.0
2019-06-05 08:00:00	QQQ	ETF	176.28	176.6399	174.91	176.03	654856.0
2019-06-05 09:00:00	QQQ	ETF	175.98	176.61	175.2871	175.85	5674522.0
2019-06-05 10:00:00	QQQ	ETF	175.86	176.15	174.38	174.79	6608343.0
2019-06-05 11:00:00	QQQ	ETF	174.8	175.89	174.63	175.84	4834491.0
2019-06-05 12:00:00	QQQ	ETF	175.84	175.99	175.22	175.485	2513758.0
2019-06-05 13:00:00	QQQ	ETF	175.48	176.0599	175.48	175.85	1643353.0
2019-06-05 14:00:00	QQQ	ETF	175.845	176.07	175.56	175.74	1834001.0
2019-06-05 15:00:00	QQQ	ETF	175.73	176.31	175.46	176.22	4332707.0
2019-06-05 16:00:00	QQQ	ETF	176.22	176.4	175.92	176.38	2253743.0
2019-06-05 17:00:00	QQQ	ETF	176.373	176.41	175.79	175.79	42336.0
2019-06-05 18:00:00	QQQ	ETF	175.85	175.85	175.11	175.6	82860.0
2019-06-05 19:00:00	QQQ	ETF	175.6	175.98	175.5	175.89	54654.0
2019-06-05 05:00:00	IWM	ETF	150.71	150.94	150.71	150.84	8900.0
2019-06-05 06:00:00	IWM	ETF	150.96	151.0	150.92	150.92	5800.0
2019-06-05 07:00:00	IWM	ETF	150.99	150.99	150.72	150.76	43384.0
2019-06-05 08:00:00	IWM	ETF	150.75	150.9801	150.27	150.33	112058.0
2019-06-05 09:00:00	IWM	ETF	150.39	150.885	149.51	149.99	2213492.0
2019-06-05 10:00:00	IWM	ETF	150.0	150.24	148.61	148.91	3675464.0
2019-06-05 11:00:00	IWM	ETF	148.92	149.87	148.79	149.81	1968701.0
2019-06-05 12:00:00	IWM	ETF	149.81	150.22	149.42	150.04	1717070.0
2019-06-05 13:00:00	IWM	ETF	150.04	150.56	150.04	150.31	930617.0
2019-06-05 14:00:00	IWM	ETF	150.29	150.34	149.57	149.76	1773741.0
2019-06-05 15:00:00	IWM	ETF	149.77	150.14	149.5	150.14	2874588.0
2019-06-05 16:00:00	IWM	ETF	150.19	150.2691	149.95	150.0	851924.0
2019-06-05 17:00:00	IWM	ETF	150.07	150.07	149.78	149.78	400.0
2019-06-05 18:00:00	IWM	ETF	149.6	149.6	149.2	149.49	13985.0
2019-06-05 19:00:00	IWM	ETF	149.4	149.65	149.4	149.61	5975.0
2019-06-05 04:00:00	DIA	ETF	254.44	254.44	254.44	254.44	100.0
2019-06-05 05:00:00	DIA	ETF	254.46	255.22	254.46	255.22	600.0
2019-06-05 06:00:00	DIA	ETF	255.4	255.4	255.25	255.25	2450.0

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

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