PREVIEW / etf_30min / 2020-07-17

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-17.parquet
  size:    526 KB
  rows:    19,626

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-17 04:00:00	SPY	ETF	319.66	320.27	319.6	320.07	12668.0
2020-07-17 04:30:00	SPY	ETF	320.2	320.41	320.2	320.3	5059.0
2020-07-17 05:00:00	SPY	ETF	320.15	320.65	319.97	320.58	6462.0
2020-07-17 05:30:00	SPY	ETF	320.55	320.64	320.32	320.32	9529.0
2020-07-17 06:00:00	SPY	ETF	320.4	321.0	320.35	320.96	76322.0
2020-07-17 06:30:00	SPY	ETF	320.98	321.03	320.88	320.95	16340.0
2020-07-17 07:00:00	SPY	ETF	320.97	320.97	320.64	320.76	32396.0
2020-07-17 07:30:00	SPY	ETF	320.77	320.97	320.61	320.88	81097.0
2020-07-17 08:00:00	SPY	ETF	320.815	321.73	320.0	321.61	381573.0
2020-07-17 08:30:00	SPY	ETF	321.61	321.82	321.23	321.3	251375.0
2020-07-17 09:00:00	SPY	ETF	321.28	321.98	321.2	321.88	315560.0
2020-07-17 09:30:00	SPY	ETF	321.88	322.089	320.93	321.315	5213919.0
2020-07-17 10:00:00	SPY	ETF	321.31	321.5	319.84	320.11	8521120.0
2020-07-17 10:30:00	SPY	ETF	320.1137	321.03	319.735	321.01	3128105.0
2020-07-17 11:00:00	SPY	ETF	321.0	321.42	320.94	321.16	2189968.0
2020-07-17 11:30:00	SPY	ETF	321.17	321.53	320.68	321.39	2428368.0
2020-07-17 12:00:00	SPY	ETF	321.38	321.675	321.27	321.45	2917291.0
2020-07-17 12:30:00	SPY	ETF	321.44	321.61	321.09	321.21	1666118.0
2020-07-17 13:00:00	SPY	ETF	321.21	321.5799	320.91	321.43	2520724.0
2020-07-17 13:30:00	SPY	ETF	321.44	321.47	321.0902	321.24	1291684.0
2020-07-17 14:00:00	SPY	ETF	321.25	322.09	321.24	321.93	2876137.0
2020-07-17 14:30:00	SPY	ETF	321.93	322.23	321.65	322.01	3158380.0
2020-07-17 15:00:00	SPY	ETF	322.005	322.3	321.67	322.298	5290982.0
2020-07-17 15:30:00	SPY	ETF	322.29	322.57	321.55	321.67	10854560.0
2020-07-17 16:00:00	SPY	ETF	321.67	322.11	321.31	321.5	7080715.0
2020-07-17 16:30:00	SPY	ETF	321.5	321.75	321.3	321.41	704064.0
2020-07-17 17:00:00	SPY	ETF	321.41	321.72	321.39	321.45	337274.0
2020-07-17 17:30:00	SPY	ETF	321.41	321.84	321.4	321.8	531515.0
2020-07-17 18:00:00	SPY	ETF	321.82	321.84	321.72	321.83	25630.0
2020-07-17 18:30:00	SPY	ETF	321.83	321.9	321.8	321.9	37979.0
2020-07-17 19:00:00	SPY	ETF	321.83	321.9	321.83	321.84	30068.0
2020-07-17 19:30:00	SPY	ETF	321.86	321.98	321.86	321.9	22797.0
2020-07-17 04:00:00	QQQ	ETF	258.16	259.02	257.9	258.73	52728.0
2020-07-17 04:30:00	QQQ	ETF	258.81	259.01	258.79	259.01	5780.0
2020-07-17 05:00:00	QQQ	ETF	258.79	259.19	258.7	259.13	8600.0
2020-07-17 05:30:00	QQQ	ETF	259.08	259.2	258.74	258.84	10250.0
2020-07-17 06:00:00	QQQ	ETF	258.8	259.13	258.8	259.13	7900.0
2020-07-17 06:30:00	QQQ	ETF	259.09	259.18	259.0	259.0	11253.0
2020-07-17 07:00:00	QQQ	ETF	259.01	259.08	258.75	258.88	48610.0
2020-07-17 07:30:00	QQQ	ETF	258.78	258.94	258.52	258.91	146553.0
2020-07-17 08:00:00	QQQ	ETF	258.8601	259.34	258.07	259.12	121364.0
2020-07-17 08:30:00	QQQ	ETF	259.12	259.29	258.88	259.07	160696.0
2020-07-17 09:00:00	QQQ	ETF	259.1	260.0	259.1	259.79	508783.0
2020-07-17 09:30:00	QQQ	ETF	259.71	259.87	257.86	258.77	4050907.0
2020-07-17 10:00:00	QQQ	ETF	258.75	259.0	257.17	257.51	2843129.0
2020-07-17 10:30:00	QQQ	ETF	257.53	258.56	257.21	258.49	1479281.0
2020-07-17 11:00:00	QQQ	ETF	258.48	259.17	258.38	258.995	1369281.0
2020-07-17 11:30:00	QQQ	ETF	259.0	259.145	258.16	258.98	1268345.0
2020-07-17 12:00:00	QQQ	ETF	258.98	259.39	258.86	258.96	1211361.0
2020-07-17 12:30:00	QQQ	ETF	258.98	259.27	258.61	258.83	674809.0

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

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