PREVIEW / etf_1hour / 2020-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-27.parquet
  size:    368 KB
  rows:    12,671

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
2020-07-27 04:00:00	SPY	ETF	321.52	321.97	321.51	321.51	28150.0
2020-07-27 05:00:00	SPY	ETF	321.59	322.16	321.47	322.09	40618.0
2020-07-27 06:00:00	SPY	ETF	322.05	322.37	321.88	322.08	45052.0
2020-07-27 07:00:00	SPY	ETF	322.07	322.39	321.66	322.35	131794.0
2020-07-27 08:00:00	SPY	ETF	322.1004	322.38	320.88	321.75	416138.0
2020-07-27 09:00:00	SPY	ETF	321.7	322.73	320.775	322.62	6431389.0
2020-07-27 10:00:00	SPY	ETF	322.62	322.97	322.36	322.6	6884129.0
2020-07-27 11:00:00	SPY	ETF	322.59	322.64	321.18	321.9	6363425.0
2020-07-27 12:00:00	SPY	ETF	321.9	322.46	321.75	322.37	4406717.0
2020-07-27 13:00:00	SPY	ETF	322.39	322.76	322.3087	322.49	3458214.0
2020-07-27 14:00:00	SPY	ETF	322.5	322.9	322.17	322.38	3936119.0
2020-07-27 15:00:00	SPY	ETF	322.385	323.41	322.35	323.18	11321930.0
2020-07-27 16:00:00	SPY	ETF	323.18	323.52	323.08	323.47	3185735.0
2020-07-27 17:00:00	SPY	ETF	323.42	323.6	323.22	323.53	117908.0
2020-07-27 18:00:00	SPY	ETF	323.59	323.86	323.55	323.55	91398.0
2020-07-27 19:00:00	SPY	ETF	323.7	323.8	323.3	323.7	77012.0
2020-07-27 04:00:00	QQQ	ETF	256.64	256.92	256.55	256.64	48587.0
2020-07-27 05:00:00	QQQ	ETF	256.68	257.44	256.68	257.36	30645.0
2020-07-27 06:00:00	QQQ	ETF	257.33	258.26	257.11	257.86	74256.0
2020-07-27 07:00:00	QQQ	ETF	257.81	258.02	257.4	258.0	138708.0
2020-07-27 08:00:00	QQQ	ETF	257.2504	258.24	256.34	257.37	212255.0
2020-07-27 09:00:00	QQQ	ETF	257.37	259.29	256.52	259.05	4892637.0
2020-07-27 10:00:00	QQQ	ETF	259.08	259.45	257.94	258.56	5085825.0
2020-07-27 11:00:00	QQQ	ETF	258.54	258.655	256.445	257.6	4261621.0
2020-07-27 12:00:00	QQQ	ETF	257.6	258.4499	257.35	258.4	2261626.0
2020-07-27 13:00:00	QQQ	ETF	258.395	258.96	258.351	258.845	1798107.0
2020-07-27 14:00:00	QQQ	ETF	258.85	259.92	258.81	259.253	3290626.0
2020-07-27 15:00:00	QQQ	ETF	259.24	260.52	259.21	260.09	8669720.0
2020-07-27 16:00:00	QQQ	ETF	260.09	260.6	259.98	260.56	918303.0
2020-07-27 17:00:00	QQQ	ETF	260.56	260.62	260.45	260.59	17083.0
2020-07-27 18:00:00	QQQ	ETF	260.59	261.1	260.59	260.9	211460.0
2020-07-27 19:00:00	QQQ	ETF	260.98	261.18	260.61	260.96	213662.0
2020-07-27 04:00:00	IWM	ETF	146.5	146.7	146.4	146.4	5552.0
2020-07-27 05:00:00	IWM	ETF	146.4	146.58	146.4	146.58	400.0
2020-07-27 06:00:00	IWM	ETF	146.6	146.75	146.55	146.59	2837.0
2020-07-27 07:00:00	IWM	ETF	146.52	146.7	146.32	146.67	29077.0
2020-07-27 08:00:00	IWM	ETF	146.71	146.71	145.98	146.28	42676.0
2020-07-27 09:00:00	IWM	ETF	146.2	146.865	145.39	146.78	1850130.0
2020-07-27 10:00:00	IWM	ETF	146.79	147.23	146.46	146.56	1746445.0
2020-07-27 11:00:00	IWM	ETF	146.56	146.7	145.74	146.15	1720218.0
2020-07-27 12:00:00	IWM	ETF	146.155	146.645	146.095	146.58	919965.0
2020-07-27 13:00:00	IWM	ETF	146.6	146.935	146.54	146.74	536957.0
2020-07-27 14:00:00	IWM	ETF	146.735	147.0	146.48	146.855	790517.0
2020-07-27 15:00:00	IWM	ETF	146.84	147.69	146.83	147.63	3150114.0
2020-07-27 16:00:00	IWM	ETF	147.6	147.76	147.5	147.74	403985.0
2020-07-27 17:00:00	IWM	ETF	148.05	148.05	147.62	147.79	23130.0
2020-07-27 18:00:00	IWM	ETF	147.79	147.9	147.79	147.8	12500.0
2020-07-27 19:00:00	IWM	ETF	147.89	147.9	147.68	147.84	20045.0
2020-07-27 04:00:00	DIA	ETF	265.22	265.45	265.22	265.24	3180.0
2020-07-27 06:00:00	DIA	ETF	265.58	265.63	265.37	265.37	5600.0

> showing 50 of 12,671 rows — these rows as CSV

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