PREVIEW / etf_1hour / 2018-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-06.parquet
  size:    301 KB
  rows:    9,862

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-06 04:00:00	SPY	ETF	283.6	283.6	283.19	283.19	10874.0
2018-08-06 05:00:00	SPY	ETF	283.24	283.64	283.24	283.64	10845.0
2018-08-06 06:00:00	SPY	ETF	283.64	283.92	283.62	283.92	10146.0
2018-08-06 07:00:00	SPY	ETF	283.91	283.91	283.67	283.69	32972.0
2018-08-06 08:00:00	SPY	ETF	283.66	283.89	283.41	283.43	130063.0
2018-08-06 09:00:00	SPY	ETF	283.45	283.84	283.2015	283.76	4215128.0
2018-08-06 10:00:00	SPY	ETF	283.76	284.03	283.54	284.01	3575033.0
2018-08-06 11:00:00	SPY	ETF	284.01	284.4	283.84	284.37	3102630.0
2018-08-06 12:00:00	SPY	ETF	284.38	284.8075	284.37	284.785	5187922.0
2018-08-06 13:00:00	SPY	ETF	284.785	284.99	284.4	284.46	4437132.0
2018-08-06 14:00:00	SPY	ETF	284.46	284.84	284.375	284.68	4248936.0
2018-08-06 15:00:00	SPY	ETF	284.68	284.73	284.49	284.68	9730554.0
2018-08-06 16:00:00	SPY	ETF	284.68	284.75	284.0017	284.6	3182307.0
2018-08-06 17:00:00	SPY	ETF	284.61	284.6523	284.54	284.59	273949.0
2018-08-06 18:00:00	SPY	ETF	284.63	284.65	284.52	284.62	82985.0
2018-08-06 19:00:00	SPY	ETF	284.58	284.67	284.58	284.65	16825.0
2018-08-06 04:00:00	QQQ	ETF	179.97	180.16	179.94	179.94	6582.0
2018-08-06 05:00:00	QQQ	ETF	179.94	180.27	179.94	180.27	9600.0
2018-08-06 06:00:00	QQQ	ETF	180.3	180.43	180.3	180.37	3950.0
2018-08-06 07:00:00	QQQ	ETF	180.37	180.44	180.21	180.22	42650.0
2018-08-06 08:00:00	QQQ	ETF	180.41	180.41	179.92	179.97	387414.0
2018-08-06 09:00:00	QQQ	ETF	179.98	180.36	179.74	180.29	3397504.0
2018-08-06 10:00:00	QQQ	ETF	180.3	180.6	179.96	180.215	3259312.0
2018-08-06 11:00:00	QQQ	ETF	180.23	180.56	179.99	180.5242	1690573.0
2018-08-06 12:00:00	QQQ	ETF	180.53	180.94	180.5	180.94	2048678.0
2018-08-06 13:00:00	QQQ	ETF	180.94	181.18	180.725	180.8048	2770150.0
2018-08-06 14:00:00	QQQ	ETF	180.799	181.12	180.75	181.02	1687224.0
2018-08-06 15:00:00	QQQ	ETF	181.02	181.19	180.92	181.17	3319639.0
2018-08-06 16:00:00	QQQ	ETF	181.17	181.23	181.04	181.07	2656157.0
2018-08-06 17:00:00	QQQ	ETF	181.09	181.1	181.05	181.05	2491.0
2018-08-06 18:00:00	QQQ	ETF	181.01	181.05	181.01	181.05	12840.0
2018-08-06 19:00:00	QQQ	ETF	181.02	181.11	181.02	181.11	8150.0
2018-08-06 04:00:00	IWM	ETF	166.25	166.25	166.12	166.13	3856.0
2018-08-06 05:00:00	IWM	ETF	166.05	166.13	166.05	166.13	1100.0
2018-08-06 06:00:00	IWM	ETF	166.37	166.37	166.37	166.37	1500.0
2018-08-06 07:00:00	IWM	ETF	166.5	166.5	166.4	166.4	2154.0
2018-08-06 08:00:00	IWM	ETF	166.27	166.59	166.2	166.2	16774.0
2018-08-06 09:00:00	IWM	ETF	166.23	166.8	165.9	166.7	1767460.0
2018-08-06 10:00:00	IWM	ETF	166.71	167.26	166.63	166.78	2168323.0
2018-08-06 11:00:00	IWM	ETF	166.76	167.08	166.33	166.87	1142281.0
2018-08-06 12:00:00	IWM	ETF	166.865	167.4252	166.8362	167.39	1734956.0
2018-08-06 13:00:00	IWM	ETF	167.39	167.51	166.95	167.02	1093897.0
2018-08-06 14:00:00	IWM	ETF	167.03	167.32	167.01	167.2149	1048117.0
2018-08-06 15:00:00	IWM	ETF	167.21	167.36	166.985	167.34	2623396.0
2018-08-06 16:00:00	IWM	ETF	167.34	167.5	167.31	167.44	1120116.0
2018-08-06 17:00:00	IWM	ETF	167.49	167.49	167.37	167.43	5440.0
2018-08-06 18:00:00	IWM	ETF	167.38	167.44	167.38	167.44	1500.0
2018-08-06 19:00:00	IWM	ETF	167.45	167.45	167.4	167.4	1164.0
2018-08-06 04:00:00	DIA	ETF	254.2	254.2	254.12	254.12	700.0
2018-08-06 05:00:00	DIA	ETF	254.16	254.16	254.14	254.14	1000.0

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

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