PREVIEW / etf_1hour / 2019-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-13.parquet
  size:    352 KB
  rows:    11,522

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-12-13 04:00:00	SPY	ETF	318.36	318.53	318.03	318.44	33290.0
2019-12-13 05:00:00	SPY	ETF	318.5	318.79	318.5	318.75	17857.0
2019-12-13 06:00:00	SPY	ETF	318.6	318.6	318.26	318.36	30083.0
2019-12-13 07:00:00	SPY	ETF	318.38	318.44	316.57	317.39	840244.0
2019-12-13 08:00:00	SPY	ETF	318.3299	318.76	317.04	317.96	1271636.0
2019-12-13 09:00:00	SPY	ETF	317.99	317.99	316.31	317.305	9304922.0
2019-12-13 10:00:00	SPY	ETF	317.305	318.67	316.51	316.55	24711044.0
2019-12-13 11:00:00	SPY	ETF	316.54	317.18	316.02	317.12	8549175.0
2019-12-13 12:00:00	SPY	ETF	317.11	317.51	316.94	317.49	6302373.0
2019-12-13 13:00:00	SPY	ETF	317.49	317.56	317.19	317.425	7343861.0
2019-12-13 14:00:00	SPY	ETF	317.43	317.5	317.08	317.3	4739342.0
2019-12-13 15:00:00	SPY	ETF	317.3	317.5	317.15	317.28	10050655.0
2019-12-13 16:00:00	SPY	ETF	317.27	317.52	317.26	317.49	7306269.0
2019-12-13 17:00:00	SPY	ETF	317.48	317.54	317.32	317.34	272633.0
2019-12-13 18:00:00	SPY	ETF	317.4	317.4	317.27	317.32	22813.0
2019-12-13 19:00:00	SPY	ETF	317.32	317.32	317.23	317.25	19939.0
2019-12-13 04:00:00	QQQ	ETF	207.66	207.71	207.55	207.62	27087.0
2019-12-13 05:00:00	QQQ	ETF	207.69	207.94	207.66	207.9	28648.0
2019-12-13 06:00:00	QQQ	ETF	207.87	207.89	207.55	207.62	22975.0
2019-12-13 07:00:00	QQQ	ETF	207.63	207.64	206.3	206.91	292815.0
2019-12-13 08:00:00	QQQ	ETF	206.91	207.75	206.74	207.3	274516.0
2019-12-13 09:00:00	QQQ	ETF	207.33	207.33	205.86	206.8996	4095364.0
2019-12-13 10:00:00	QQQ	ETF	206.87	207.91	206.54	206.69	10683341.0
2019-12-13 11:00:00	QQQ	ETF	206.6971	207.2	206.29	207.094	2874720.0
2019-12-13 12:00:00	QQQ	ETF	207.09	207.51	207.07	207.49	1756804.0
2019-12-13 13:00:00	QQQ	ETF	207.5	207.53	207.19	207.305	1157437.0
2019-12-13 14:00:00	QQQ	ETF	207.31	207.36	207.11	207.29	857273.0
2019-12-13 15:00:00	QQQ	ETF	207.3	207.41	207.1	207.19	3227743.0
2019-12-13 16:00:00	QQQ	ETF	207.19	207.3	207.1	207.26	1533780.0
2019-12-13 17:00:00	QQQ	ETF	207.22	207.32	207.19	207.25	14419.0
2019-12-13 18:00:00	QQQ	ETF	207.2	207.28	207.2	207.25	6852.0
2019-12-13 19:00:00	QQQ	ETF	207.26	207.27	207.2	207.2	7458.0
2019-12-13 04:00:00	IWM	ETF	164.92	164.95	164.82	164.83	4251.0
2019-12-13 05:00:00	IWM	ETF	164.89	165.04	164.89	165.04	2800.0
2019-12-13 06:00:00	IWM	ETF	164.91	164.91	164.78	164.8	2200.0
2019-12-13 07:00:00	IWM	ETF	164.821	164.9	163.99	164.24	81371.0
2019-12-13 08:00:00	IWM	ETF	164.6701	164.8	164.09	164.41	157755.0
2019-12-13 09:00:00	IWM	ETF	164.38	164.47	163.21	163.8	1736207.0
2019-12-13 10:00:00	IWM	ETF	163.8	164.81	163.05	163.1	4694595.0
2019-12-13 11:00:00	IWM	ETF	163.1094	163.45	162.55	163.26	2574611.0
2019-12-13 12:00:00	IWM	ETF	163.2608	163.44	163.04	163.42	1389290.0
2019-12-13 13:00:00	IWM	ETF	163.42	163.51	163.11	163.1769	782252.0
2019-12-13 14:00:00	IWM	ETF	163.18	163.22	162.97	163.0483	841551.0
2019-12-13 15:00:00	IWM	ETF	163.05	163.3	162.88	163.28	3361211.0
2019-12-13 16:00:00	IWM	ETF	163.29	163.5	163.233	163.46	957547.0
2019-12-13 17:00:00	IWM	ETF	163.4	163.41	163.33	163.33	212427.0
2019-12-13 18:00:00	IWM	ETF	163.39	163.4	163.33	163.38	59241.0
2019-12-13 19:00:00	IWM	ETF	163.33	163.35	163.33	163.35	685.0
2019-12-13 04:00:00	DIA	ETF	283.11	283.11	283.0	283.0	17928.0
2019-12-13 05:00:00	DIA	ETF	283.25	283.39	283.25	283.39	3646.0

> showing 50 of 11,522 rows — these rows as CSV

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