PREVIEW / etf_1hour / 2018-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-01.parquet
  size:    299 KB
  rows:    9,857

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-08-01 04:00:00	SPY	ETF	281.37	281.5	281.13	281.21	13908.0
2018-08-01 05:00:00	SPY	ETF	281.11	281.11	280.88	280.93	14674.0
2018-08-01 06:00:00	SPY	ETF	280.95	281.31	280.95	280.95	24652.0
2018-08-01 07:00:00	SPY	ETF	280.96	281.29	280.96	281.27	72434.0
2018-08-01 08:00:00	SPY	ETF	281.31	281.71	280.98	281.55	222231.0
2018-08-01 09:00:00	SPY	ETF	281.5	281.79	281.33	281.62	5291895.0
2018-08-01 10:00:00	SPY	ETF	281.65	282.13	281.41	281.835	7153114.0
2018-08-01 11:00:00	SPY	ETF	281.84	281.88	280.845	280.96	7254904.0
2018-08-01 12:00:00	SPY	ETF	280.96	281.0	280.37	280.74	6580349.0
2018-08-01 13:00:00	SPY	ETF	280.73	280.88	280.36	280.62	5323977.0
2018-08-01 14:00:00	SPY	ETF	280.65	281.06	280.1315	281.04	6253720.0
2018-08-01 15:00:00	SPY	ETF	281.05	281.27	280.8	280.92	8882995.0
2018-08-01 16:00:00	SPY	ETF	280.91	281.09	280.42	281.01	5270696.0
2018-08-01 17:00:00	SPY	ETF	280.98	281.07	280.97	281.0	58049.0
2018-08-01 18:00:00	SPY	ETF	281.01	281.09	280.93	281.02	51974.0
2018-08-01 19:00:00	SPY	ETF	281.04	281.04	280.86	281.02	33195.0
2018-08-01 04:00:00	QQQ	ETF	176.72	176.73	176.55	176.64	42992.0
2018-08-01 05:00:00	QQQ	ETF	176.65	176.66	176.49	176.53	32865.0
2018-08-01 06:00:00	QQQ	ETF	176.56	176.73	176.52	176.54	46103.0
2018-08-01 07:00:00	QQQ	ETF	176.53	176.77	176.48	176.72	209708.0
2018-08-01 08:00:00	QQQ	ETF	176.5099	177.0	176.45	176.76	255558.0
2018-08-01 09:00:00	QQQ	ETF	176.75	177.26	176.42	177.17	4711907.0
2018-08-01 10:00:00	QQQ	ETF	177.2	177.65	176.89	177.27	4963082.0
2018-08-01 11:00:00	QQQ	ETF	177.28	177.37	176.49	176.645	4085395.0
2018-08-01 12:00:00	QQQ	ETF	176.635	176.93	176.39	176.78	3438824.0
2018-08-01 13:00:00	QQQ	ETF	176.76	176.89	176.53	176.699	1868921.0
2018-08-01 14:00:00	QQQ	ETF	176.7	177.15	176.13	176.88	3886838.0
2018-08-01 15:00:00	QQQ	ETF	176.89	177.25	176.76	177.12	4210334.0
2018-08-01 16:00:00	QQQ	ETF	177.11	177.24	176.77	177.2	1509211.0
2018-08-01 17:00:00	QQQ	ETF	177.22	177.22	177.09	177.17	7636.0
2018-08-01 18:00:00	QQQ	ETF	177.2	177.35	177.19	177.26	27137.0
2018-08-01 19:00:00	QQQ	ETF	177.28	177.31	177.18	177.28	9425.0
2018-08-01 05:00:00	IWM	ETF	165.65	165.66	165.65	165.65	7000.0
2018-08-01 06:00:00	IWM	ETF	165.65	165.76	165.65	165.75	13000.0
2018-08-01 07:00:00	IWM	ETF	165.67	165.85	165.66	165.85	13900.0
2018-08-01 08:00:00	IWM	ETF	165.78	166.15	165.75	165.89	19401.0
2018-08-01 09:00:00	IWM	ETF	165.89	166.04	165.44	165.99	1845663.0
2018-08-01 10:00:00	IWM	ETF	165.99	166.24	165.59	165.674	2218560.0
2018-08-01 11:00:00	IWM	ETF	165.67	165.74	164.79	164.86	2215522.0
2018-08-01 12:00:00	IWM	ETF	164.86	165.07	164.495	164.64	2481517.0
2018-08-01 13:00:00	IWM	ETF	164.63	165.2325	164.61	165.17	1643885.0
2018-08-01 14:00:00	IWM	ETF	165.13	165.63	164.83	165.57	2153075.0
2018-08-01 15:00:00	IWM	ETF	165.57	165.97	165.51	165.77	2990063.0
2018-08-01 16:00:00	IWM	ETF	165.76	165.8238	165.42	165.69	535396.0
2018-08-01 17:00:00	IWM	ETF	165.71	165.76	165.5801	165.5801	700.0
2018-08-01 18:00:00	IWM	ETF	165.75	165.79	165.75	165.75	2299.0
2018-08-01 19:00:00	IWM	ETF	165.71	165.8	165.71	165.8	1749.0
2018-08-01 04:00:00	DIA	ETF	253.92	253.92	253.92	253.92	200.0
2018-08-01 06:00:00	DIA	ETF	253.68	253.68	253.53	253.53	4100.0
2018-08-01 07:00:00	DIA	ETF	253.52	253.72	253.49	253.72	1075.0

> showing 50 of 9,857 rows — these rows as CSV

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