PREVIEW / etf_30min / 2020-05-21

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-21.parquet
  size:    532 KB
  rows:    19,916

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-05-21 04:00:00	SPY	ETF	295.66	295.72	294.64	294.83	71923.0
2020-05-21 04:30:00	SPY	ETF	294.83	295.65	294.83	295.53	17437.0
2020-05-21 05:00:00	SPY	ETF	295.68	295.79	295.07	295.55	40904.0
2020-05-21 05:30:00	SPY	ETF	295.48	295.51	295.0	295.0	8478.0
2020-05-21 06:00:00	SPY	ETF	294.98	295.66	294.77	295.61	54773.0
2020-05-21 06:30:00	SPY	ETF	295.52	295.58	295.31	295.44	41181.0
2020-05-21 07:00:00	SPY	ETF	295.47	296.27	295.47	296.12	336672.0
2020-05-21 07:30:00	SPY	ETF	296.13	296.21	295.64	295.69	255421.0
2020-05-21 08:00:00	SPY	ETF	295.69	296.21	295.01	295.82	486321.0
2020-05-21 08:30:00	SPY	ETF	295.8	296.76	295.6	296.44	422483.0
2020-05-21 09:00:00	SPY	ETF	296.4	296.84	296.2	296.79	233020.0
2020-05-21 09:30:00	SPY	ETF	296.79	297.67	296.265	297.135	6924208.0
2020-05-21 10:00:00	SPY	ETF	297.13	297.43	296.36	296.79	4377074.0
2020-05-21 10:30:00	SPY	ETF	296.7977	296.7977	295.26	295.83	6527857.0
2020-05-21 11:00:00	SPY	ETF	295.825	295.825	293.6886	294.3	6718110.0
2020-05-21 11:30:00	SPY	ETF	294.33	295.35	294.23	294.87	5702126.0
2020-05-21 12:00:00	SPY	ETF	294.87	295.93	294.85	295.38	3677599.0
2020-05-21 12:30:00	SPY	ETF	295.37	295.4584	294.58	294.95	3981675.0
2020-05-21 13:00:00	SPY	ETF	294.95	295.82	294.73	295.29	4361350.0
2020-05-21 13:30:00	SPY	ETF	295.29	295.45	294.84	295.19	2564188.0
2020-05-21 14:00:00	SPY	ETF	295.2	295.81	295.09	295.6633	3198518.0
2020-05-21 14:30:00	SPY	ETF	295.66	295.7999	294.38	294.72	4691618.0
2020-05-21 15:00:00	SPY	ETF	294.715	295.66	294.71	295.3	5482792.0
2020-05-21 15:30:00	SPY	ETF	295.29	295.475	294.51	294.79	10387267.0
2020-05-21 16:00:00	SPY	ETF	294.78	297.0247	294.0	294.08	3742654.0
2020-05-21 16:30:00	SPY	ETF	294.08	294.88	294.04	294.08	2187782.0
2020-05-21 17:00:00	SPY	ETF	294.1	294.88	294.07	294.18	71634.0
2020-05-21 17:30:00	SPY	ETF	294.18	294.88	294.16	294.2	45637.0
2020-05-21 18:00:00	SPY	ETF	294.17	294.9	293.8	294.85	185477.0
2020-05-21 18:30:00	SPY	ETF	294.9	294.97	294.65	294.78	78171.0
2020-05-21 19:00:00	SPY	ETF	294.81	295.14	294.8	294.95	58119.0
2020-05-21 19:30:00	SPY	ETF	295.06	295.4	295.06	295.37	119154.0
2020-05-21 04:00:00	QQQ	ETF	231.0	231.0	229.75	229.88	34319.0
2020-05-21 04:30:00	QQQ	ETF	230.03	230.4	229.92	230.3	7942.0
2020-05-21 05:00:00	QQQ	ETF	230.4	230.52	230.09	230.41	11508.0
2020-05-21 05:30:00	QQQ	ETF	230.4	230.4	230.05	230.05	21424.0
2020-05-21 06:00:00	QQQ	ETF	230.0	230.39	229.85	230.39	17909.0
2020-05-21 06:30:00	QQQ	ETF	230.29	230.35	230.19	230.29	8208.0
2020-05-21 07:00:00	QQQ	ETF	230.33	230.98	230.33	230.9	97600.0
2020-05-21 07:30:00	QQQ	ETF	230.9	230.95	230.64	230.68	95889.0
2020-05-21 08:00:00	QQQ	ETF	230.68	230.97	230.0	230.68	120480.0
2020-05-21 08:30:00	QQQ	ETF	230.63	231.36	230.52	231.23	200829.0
2020-05-21 09:00:00	QQQ	ETF	231.13	231.52	231.03	231.47	119877.0
2020-05-21 09:30:00	QQQ	ETF	231.47	232.135	230.8	231.25	4615725.0
2020-05-21 10:00:00	QQQ	ETF	231.25	231.4	230.19	230.59	3497285.0
2020-05-21 10:30:00	QQQ	ETF	230.58	230.585	229.17	229.97	3809312.0
2020-05-21 11:00:00	QQQ	ETF	229.95	229.95	228.34	228.99	3338285.0
2020-05-21 11:30:00	QQQ	ETF	229.0	229.86	228.9004	229.38	2261632.0
2020-05-21 12:00:00	QQQ	ETF	229.38	230.33	229.37	229.88	2150754.0
2020-05-21 12:30:00	QQQ	ETF	229.88	229.9	229.33	229.46	1444538.0

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

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