PREVIEW / etf_30min / 2020-07-28

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-28.parquet
  size:    535 KB
  rows:    19,882

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-28 04:00:00	SPY	ETF	323.4	323.41	323.08	323.22	17228.0
2020-07-28 04:30:00	SPY	ETF	323.2	323.48	323.18	323.4	7206.0
2020-07-28 05:00:00	SPY	ETF	323.53	323.6	323.09	323.2	17232.0
2020-07-28 05:30:00	SPY	ETF	323.1	323.2	322.12	322.4	34489.0
2020-07-28 06:00:00	SPY	ETF	322.44	322.44	321.79	322.31	59713.0
2020-07-28 06:30:00	SPY	ETF	322.3	322.71	322.3	322.67	18090.0
2020-07-28 07:00:00	SPY	ETF	322.68	322.84	321.9	322.03	114855.0
2020-07-28 07:30:00	SPY	ETF	322.0	322.12	321.59	321.98	72260.0
2020-07-28 08:00:00	SPY	ETF	322.0	323.7	321.59	322.12	137761.0
2020-07-28 08:30:00	SPY	ETF	322.14	322.5	322.03	322.48	121231.0
2020-07-28 09:00:00	SPY	ETF	322.47	322.47	322.07	322.3504	128418.0
2020-07-28 09:30:00	SPY	ETF	322.43	323.04	321.31	321.89	4397015.0
2020-07-28 10:00:00	SPY	ETF	321.88	322.965	321.71	322.825	3165358.0
2020-07-28 10:30:00	SPY	ETF	322.815	323.08	322.214	322.81	2231829.0
2020-07-28 11:00:00	SPY	ETF	322.82	323.2	322.12	322.93	3175528.0
2020-07-28 11:30:00	SPY	ETF	322.9325	323.5	322.86	322.93	2633873.0
2020-07-28 12:00:00	SPY	ETF	322.93	322.98	322.52	322.68	2335030.0
2020-07-28 12:30:00	SPY	ETF	322.68	323.055	322.55	323.02	2851876.0
2020-07-28 13:00:00	SPY	ETF	323.01	323.24	322.73	323.15	2201658.0
2020-07-28 13:30:00	SPY	ETF	323.1518	323.64	323.13	323.52	3736153.0
2020-07-28 14:00:00	SPY	ETF	323.54	323.61	323.125	323.14	2910068.0
2020-07-28 14:30:00	SPY	ETF	323.15	323.44	322.945	323.0	2057662.0
2020-07-28 15:00:00	SPY	ETF	323.0	323.09	321.96	322.01	5410649.0
2020-07-28 15:30:00	SPY	ETF	322.0	322.42	320.85	321.2	11947911.0
2020-07-28 16:00:00	SPY	ETF	321.22	321.55	320.98	321.27	5342082.0
2020-07-28 16:30:00	SPY	ETF	321.21	321.49	321.18	321.38	87773.0
2020-07-28 17:00:00	SPY	ETF	321.33	321.48	321.17	321.33	405293.0
2020-07-28 17:30:00	SPY	ETF	321.34	321.49	321.26	321.46	25871.0
2020-07-28 18:00:00	SPY	ETF	321.48	321.85	321.48	321.55	61493.0
2020-07-28 18:30:00	SPY	ETF	321.58	321.8	321.48	321.71	17534.0
2020-07-28 19:00:00	SPY	ETF	321.75	321.75	321.38	321.69	36197.0
2020-07-28 19:30:00	SPY	ETF	321.69	321.81	321.65	321.8	20327.0
2020-07-28 04:00:00	QQQ	ETF	260.64	260.71	259.98	260.05	28134.0
2020-07-28 04:30:00	QQQ	ETF	260.13	260.54	260.12	260.52	10275.0
2020-07-28 05:00:00	QQQ	ETF	260.55	260.67	260.06	260.36	10514.0
2020-07-28 05:30:00	QQQ	ETF	260.31	260.37	259.25	259.47	20962.0
2020-07-28 06:00:00	QQQ	ETF	259.48	259.53	259.0	259.41	30666.0
2020-07-28 06:30:00	QQQ	ETF	259.41	259.85	259.39	259.85	28594.0
2020-07-28 07:00:00	QQQ	ETF	259.88	260.08	259.03	259.19	218457.0
2020-07-28 07:30:00	QQQ	ETF	259.1	259.27	258.65	258.88	90914.0
2020-07-28 08:00:00	QQQ	ETF	259.3999	261.25	258.7	259.15	79609.0
2020-07-28 08:30:00	QQQ	ETF	259.16	259.69	259.13	259.68	62969.0
2020-07-28 09:00:00	QQQ	ETF	259.65	259.67	259.07	259.3	208033.0
2020-07-28 09:30:00	QQQ	ETF	259.37	259.71	257.56	258.27	4271249.0
2020-07-28 10:00:00	QQQ	ETF	258.27	259.14	257.95	258.97	2338156.0
2020-07-28 10:30:00	QQQ	ETF	258.96	259.36	258.27	259.2	1464424.0
2020-07-28 11:00:00	QQQ	ETF	259.22	259.49	258.39	259.12	1196983.0
2020-07-28 11:30:00	QQQ	ETF	259.13	259.85	258.891	258.99	1182438.0
2020-07-28 12:00:00	QQQ	ETF	258.99	259.185	258.42	259.03	1149100.0
2020-07-28 12:30:00	QQQ	ETF	259.03	259.465	258.8079	259.36	891077.0

> showing 50 of 19,882 rows — these rows as CSV

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