PREVIEW / etf_1hour / 2018-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-15.parquet
  size:    302 KB
  rows:    9,918

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-15 04:00:00	SPY	ETF	277.34	277.34	276.08	276.38	90216.0
2018-06-15 05:00:00	SPY	ETF	276.43	276.61	276.28	276.33	33953.0
2018-06-15 06:00:00	SPY	ETF	276.31	276.46	275.94	276.4	92932.0
2018-06-15 07:00:00	SPY	ETF	276.46	276.94	276.38	276.74	426105.0
2018-06-15 08:00:00	SPY	ETF	276.74	277.48	275.95	276.1	1533311.0
2018-06-15 09:00:00	SPY	ETF	276.09	276.68	275.86	276.49	12013291.0
2018-06-15 10:00:00	SPY	ETF	276.48	276.8854	275.35	276.2131	15105687.0
2018-06-15 11:00:00	SPY	ETF	276.215	276.51	275.8701	276.35	25430424.0
2018-06-15 12:00:00	SPY	ETF	276.35	276.8854	276.09	276.5484	6897232.0
2018-06-15 13:00:00	SPY	ETF	276.56	276.63	276.19	276.235	7131168.0
2018-06-15 14:00:00	SPY	ETF	276.26	277.51	276.21	277.2352	8651400.0
2018-06-15 15:00:00	SPY	ETF	277.23	277.25	276.79	277.2	21074796.0
2018-06-15 16:00:00	SPY	ETF	277.21	277.39	276.86	276.93	11723808.0
2018-06-15 17:00:00	SPY	ETF	276.91	277.21	276.55	276.65	6691223.0
2018-06-15 18:00:00	SPY	ETF	276.65	276.71	276.51	276.64	169659.0
2018-06-15 19:00:00	SPY	ETF	276.62	276.69	276.54	276.54	48219.0
2018-06-15 04:00:00	QQQ	ETF	177.3	177.36	177.1	177.23	24107.0
2018-06-15 05:00:00	QQQ	ETF	177.22	177.34	177.22	177.23	12911.0
2018-06-15 06:00:00	QQQ	ETF	177.25	177.31	176.95	177.15	25277.0
2018-06-15 07:00:00	QQQ	ETF	177.24	177.62	177.01	177.44	69798.0
2018-06-15 08:00:00	QQQ	ETF	177.6	177.6	176.7	176.83	318694.0
2018-06-15 09:00:00	QQQ	ETF	176.84	177.1	176.11	176.72	7051831.0
2018-06-15 10:00:00	QQQ	ETF	176.725	177.035	176.251	176.8	6135254.0
2018-06-15 11:00:00	QQQ	ETF	176.8	176.95	176.51	176.79	2785760.0
2018-06-15 12:00:00	QQQ	ETF	176.79	177.14	176.7099	177.11	1584578.0
2018-06-15 13:00:00	QQQ	ETF	177.12	177.14	176.765	176.7962	2150063.0
2018-06-15 14:00:00	QQQ	ETF	176.81	177.325	176.725	177.15	4106806.0
2018-06-15 15:00:00	QQQ	ETF	177.1599	177.16	176.84	177.02	5907737.0
2018-06-15 16:00:00	QQQ	ETF	177.03	177.1	176.84	176.96	9321968.0
2018-06-15 17:00:00	QQQ	ETF	177.01	177.5743	176.75	176.75	250458.0
2018-06-15 18:00:00	QQQ	ETF	176.76	176.98	176.75	176.9	527178.0
2018-06-15 19:00:00	QQQ	ETF	176.85	176.88	176.85	176.87	3876.0
2018-06-15 04:00:00	IWM	ETF	167.28	167.28	167.14	167.14	1300.0
2018-06-15 06:00:00	IWM	ETF	167.06	167.27	167.06	167.24	10350.0
2018-06-15 07:00:00	IWM	ETF	167.27	167.48	167.25	167.42	32636.0
2018-06-15 08:00:00	IWM	ETF	167.4801	167.4801	166.97	166.98	73811.0
2018-06-15 09:00:00	IWM	ETF	167.05	167.26	166.68	167.08	2051114.0
2018-06-15 10:00:00	IWM	ETF	167.08	167.42	166.53	167.225	4107742.0
2018-06-15 11:00:00	IWM	ETF	167.22	167.48	166.86	167.1233	1909241.0
2018-06-15 12:00:00	IWM	ETF	167.13	167.365	166.97	167.3601	1159611.0
2018-06-15 13:00:00	IWM	ETF	167.37	167.6438	167.33	167.5	1147748.0
2018-06-15 14:00:00	IWM	ETF	167.51	167.87	167.46	167.81	2033645.0
2018-06-15 15:00:00	IWM	ETF	167.82	167.82	167.51	167.75	4694964.0
2018-06-15 16:00:00	IWM	ETF	167.76	167.97	167.4017	167.65	1905093.0
2018-06-15 17:00:00	IWM	ETF	167.78	167.78	167.64	167.64	3099.0
2018-06-15 18:00:00	IWM	ETF	167.58	167.81	167.58	167.81	1005900.0
2018-06-15 04:00:00	DIA	ETF	251.99	251.99	250.23	250.47	10322.0
2018-06-15 05:00:00	DIA	ETF	250.5	250.5	250.5	250.5	100.0
2018-06-15 06:00:00	DIA	ETF	250.0	250.0	249.95	249.95	200.0
2018-06-15 07:00:00	DIA	ETF	250.38	250.5	250.24	250.5	1800.0

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

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