PREVIEW / etf_30min / 2020-02-05

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-05.parquet
  size:    547 KB
  rows:    19,716

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-02-05 04:00:00	SPY	ETF	330.98	332.01	330.81	331.89	61248.0
2020-02-05 04:30:00	SPY	ETF	331.9	332.6	331.9	332.4	49283.0
2020-02-05 05:00:00	SPY	ETF	332.34	332.5	332.0	332.0	19036.0
2020-02-05 05:30:00	SPY	ETF	332.0	332.14	331.83	332.06	14771.0
2020-02-05 06:00:00	SPY	ETF	331.96	332.32	331.93	332.22	60246.0
2020-02-05 06:30:00	SPY	ETF	332.22	332.27	331.49	331.61	72315.0
2020-02-05 07:00:00	SPY	ETF	331.55	332.0	331.47	331.89	88873.0
2020-02-05 07:30:00	SPY	ETF	331.89	332.0	331.58	331.63	103831.0
2020-02-05 08:00:00	SPY	ETF	331.94	332.29	328.48	332.15	382832.0
2020-02-05 08:30:00	SPY	ETF	332.19	332.34	332.06	332.27	218188.0
2020-02-05 09:00:00	SPY	ETF	332.28	332.37	331.93	332.25	346240.0
2020-02-05 09:30:00	SPY	ETF	332.27	332.43	331.26	331.99	8013005.0
2020-02-05 10:00:00	SPY	ETF	332.0	332.36	330.84	331.15	5021597.0
2020-02-05 10:30:00	SPY	ETF	331.15	331.71	330.67	331.56	5362860.0
2020-02-05 11:00:00	SPY	ETF	331.57	331.82	331.295	331.8	2838798.0
2020-02-05 11:30:00	SPY	ETF	331.79	332.0	331.13	331.98	2647729.0
2020-02-05 12:00:00	SPY	ETF	331.98	332.26	331.91	332.025	2696676.0
2020-02-05 12:30:00	SPY	ETF	332.025	332.22	331.86	331.92	1643260.0
2020-02-05 13:00:00	SPY	ETF	331.91	331.96	331.62	331.85	2274671.0
2020-02-05 13:30:00	SPY	ETF	331.855	332.27	331.8	332.11	2158331.0
2020-02-05 14:00:00	SPY	ETF	332.1	332.3	331.76	332.2203	2250382.0
2020-02-05 14:30:00	SPY	ETF	332.215	332.75	332.12	332.6699	2692107.0
2020-02-05 15:00:00	SPY	ETF	332.67	333.09	332.62	332.792	5633167.0
2020-02-05 15:30:00	SPY	ETF	332.79	332.87	332.2	332.82	9470076.0
2020-02-05 16:00:00	SPY	ETF	332.82	333.06	332.48	333.03	7221231.0
2020-02-05 16:30:00	SPY	ETF	333.04	333.26	332.7624	333.01	1968400.0
2020-02-05 17:00:00	SPY	ETF	333.0	333.16	332.9	333.16	232590.0
2020-02-05 17:30:00	SPY	ETF	333.17	333.2	333.1	333.14	104992.0
2020-02-05 18:00:00	SPY	ETF	333.13	333.35	332.97	333.2	929811.0
2020-02-05 18:30:00	SPY	ETF	333.21	333.32	332.88	332.94	64878.0
2020-02-05 19:00:00	SPY	ETF	332.9	333.04	332.75	332.82	33264.0
2020-02-05 19:30:00	SPY	ETF	332.82	333.16	332.77	333.03	42870.0
2020-02-05 04:00:00	QQQ	ETF	228.85	229.86	228.71	229.86	45219.0
2020-02-05 04:30:00	QQQ	ETF	229.82	230.33	229.82	230.2	35932.0
2020-02-05 05:00:00	QQQ	ETF	230.17	230.24	229.78	229.78	16992.0
2020-02-05 05:30:00	QQQ	ETF	229.75	229.99	229.69	229.86	49492.0
2020-02-05 06:00:00	QQQ	ETF	229.86	230.16	229.77	230.11	17111.0
2020-02-05 06:30:00	QQQ	ETF	230.08	230.08	229.41	229.55	49642.0
2020-02-05 07:00:00	QQQ	ETF	229.5	229.93	229.41	229.84	109251.0
2020-02-05 07:30:00	QQQ	ETF	229.83	229.95	229.6	229.64	87606.0
2020-02-05 08:00:00	QQQ	ETF	229.88	230.29	227.06	230.15	275492.0
2020-02-05 08:30:00	QQQ	ETF	230.18	230.37	230.06	230.28	181008.0
2020-02-05 09:00:00	QQQ	ETF	230.24	230.3	230.0	230.23	204761.0
2020-02-05 09:30:00	QQQ	ETF	230.23	230.25	228.18	228.77	5795083.0
2020-02-05 10:00:00	QQQ	ETF	228.76	229.03	227.47	227.73	4338914.0
2020-02-05 10:30:00	QQQ	ETF	227.7	228.68	226.85	227.6	4025578.0
2020-02-05 11:00:00	QQQ	ETF	227.6	228.005	227.43	227.79	1125229.0
2020-02-05 11:30:00	QQQ	ETF	227.79	227.945	227.09	227.94	1457028.0
2020-02-05 12:00:00	QQQ	ETF	227.93	228.195	227.83	227.94	986725.0
2020-02-05 12:30:00	QQQ	ETF	227.95	228.075	227.68	227.73	701370.0

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

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