PREVIEW / etf_30min / 2020-07-15

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-15.parquet
  size:    556 KB
  rows:    20,964

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-15 04:00:00	SPY	ETF	320.68	321.08	320.46	320.71	15607.0
2020-07-15 04:30:00	SPY	ETF	320.99	321.07	320.45	320.58	5408.0
2020-07-15 05:00:00	SPY	ETF	320.4	320.58	320.11	320.39	17425.0
2020-07-15 05:30:00	SPY	ETF	320.2	320.45	320.11	320.22	69795.0
2020-07-15 06:00:00	SPY	ETF	320.25	321.37	320.15	321.27	63342.0
2020-07-15 06:30:00	SPY	ETF	321.4	322.23	321.31	322.01	83551.0
2020-07-15 07:00:00	SPY	ETF	322.04	322.88	321.9	322.55	443705.0
2020-07-15 07:30:00	SPY	ETF	322.55	322.83	322.35	322.76	275293.0
2020-07-15 08:00:00	SPY	ETF	322.4801	323.08	320.4	322.72	436187.0
2020-07-15 08:30:00	SPY	ETF	322.76	323.39	322.74	323.26	467787.0
2020-07-15 09:00:00	SPY	ETF	323.25	323.26	322.36	322.39	537491.0
2020-07-15 09:30:00	SPY	ETF	322.41	322.64	321.23	321.88	10224419.0
2020-07-15 10:00:00	SPY	ETF	321.88	322.5	321.13	322.46	6733179.0
2020-07-15 10:30:00	SPY	ETF	322.49	323.04	322.15	322.24	4405861.0
2020-07-15 11:00:00	SPY	ETF	322.2465	322.47	320.56	321.73	6389797.0
2020-07-15 11:30:00	SPY	ETF	321.71	321.83	319.74	319.75	5232634.0
2020-07-15 12:00:00	SPY	ETF	319.74	320.72	319.265	320.6361	5965105.0
2020-07-15 12:30:00	SPY	ETF	320.635	321.12	319.8	321.07	4467899.0
2020-07-15 13:00:00	SPY	ETF	321.08	321.63	320.7	321.33	4112239.0
2020-07-15 13:30:00	SPY	ETF	321.32	321.78	320.93	321.095	2175600.0
2020-07-15 14:00:00	SPY	ETF	321.1	322.19	320.77	321.88	4710572.0
2020-07-15 14:30:00	SPY	ETF	321.88	322.21	320.91	320.92	3348563.0
2020-07-15 15:00:00	SPY	ETF	320.9267	321.65	320.1908	321.58	5005577.0
2020-07-15 15:30:00	SPY	ETF	321.58	322.59	321.36	321.865	13302962.0
2020-07-15 16:00:00	SPY	ETF	321.87	322.1	321.62	322.03	4325283.0
2020-07-15 16:30:00	SPY	ETF	322.05	322.4	321.85	322.18	3023733.0
2020-07-15 17:00:00	SPY	ETF	322.12	322.3	322.0	322.13	404069.0
2020-07-15 17:30:00	SPY	ETF	322.18	322.31	322.14	322.31	23925.0
2020-07-15 18:00:00	SPY	ETF	322.31	322.8	322.25	322.66	153058.0
2020-07-15 18:30:00	SPY	ETF	322.55	322.6	321.7	321.84	113453.0
2020-07-15 19:00:00	SPY	ETF	321.81	322.08	321.77	322.03	45239.0
2020-07-15 19:30:00	SPY	ETF	322.08	322.17	321.72	321.85	81284.0
2020-07-15 04:00:00	QQQ	ETF	261.11	261.24	260.82	261.1	59743.0
2020-07-15 04:30:00	QQQ	ETF	261.23	261.23	260.84	260.89	4000.0
2020-07-15 05:00:00	QQQ	ETF	260.75	260.98	260.63	260.9	13432.0
2020-07-15 05:30:00	QQQ	ETF	260.93	260.93	260.3	260.5	93771.0
2020-07-15 06:00:00	QQQ	ETF	260.55	261.23	260.51	261.15	29564.0
2020-07-15 06:30:00	QQQ	ETF	261.18	261.81	261.11	261.81	19977.0
2020-07-15 07:00:00	QQQ	ETF	261.81	262.4	261.62	261.84	266532.0
2020-07-15 07:30:00	QQQ	ETF	261.88	261.91	261.23	261.46	238577.0
2020-07-15 08:00:00	QQQ	ETF	262.1101	262.37	260.47	261.6	265029.0
2020-07-15 08:30:00	QQQ	ETF	261.56	261.81	261.23	261.6	151033.0
2020-07-15 09:00:00	QQQ	ETF	261.64	261.88	260.96	261.68	273400.0
2020-07-15 09:30:00	QQQ	ETF	261.68	262.69	260.54	261.28	6801656.0
2020-07-15 10:00:00	QQQ	ETF	261.29	262.17	260.77	261.95	3463621.0
2020-07-15 10:30:00	QQQ	ETF	261.94	262.52	261.12	261.19	2442309.0
2020-07-15 11:00:00	QQQ	ETF	261.18	261.35	259.05	260.39	4572204.0
2020-07-15 11:30:00	QQQ	ETF	260.39	260.57	258.01	258.02	3798241.0
2020-07-15 12:00:00	QQQ	ETF	258.01	259.16	257.49	259.03	4027420.0
2020-07-15 12:30:00	QQQ	ETF	259.02	259.91	258.2	259.79	2216554.0

> showing 50 of 20,964 rows — these rows as CSV

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