PREVIEW / etf_1hour / 2018-11-26

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-26.parquet
  size:    316 KB
  rows:    10,436

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
2018-11-26 04:00:00	SPY	ETF	266.35	266.65	266.21	266.4	49597.0
2018-11-26 05:00:00	SPY	ETF	266.38	266.46	266.02	266.19	52058.0
2018-11-26 06:00:00	SPY	ETF	266.19	266.37	265.98	266.06	68988.0
2018-11-26 07:00:00	SPY	ETF	266.06	266.37	265.85	265.85	733750.0
2018-11-26 08:00:00	SPY	ETF	265.85	266.27	264.76	265.92	513828.0
2018-11-26 09:00:00	SPY	ETF	265.92	267.17	265.64	267.16	9838216.0
2018-11-26 10:00:00	SPY	ETF	267.18	267.245	266.31	267.0525	12007020.0
2018-11-26 11:00:00	SPY	ETF	267.06	267.1	265.92	266.4	10021768.0
2018-11-26 12:00:00	SPY	ETF	266.4	266.8	265.34	265.84	8080325.0
2018-11-26 13:00:00	SPY	ETF	265.82	266.71	265.54	266.65	4903422.0
2018-11-26 14:00:00	SPY	ETF	266.64	267.47	266.49	267.37	6154577.0
2018-11-26 15:00:00	SPY	ETF	267.3685	267.75	266.91	267.46	15206457.0
2018-11-26 16:00:00	SPY	ETF	267.44	267.7	266.16	266.2	10715946.0
2018-11-26 17:00:00	SPY	ETF	266.2	267.5	266.2	266.26	168966.0
2018-11-26 18:00:00	SPY	ETF	266.25	266.49	266.0	266.22	176795.0
2018-11-26 19:00:00	SPY	ETF	266.21	266.22	265.73	265.78	53877.0
2018-11-26 04:00:00	QQQ	ETF	161.63	162.16	161.63	162.05	88715.0
2018-11-26 05:00:00	QQQ	ETF	161.88	161.97	161.71	161.88	6271.0
2018-11-26 06:00:00	QQQ	ETF	161.88	161.97	161.6	161.82	73207.0
2018-11-26 07:00:00	QQQ	ETF	161.76	161.9	161.51	161.68	146876.0
2018-11-26 08:00:00	QQQ	ETF	161.7799	161.89	160.5	161.54	256135.0
2018-11-26 09:00:00	QQQ	ETF	161.53	162.29	160.8	162.2899	5324322.0
2018-11-26 10:00:00	QQQ	ETF	162.28	162.43	161.47	162.15	5508666.0
2018-11-26 11:00:00	QQQ	ETF	162.16	162.29	161.2901	161.66	3661972.0
2018-11-26 12:00:00	QQQ	ETF	161.67	162.03	160.76	161.34	3210665.0
2018-11-26 13:00:00	QQQ	ETF	161.34	162.08	161.19	162.02	2615591.0
2018-11-26 14:00:00	QQQ	ETF	162.027	162.676	161.96	162.6668	3901356.0
2018-11-26 15:00:00	QQQ	ETF	162.68	162.97	162.37	162.92	8088998.0
2018-11-26 16:00:00	QQQ	ETF	162.93	163.18	161.78	161.82	4364344.0
2018-11-26 17:00:00	QQQ	ETF	161.75	162.0	161.7	161.86	72153.0
2018-11-26 18:00:00	QQQ	ETF	161.8	162.04	161.68	161.86	143854.0
2018-11-26 19:00:00	QQQ	ETF	161.78	161.9	161.51	161.51	51244.0
2018-11-26 04:00:00	IWM	ETF	149.5	149.76	149.46	149.76	16687.0
2018-11-26 05:00:00	IWM	ETF	149.72	149.72	149.72	149.72	200.0
2018-11-26 06:00:00	IWM	ETF	149.69	149.69	149.69	149.69	100.0
2018-11-26 07:00:00	IWM	ETF	149.65	149.65	149.3	149.47	5287.0
2018-11-26 08:00:00	IWM	ETF	149.335	149.6	148.89	149.41	32435.0
2018-11-26 09:00:00	IWM	ETF	149.41	150.2	148.99	150.2	2417593.0
2018-11-26 10:00:00	IWM	ETF	150.18	150.4001	149.61	150.32	2098798.0
2018-11-26 11:00:00	IWM	ETF	150.33	150.38	148.9701	149.36	1506070.0
2018-11-26 12:00:00	IWM	ETF	149.36	149.755	148.74	149.18	1121414.0
2018-11-26 13:00:00	IWM	ETF	149.175	149.53	149.02	149.47	841066.0
2018-11-26 14:00:00	IWM	ETF	149.45	149.73	149.25	149.44	1020284.0
2018-11-26 15:00:00	IWM	ETF	149.45	150.14	149.29	149.8	3202785.0
2018-11-26 16:00:00	IWM	ETF	149.79	149.94	149.02	149.15	694692.0
2018-11-26 17:00:00	IWM	ETF	149.0348	149.3	149.0348	149.3	2990.0
2018-11-26 18:00:00	IWM	ETF	149.16	149.29	149.03	149.07	7090.0
2018-11-26 19:00:00	IWM	ETF	149.01	149.15	148.83	148.83	31850.0
2018-11-26 04:00:00	DIA	ETF	243.84	243.84	243.84	243.84	100.0
2018-11-26 05:00:00	DIA	ETF	245.5	245.5	245.5	245.5	2000.0

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

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