PREVIEW / etf_1hour / 2018-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-06.parquet
  size:    304 KB
  rows:    9,904

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-06-06 04:00:00	SPY	ETF	275.65	275.88	275.65	275.72	14159.0
2018-06-06 05:00:00	SPY	ETF	275.73	276.06	275.73	276.04	30978.0
2018-06-06 06:00:00	SPY	ETF	276.02	276.02	275.85	275.97	49409.0
2018-06-06 07:00:00	SPY	ETF	275.96	276.04	275.77	276.02	116532.0
2018-06-06 08:00:00	SPY	ETF	275.9399	276.04	275.8	275.8	259714.0
2018-06-06 09:00:00	SPY	ETF	275.78	275.98	275.331	275.39	6336711.0
2018-06-06 10:00:00	SPY	ETF	275.4	275.62	275.09	275.6	8528080.0
2018-06-06 11:00:00	SPY	ETF	275.61	276.44	275.6	276.42	6701839.0
2018-06-06 12:00:00	SPY	ETF	276.42	276.46	276.18	276.33	4007053.0
2018-06-06 13:00:00	SPY	ETF	276.33	276.48	276.11	276.32	3991266.0
2018-06-06 14:00:00	SPY	ETF	276.32	277.14	276.32	277.0	6265037.0
2018-06-06 15:00:00	SPY	ETF	277.0	277.52	276.84	277.5	14320843.0
2018-06-06 16:00:00	SPY	ETF	277.5	277.72	275.5	277.62	9450356.0
2018-06-06 17:00:00	SPY	ETF	277.64	277.7	277.6	277.64	293771.0
2018-06-06 18:00:00	SPY	ETF	277.64	277.69	277.48	277.5	135040.0
2018-06-06 19:00:00	SPY	ETF	277.48	277.49	277.34	277.48	44189.0
2018-06-06 04:00:00	QQQ	ETF	175.22	175.24	175.12	175.21	3700.0
2018-06-06 05:00:00	QQQ	ETF	175.32	175.4	175.29	175.38	14900.0
2018-06-06 06:00:00	QQQ	ETF	175.3	175.33	175.23	175.28	13950.0
2018-06-06 07:00:00	QQQ	ETF	175.26	175.31	175.18	175.25	35116.0
2018-06-06 08:00:00	QQQ	ETF	175.25	175.28	174.84	175.02	152203.0
2018-06-06 09:00:00	QQQ	ETF	175.01	175.22	174.54	174.57	2371360.0
2018-06-06 10:00:00	QQQ	ETF	174.6	174.68	174.14	174.63	3037145.0
2018-06-06 11:00:00	QQQ	ETF	174.63	175.29	174.62	175.27	3132908.0
2018-06-06 12:00:00	QQQ	ETF	175.27	175.345	174.92	175.09	2003245.0
2018-06-06 13:00:00	QQQ	ETF	175.1	175.2	174.67	174.895	1887094.0
2018-06-06 14:00:00	QQQ	ETF	174.89	175.585	174.89	175.495	1863225.0
2018-06-06 15:00:00	QQQ	ETF	175.495	175.89	175.39	175.88	4337064.0
2018-06-06 16:00:00	QQQ	ETF	175.87	176.05	174.72	175.9499	1516451.0
2018-06-06 17:00:00	QQQ	ETF	175.94	176.09	175.94	176.02	16806.0
2018-06-06 18:00:00	QQQ	ETF	176.01	176.01	175.85	175.87	23608.0
2018-06-06 19:00:00	QQQ	ETF	175.84	175.88	175.79	175.83	25892.0
2018-06-06 04:00:00	IWM	ETF	165.73	165.73	165.73	165.73	100.0
2018-06-06 06:00:00	IWM	ETF	165.9	165.9	165.9	165.9	500.0
2018-06-06 07:00:00	IWM	ETF	165.89	165.92	165.76	165.88	27528.0
2018-06-06 08:00:00	IWM	ETF	165.8	165.8799	165.71	165.71	49819.0
2018-06-06 09:00:00	IWM	ETF	165.67	166.179	165.58	165.74	1713971.0
2018-06-06 10:00:00	IWM	ETF	165.75	166.12	165.58	165.97	1874933.0
2018-06-06 11:00:00	IWM	ETF	165.97	166.21	165.82	165.9999	2038138.0
2018-06-06 12:00:00	IWM	ETF	165.99	166.21	165.85	166.195	1247777.0
2018-06-06 13:00:00	IWM	ETF	166.2	166.31	166.07	166.2868	980523.0
2018-06-06 14:00:00	IWM	ETF	166.29	166.7	166.26	166.64	1878243.0
2018-06-06 15:00:00	IWM	ETF	166.64	166.92	166.6	166.92	3460475.0
2018-06-06 16:00:00	IWM	ETF	166.91	167.12	166.85	166.98	1260628.0
2018-06-06 17:00:00	IWM	ETF	166.96	167.0	166.96	166.97	3670.0
2018-06-06 18:00:00	IWM	ETF	166.96	167.0	166.87	166.87	10293.0
2018-06-06 19:00:00	IWM	ETF	166.89	166.89	166.81	166.83	6772.0
2018-06-06 04:00:00	DIA	ETF	248.54	249.01	248.54	249.01	938.0
2018-06-06 05:00:00	DIA	ETF	249.15	249.2	249.13	249.13	800.0
2018-06-06 06:00:00	DIA	ETF	249.31	249.31	249.31	249.31	150.0

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

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