PREVIEW / etf_1hour / 2018-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-12.parquet
  size:    296 KB
  rows:    9,718

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-12 04:00:00	SPY	ETF	278.86	278.91	278.36	278.48	12664.0
2018-06-12 05:00:00	SPY	ETF	278.62	278.62	278.33	278.46	12798.0
2018-06-12 06:00:00	SPY	ETF	278.25	278.39	278.24	278.36	37692.0
2018-06-12 07:00:00	SPY	ETF	278.4	278.71	278.24	278.71	147466.0
2018-06-12 08:00:00	SPY	ETF	278.72	279.04	278.39	278.93	275183.0
2018-06-12 09:00:00	SPY	ETF	278.94	279.08	278.56	278.68	6633028.0
2018-06-12 10:00:00	SPY	ETF	278.69	279.02	278.63	278.905	5087290.0
2018-06-12 11:00:00	SPY	ETF	278.91	279.24	278.6	279.19	10203874.0
2018-06-12 12:00:00	SPY	ETF	279.2	279.33	278.98	279.07	5761130.0
2018-06-12 13:00:00	SPY	ETF	279.06	279.15	278.81	279.08	5078551.0
2018-06-12 14:00:00	SPY	ETF	279.08	279.0899	278.22	278.23	8894161.0
2018-06-12 15:00:00	SPY	ETF	278.2399	279.07	278.19	278.98	17990886.0
2018-06-12 16:00:00	SPY	ETF	278.99	279.27	278.7	279.15	9260978.0
2018-06-12 17:00:00	SPY	ETF	279.14	279.22	279.0	279.09	452933.0
2018-06-12 18:00:00	SPY	ETF	279.13	279.25	279.0	279.19	44542.0
2018-06-12 19:00:00	SPY	ETF	279.19	279.28	279.0108	279.22	142170.0
2018-06-12 04:00:00	QQQ	ETF	174.88	175.1	174.64	174.74	62596.0
2018-06-12 05:00:00	QQQ	ETF	174.67	174.82	174.63	174.74	26150.0
2018-06-12 06:00:00	QQQ	ETF	174.61	175.0	174.58	174.68	22300.0
2018-06-12 07:00:00	QQQ	ETF	174.72	174.87	174.63	174.86	29732.0
2018-06-12 08:00:00	QQQ	ETF	174.72	175.12	174.68	175.12	123980.0
2018-06-12 09:00:00	QQQ	ETF	175.14	175.47	174.96	175.02	2463770.0
2018-06-12 10:00:00	QQQ	ETF	175.015	175.39	174.98	175.37	2294931.0
2018-06-12 11:00:00	QQQ	ETF	175.38	175.8049	175.19	175.75	2087932.0
2018-06-12 12:00:00	QQQ	ETF	175.7515	175.84	175.64	175.73	1596253.0
2018-06-12 13:00:00	QQQ	ETF	175.735	176.0	175.7049	175.97	1908566.0
2018-06-12 14:00:00	QQQ	ETF	175.96	175.98	175.11	175.126	2945419.0
2018-06-12 15:00:00	QQQ	ETF	175.1238	175.89	175.07	175.83	4380720.0
2018-06-12 16:00:00	QQQ	ETF	175.83	176.0	175.53	175.97	1054246.0
2018-06-12 17:00:00	QQQ	ETF	175.87	175.94	175.85	175.88	23856.0
2018-06-12 18:00:00	QQQ	ETF	175.91	176.13	175.84	176.07	46771.0
2018-06-12 19:00:00	QQQ	ETF	176.1	176.16	176.06	176.1	20122.0
2018-06-12 04:00:00	IWM	ETF	166.77	166.77	166.64	166.69	1000.0
2018-06-12 05:00:00	IWM	ETF	166.69	166.69	166.69	166.69	500.0
2018-06-12 07:00:00	IWM	ETF	166.59	166.75	166.51	166.75	19450.0
2018-06-12 08:00:00	IWM	ETF	166.69	166.77	166.6	166.71	40438.0
2018-06-12 09:00:00	IWM	ETF	166.83	167.2599	166.73	166.98	1139634.0
2018-06-12 10:00:00	IWM	ETF	166.97	167.57	166.89	167.5067	2003311.0
2018-06-12 11:00:00	IWM	ETF	167.51	167.83	167.37	167.805	1777724.0
2018-06-12 12:00:00	IWM	ETF	167.81	167.94	167.57	167.63	1278319.0
2018-06-12 13:00:00	IWM	ETF	167.62	167.74	167.41	167.59	984883.0
2018-06-12 14:00:00	IWM	ETF	167.58	167.58	166.85	166.85	1397060.0
2018-06-12 15:00:00	IWM	ETF	166.85	167.51	166.83	167.51	2733392.0
2018-06-12 16:00:00	IWM	ETF	167.5	167.62	167.33	167.62	640674.0
2018-06-12 17:00:00	IWM	ETF	167.42	167.53	167.42	167.53	621.0
2018-06-12 18:00:00	IWM	ETF	167.53	167.55	167.5	167.53	3108.0
2018-06-12 19:00:00	IWM	ETF	167.58	167.67	167.58	167.62	5100.0
2018-06-12 04:00:00	DIA	ETF	253.6	253.7	253.6	253.65	5000.0
2018-06-12 06:00:00	DIA	ETF	253.03	253.03	253.03	253.03	200.0
2018-06-12 07:00:00	DIA	ETF	253.1	253.33	252.96	253.33	2470.0

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

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