PREVIEW / etf_1hour / 2019-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-31.parquet
  size:    332 KB
  rows:    10,908

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-01-31 04:00:00	SPY	ETF	268.16	268.39	268.04	268.05	21043.0
2019-01-31 05:00:00	SPY	ETF	268.01	268.19	267.78	268.0	17199.0
2019-01-31 06:00:00	SPY	ETF	268.03	268.3	267.92	268.3	48557.0
2019-01-31 07:00:00	SPY	ETF	268.28	268.28	267.83	268.16	355327.0
2019-01-31 08:00:00	SPY	ETF	268.13	268.56	267.52	267.74	549161.0
2019-01-31 09:00:00	SPY	ETF	267.7	268.03	267.21	267.95	8122303.0
2019-01-31 10:00:00	SPY	ETF	267.96	269.45	267.88	269.0	12923592.0
2019-01-31 11:00:00	SPY	ETF	269.0034	270.39	268.92	270.2841	11623513.0
2019-01-31 12:00:00	SPY	ETF	270.28	270.47	269.29	269.47	10879400.0
2019-01-31 13:00:00	SPY	ETF	269.4868	269.77	269.17	269.69	5550353.0
2019-01-31 14:00:00	SPY	ETF	269.69	269.89	269.27	269.65	5315654.0
2019-01-31 15:00:00	SPY	ETF	269.65	270.34	268.95	269.89	22207280.0
2019-01-31 16:00:00	SPY	ETF	269.86	270.88	269.66	270.76	22624090.0
2019-01-31 17:00:00	SPY	ETF	270.82	271.0	269.93	270.51	512093.0
2019-01-31 18:00:00	SPY	ETF	270.52	270.52	269.95	270.04	256102.0
2019-01-31 19:00:00	SPY	ETF	270.1	270.65	270.08	270.42	128041.0
2019-01-31 04:00:00	QQQ	ETF	167.07	167.12	166.85	166.87	41413.0
2019-01-31 05:00:00	QQQ	ETF	166.93	167.03	166.69	166.95	17497.0
2019-01-31 06:00:00	QQQ	ETF	166.86	167.19	166.85	167.19	20425.0
2019-01-31 07:00:00	QQQ	ETF	167.17	167.35	167.01	167.24	138437.0
2019-01-31 08:00:00	QQQ	ETF	167.11	167.34	165.68	166.8201	172329.0
2019-01-31 09:00:00	QQQ	ETF	166.82	167.41	166.44	167.32	4546276.0
2019-01-31 10:00:00	QQQ	ETF	167.33	168.25	167.21	167.91	5280521.0
2019-01-31 11:00:00	QQQ	ETF	167.9	168.96	167.8501	168.825	3399677.0
2019-01-31 12:00:00	QQQ	ETF	168.815	168.99	168.15	168.35	3511963.0
2019-01-31 13:00:00	QQQ	ETF	168.35	168.5864	167.9	168.38	2852907.0
2019-01-31 14:00:00	QQQ	ETF	168.38	168.49	167.96	168.165	2350726.0
2019-01-31 15:00:00	QQQ	ETF	168.17	168.35	167.51	168.16	7482937.0
2019-01-31 16:00:00	QQQ	ETF	168.16	168.8	167.77	168.68	2160176.0
2019-01-31 17:00:00	QQQ	ETF	168.62	168.71	167.91	167.95	186451.0
2019-01-31 18:00:00	QQQ	ETF	167.95	168.09	167.6	167.7	247187.0
2019-01-31 19:00:00	QQQ	ETF	167.67	168.03	167.67	167.9	139178.0
2019-01-31 05:00:00	IWM	ETF	148.0	148.0	147.98	147.98	1500.0
2019-01-31 06:00:00	IWM	ETF	147.99	148.02	147.97	147.98	17900.0
2019-01-31 07:00:00	IWM	ETF	148.09	148.12	147.87	148.08	18312.0
2019-01-31 08:00:00	IWM	ETF	148.18	148.18	147.73	147.73	45929.0
2019-01-31 09:00:00	IWM	ETF	147.72	148.3881	147.51	148.285	1734619.0
2019-01-31 10:00:00	IWM	ETF	148.29	149.19	148.2	148.78	4568718.0
2019-01-31 11:00:00	IWM	ETF	148.77	149.3	148.64	149.25	1665711.0
2019-01-31 12:00:00	IWM	ETF	149.25	149.28	148.54	148.66	2287638.0
2019-01-31 13:00:00	IWM	ETF	148.66	148.89	148.43	148.68	1678813.0
2019-01-31 14:00:00	IWM	ETF	148.685	148.86	148.6	148.75	1590699.0
2019-01-31 15:00:00	IWM	ETF	148.755	149.17	148.2	148.98	5823474.0
2019-01-31 16:00:00	IWM	ETF	148.98	149.48	148.8	149.4	3131193.0
2019-01-31 17:00:00	IWM	ETF	149.4	149.41	149.31	149.31	6381.0
2019-01-31 18:00:00	IWM	ETF	149.33	149.33	149.06	149.12	211725.0
2019-01-31 19:00:00	IWM	ETF	149.35	149.42	149.35	149.42	300.0
2019-01-31 04:00:00	DIA	ETF	250.1	250.1	250.01	250.01	1400.0
2019-01-31 05:00:00	DIA	ETF	249.86	249.86	249.85	249.85	1000.0
2019-01-31 06:00:00	DIA	ETF	250.04	250.04	250.02	250.02	1125.0

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

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