PREVIEW / etf_30min / 2020-10-13

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-13.parquet
  size:    555 KB
  rows:    20,399

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-10-13 04:00:00	SPY	ETF	351.21	351.93	351.21	351.75	89209.0
2020-10-13 04:30:00	SPY	ETF	351.85	352.54	351.85	352.54	29307.0
2020-10-13 05:00:00	SPY	ETF	352.51	353.01	352.51	352.92	29626.0
2020-10-13 05:30:00	SPY	ETF	353.03	353.03	352.61	352.87	23685.0
2020-10-13 06:00:00	SPY	ETF	352.57	352.93	352.57	352.93	35141.0
2020-10-13 06:30:00	SPY	ETF	352.85	352.96	352.05	352.17	35800.0
2020-10-13 07:00:00	SPY	ETF	352.13	353.01	352.11	352.86	174852.0
2020-10-13 07:30:00	SPY	ETF	352.95	353.14	352.4	352.77	158790.0
2020-10-13 08:00:00	SPY	ETF	352.8701	353.1	351.4	352.5	186217.0
2020-10-13 08:30:00	SPY	ETF	352.52	352.68	351.88	352.16	355397.0
2020-10-13 09:00:00	SPY	ETF	352.16	352.29	351.66	352.28	544798.0
2020-10-13 09:30:00	SPY	ETF	352.28	352.44	351.081	351.84	7787778.0
2020-10-13 10:00:00	SPY	ETF	351.83	352.08	350.66	351.3599	5824792.0
2020-10-13 10:30:00	SPY	ETF	351.35	351.54	350.57	351.37	6275052.0
2020-10-13 11:00:00	SPY	ETF	351.41	352.4651	351.13	351.59	8209993.0
2020-10-13 11:30:00	SPY	ETF	351.59	351.83	351.073	351.45	4474006.0
2020-10-13 12:00:00	SPY	ETF	351.467	351.64	350.6414	351.34	2524380.0
2020-10-13 12:30:00	SPY	ETF	351.34	351.41	350.8233	351.33	1828126.0
2020-10-13 13:00:00	SPY	ETF	351.32	351.62	350.3	351.0799	3115758.0
2020-10-13 13:30:00	SPY	ETF	351.07	351.23	349.77	349.95	2683601.0
2020-10-13 14:00:00	SPY	ETF	349.96	350.57	349.58	349.67	4185280.0
2020-10-13 14:30:00	SPY	ETF	349.68	350.21	349.09	350.03	5766362.0
2020-10-13 15:00:00	SPY	ETF	350.02	351.37	349.9	351.152	4543921.0
2020-10-13 15:30:00	SPY	ETF	351.16	351.51	350.14	350.15	7087702.0
2020-10-13 16:00:00	SPY	ETF	350.16	350.9953	349.95	350.5	4569327.0
2020-10-13 16:30:00	SPY	ETF	350.5	350.59	350.03	350.05	218070.0
2020-10-13 17:00:00	SPY	ETF	350.15	350.22	350.05	350.07	955388.0
2020-10-13 17:30:00	SPY	ETF	350.07	350.18	350.07	350.18	11183.0
2020-10-13 18:00:00	SPY	ETF	350.14	350.52	350.07	350.5	73307.0
2020-10-13 18:30:00	SPY	ETF	350.48	350.82	350.33	350.65	21261.0
2020-10-13 19:00:00	SPY	ETF	350.69	350.89	350.64	350.85	30534.0
2020-10-13 19:30:00	SPY	ETF	350.85	350.91	350.74	350.77	25361.0
2020-10-13 04:00:00	QQQ	ETF	294.02	295.01	294.02	294.92	87227.0
2020-10-13 04:30:00	QQQ	ETF	295.09	296.5	295.06	296.44	36376.0
2020-10-13 05:00:00	QQQ	ETF	296.43	297.28	296.1	297.28	136690.0
2020-10-13 05:30:00	QQQ	ETF	297.24	297.61	297.13	297.58	76600.0
2020-10-13 06:00:00	QQQ	ETF	297.77	298.56	297.28	298.45	132370.0
2020-10-13 06:30:00	QQQ	ETF	298.4	298.67	296.76	297.07	176756.0
2020-10-13 07:00:00	QQQ	ETF	297.05	298.11	296.53	297.66	410439.0
2020-10-13 07:30:00	QQQ	ETF	297.66	297.87	297.23	297.38	279874.0
2020-10-13 08:00:00	QQQ	ETF	297.3401	298.55	294.08	297.48	183253.0
2020-10-13 08:30:00	QQQ	ETF	297.42	297.95	295.68	296.35	321725.0
2020-10-13 09:00:00	QQQ	ETF	296.3	296.82	295.55	296.35	538783.0
2020-10-13 09:30:00	QQQ	ETF	296.31	296.39	293.4	294.893	5736809.0
2020-10-13 10:00:00	QQQ	ETF	294.92	295.44	293.4646	295.02	3610763.0
2020-10-13 10:30:00	QQQ	ETF	295.02	295.69	294.01	295.63	3068885.0
2020-10-13 11:00:00	QQQ	ETF	295.635	296.84	295.2	296.385	2798209.0
2020-10-13 11:30:00	QQQ	ETF	296.4019	297.0496	295.6999	295.88	2541854.0
2020-10-13 12:00:00	QQQ	ETF	295.8543	296.1699	294.42	295.35	1760178.0
2020-10-13 12:30:00	QQQ	ETF	295.34	295.6399	294.805	295.41	1129054.0

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

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