PREVIEW / etf_1hour / 2018-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-15.parquet
  size:    318 KB
  rows:    10,328

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-15 04:00:00	SPY	ETF	283.7	283.71	283.5	283.55	9623.0
2018-08-15 05:00:00	SPY	ETF	283.58	283.59	283.2	283.22	12555.0
2018-08-15 06:00:00	SPY	ETF	283.2	283.29	282.35	282.4	230453.0
2018-08-15 07:00:00	SPY	ETF	282.47	282.7	282.0	282.41	739254.0
2018-08-15 08:00:00	SPY	ETF	282.39	283.38	282.0501	282.14	515892.0
2018-08-15 09:00:00	SPY	ETF	282.16	282.54	281.34	281.345	9748167.0
2018-08-15 10:00:00	SPY	ETF	281.345	281.36	280.16	280.29	18005441.0
2018-08-15 11:00:00	SPY	ETF	280.28	281.47	280.23	280.61	13212091.0
2018-08-15 12:00:00	SPY	ETF	280.6	281.69	280.6	281.4616	8625530.0
2018-08-15 13:00:00	SPY	ETF	281.46	281.77	280.94	281.0199	6829461.0
2018-08-15 14:00:00	SPY	ETF	281.01	281.27	280.45	281.26	9169482.0
2018-08-15 15:00:00	SPY	ETF	281.255	282.1	281.2	281.76	23589983.0
2018-08-15 16:00:00	SPY	ETF	281.76	282.15	281.7316	282.12	10185147.0
2018-08-15 17:00:00	SPY	ETF	282.09	282.11	282.01	282.03	346935.0
2018-08-15 18:00:00	SPY	ETF	282.05	282.17	281.93	282.02	87282.0
2018-08-15 19:00:00	SPY	ETF	282.03	282.05	281.86	281.93	44434.0
2018-08-15 04:00:00	QQQ	ETF	181.4	181.44	181.31	181.35	14170.0
2018-08-15 05:00:00	QQQ	ETF	181.39	181.39	181.14	181.14	13836.0
2018-08-15 06:00:00	QQQ	ETF	181.14	181.15	180.22	180.31	84155.0
2018-08-15 07:00:00	QQQ	ETF	180.3	180.4	179.78	180.04	367540.0
2018-08-15 08:00:00	QQQ	ETF	179.7801	181.38	179.78	179.89	521381.0
2018-08-15 09:00:00	QQQ	ETF	179.88	180.58	179.5	179.51	6068969.0
2018-08-15 10:00:00	QQQ	ETF	179.51	179.51	178.12	178.32	10752116.0
2018-08-15 11:00:00	QQQ	ETF	178.3101	179.1	178.26	178.299	8362502.0
2018-08-15 12:00:00	QQQ	ETF	178.28	179.22	178.28	179.0	3829133.0
2018-08-15 13:00:00	QQQ	ETF	179.01	179.28	178.64	178.76	3723244.0
2018-08-15 14:00:00	QQQ	ETF	178.755	178.99	178.36	178.9899	3579645.0
2018-08-15 15:00:00	QQQ	ETF	178.9758	179.52	178.92	179.29	9381025.0
2018-08-15 16:00:00	QQQ	ETF	179.28	179.7	179.23	179.66	2251632.0
2018-08-15 17:00:00	QQQ	ETF	179.68	179.6899	179.59	179.65	3141.0
2018-08-15 18:00:00	QQQ	ETF	179.66	179.67	179.49	179.5	15225.0
2018-08-15 19:00:00	QQQ	ETF	179.51	179.5199	179.4	179.44	14560.0
2018-08-15 05:00:00	IWM	ETF	168.08	168.08	168.08	168.08	100.0
2018-08-15 06:00:00	IWM	ETF	168.01	168.01	167.71	167.8	5100.0
2018-08-15 07:00:00	IWM	ETF	167.66	167.87	167.42	167.66	96547.0
2018-08-15 08:00:00	IWM	ETF	167.68	167.86	167.53	167.6	215273.0
2018-08-15 09:00:00	IWM	ETF	167.58	167.82	166.76	166.78	2573951.0
2018-08-15 10:00:00	IWM	ETF	166.76	166.77	165.16	165.1802	5522439.0
2018-08-15 11:00:00	IWM	ETF	165.18	166.46	165.15	165.77	3311080.0
2018-08-15 12:00:00	IWM	ETF	165.76	166.58	165.75	166.365	2213310.0
2018-08-15 13:00:00	IWM	ETF	166.37	166.505	165.78	165.78	1219046.0
2018-08-15 14:00:00	IWM	ETF	165.77	166.0	165.45	165.9868	2570238.0
2018-08-15 15:00:00	IWM	ETF	165.97	166.23	165.73	166.09	4379493.0
2018-08-15 16:00:00	IWM	ETF	166.09	166.38	166.0558	166.35	1116074.0
2018-08-15 17:00:00	IWM	ETF	166.3	166.3	166.24	166.25	1900.0
2018-08-15 18:00:00	IWM	ETF	166.25	166.34	166.09	166.27	5810.0
2018-08-15 19:00:00	IWM	ETF	166.29	166.29	166.29	166.29	1495.0
2018-08-15 05:00:00	DIA	ETF	252.5	252.5	252.5	252.5	100.0
2018-08-15 06:00:00	DIA	ETF	252.31	252.31	251.73	251.73	2700.0
2018-08-15 07:00:00	DIA	ETF	251.82	252.02	251.39	251.7	9696.0

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

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