PREVIEW / etf_1hour / 2019-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-15.parquet
  size:    317 KB
  rows:    10,545

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-03-15 04:00:00	SPY	ETF	280.54	280.61	280.4	280.61	5356.0
2019-03-15 05:00:00	SPY	ETF	280.63	280.68	280.48	280.61	10891.0
2019-03-15 06:00:00	SPY	ETF	280.61	281.07	280.61	281.04	33784.0
2019-03-15 07:00:00	SPY	ETF	280.99	281.22	280.97	281.08	135111.0
2019-03-15 08:00:00	SPY	ETF	280.97	281.2	280.3	280.79	562516.0
2019-03-15 09:00:00	SPY	ETF	280.78	281.1	280.1	280.83	8642193.0
2019-03-15 10:00:00	SPY	ETF	280.82	280.9	280.33	280.67	8290056.0
2019-03-15 11:00:00	SPY	ETF	280.68	281.69	280.55	281.51	9557415.0
2019-03-15 12:00:00	SPY	ETF	281.51	282.21	281.4	281.9	8585097.0
2019-03-15 13:00:00	SPY	ETF	281.91	282.04	281.6625	281.725	4630183.0
2019-03-15 14:00:00	SPY	ETF	281.725	281.769	281.33	281.55	9717347.0
2019-03-15 15:00:00	SPY	ETF	281.555	281.56	280.91	281.35	20144553.0
2019-03-15 16:00:00	SPY	ETF	281.37	281.64	281.052	281.48	6883531.0
2019-03-15 17:00:00	SPY	ETF	281.51	281.52	281.0	281.15	714628.0
2019-03-15 18:00:00	SPY	ETF	281.15	281.3371	281.04	281.19	333652.0
2019-03-15 19:00:00	SPY	ETF	281.17	281.22	281.07	281.11	49592.0
2019-03-15 04:00:00	QQQ	ETF	177.17	177.49	177.17	177.41	21663.0
2019-03-15 05:00:00	QQQ	ETF	177.44	177.44	177.35	177.4	24500.0
2019-03-15 06:00:00	QQQ	ETF	177.44	177.77	177.43	177.77	130883.0
2019-03-15 07:00:00	QQQ	ETF	177.73	177.78	177.54	177.63	126894.0
2019-03-15 08:00:00	QQQ	ETF	177.72	177.78	177.21	177.47	173450.0
2019-03-15 09:00:00	QQQ	ETF	177.48	178.2	177.07	178.06	4810093.0
2019-03-15 10:00:00	QQQ	ETF	178.06	178.14	177.6	177.97	4058900.0
2019-03-15 11:00:00	QQQ	ETF	177.98	178.43	177.88	178.34	3572433.0
2019-03-15 12:00:00	QQQ	ETF	178.34	178.8	178.26	178.545	3550011.0
2019-03-15 13:00:00	QQQ	ETF	178.55	178.88	178.533	178.75	2292082.0
2019-03-15 14:00:00	QQQ	ETF	178.745	178.75	178.54	178.61	2321555.0
2019-03-15 15:00:00	QQQ	ETF	178.61	178.62	178.0	178.27	5803068.0
2019-03-15 16:00:00	QQQ	ETF	178.28	178.52	178.14	178.44	1796455.0
2019-03-15 17:00:00	QQQ	ETF	178.48	178.49	178.27	178.33	137400.0
2019-03-15 18:00:00	QQQ	ETF	178.32	178.38	178.32	178.36	11045.0
2019-03-15 19:00:00	QQQ	ETF	178.36	178.39	178.3	178.33	21489.0
2019-03-15 05:00:00	IWM	ETF	154.67	154.67	154.67	154.67	1000.0
2019-03-15 06:00:00	IWM	ETF	154.65	154.89	154.65	154.89	7000.0
2019-03-15 07:00:00	IWM	ETF	154.89	155.0	154.87	154.95	8380.0
2019-03-15 08:00:00	IWM	ETF	155.03	155.03	154.76	154.8	147699.0
2019-03-15 09:00:00	IWM	ETF	154.69	155.24	154.42	154.93	2194683.0
2019-03-15 10:00:00	IWM	ETF	154.93	155.39	154.73	155.36	1785786.0
2019-03-15 11:00:00	IWM	ETF	155.37	155.48	155.0017	155.3	1601211.0
2019-03-15 12:00:00	IWM	ETF	155.31	155.87	155.25	155.67	1670576.0
2019-03-15 13:00:00	IWM	ETF	155.68	155.83	155.44	155.48	1305625.0
2019-03-15 14:00:00	IWM	ETF	155.48	155.55	155.21	155.35	1598459.0
2019-03-15 15:00:00	IWM	ETF	155.34	155.345	154.33	154.76	5156111.0
2019-03-15 16:00:00	IWM	ETF	154.76	154.97	154.71	154.91	966896.0
2019-03-15 17:00:00	IWM	ETF	154.98	154.98	154.76	154.76	698.0
2019-03-15 18:00:00	IWM	ETF	154.76	154.76	154.76	154.76	500.0
2019-03-15 19:00:00	IWM	ETF	154.71	154.76	154.71	154.76	2655.0
2019-03-15 04:00:00	DIA	ETF	257.57	257.57	257.57	257.57	100.0
2019-03-15 05:00:00	DIA	ETF	257.68	257.68	257.68	257.68	400.0
2019-03-15 06:00:00	DIA	ETF	257.9	257.9	257.9	257.9	3000.0

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

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