PREVIEW / etf_30min / 2020-02-27

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-27.parquet
  size:    632 KB
  rows:    23,001

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-27 04:00:00	SPY	ETF	309.38	310.19	309.29	310.16	74846.0
2020-02-27 04:30:00	SPY	ETF	310.07	310.41	308.93	309.07	42979.0
2020-02-27 05:00:00	SPY	ETF	309.23	309.5	308.68	308.74	44400.0
2020-02-27 05:30:00	SPY	ETF	308.7	309.5	307.85	307.85	95138.0
2020-02-27 06:00:00	SPY	ETF	307.9	308.63	307.6	308.56	117364.0
2020-02-27 06:30:00	SPY	ETF	308.63	308.79	307.84	307.98	176204.0
2020-02-27 07:00:00	SPY	ETF	307.98	308.47	306.92	306.97	531079.0
2020-02-27 07:30:00	SPY	ETF	306.9	307.63	306.65	306.76	809781.0
2020-02-27 08:00:00	SPY	ETF	307.95	309.78	306.11	307.05	842827.0
2020-02-27 08:30:00	SPY	ETF	307.0	307.35	306.2	306.23	1414141.0
2020-02-27 09:00:00	SPY	ETF	306.23	307.1	305.25	305.46	2245731.0
2020-02-27 09:30:00	SPY	ETF	305.46	306.94	303.35	305.15	32543997.0
2020-02-27 10:00:00	SPY	ETF	305.14	305.9	302.21	302.56	20524079.0
2020-02-27 10:30:00	SPY	ETF	302.56	311.5637	300.65	305.53	23402235.0
2020-02-27 11:00:00	SPY	ETF	305.53	307.0	305.07	305.11	17331826.0
2020-02-27 11:30:00	SPY	ETF	305.11	306.77	303.645	306.57	12015488.0
2020-02-27 12:00:00	SPY	ETF	306.54	308.58	306.07	307.82	15996373.0
2020-02-27 12:30:00	SPY	ETF	307.82	311.5637	307.63	307.828	15170478.0
2020-02-27 13:00:00	SPY	ETF	307.81	309.28	306.95	307.04	10715168.0
2020-02-27 13:30:00	SPY	ETF	307.06	307.57	303.69	304.52	23004958.0
2020-02-27 14:00:00	SPY	ETF	304.48	311.5637	303.12	305.09	15118314.0
2020-02-27 14:30:00	SPY	ETF	305.07	305.07	303.08	303.19	9754816.0
2020-02-27 15:00:00	SPY	ETF	303.2	304.35	302.2	302.27	13263718.0
2020-02-27 15:30:00	SPY	ETF	302.25	302.66	297.52	297.55	40865344.0
2020-02-27 16:00:00	SPY	ETF	297.52	304.163	295.3	296.6	18234835.0
2020-02-27 16:30:00	SPY	ETF	296.67	297.7	294.57	295.04	2218846.0
2020-02-27 17:00:00	SPY	ETF	295.06	297.51	294.75	295.3	1114239.0
2020-02-27 17:30:00	SPY	ETF	295.3	295.3	294.85	295.1	355798.0
2020-02-27 18:00:00	SPY	ETF	295.06	297.12	293.62	296.63	1497605.0
2020-02-27 18:30:00	SPY	ETF	296.63	297.24	295.5	296.85	430255.0
2020-02-27 19:00:00	SPY	ETF	296.8	297.35	295.55	295.78	222472.0
2020-02-27 19:30:00	SPY	ETF	295.75	297.18	295.75	296.9	245710.0
2020-02-27 04:00:00	QQQ	ETF	214.57	215.38	214.56	215.31	58820.0
2020-02-27 04:30:00	QQQ	ETF	215.24	215.59	214.2	214.47	51227.0
2020-02-27 05:00:00	QQQ	ETF	214.58	214.77	213.98	214.18	70535.0
2020-02-27 05:30:00	QQQ	ETF	214.11	214.72	213.5	213.5	64786.0
2020-02-27 06:00:00	QQQ	ETF	213.61	214.36	213.34	214.36	73134.0
2020-02-27 06:30:00	QQQ	ETF	214.42	214.5	213.6	213.65	162262.0
2020-02-27 07:00:00	QQQ	ETF	213.59	213.92	212.5	212.5	292995.0
2020-02-27 07:30:00	QQQ	ETF	212.48	213.13	212.13	212.18	678611.0
2020-02-27 08:00:00	QQQ	ETF	212.17	215.0	211.5	212.53	806534.0
2020-02-27 08:30:00	QQQ	ETF	212.43	216.48	211.73	211.73	588824.0
2020-02-27 09:00:00	QQQ	ETF	211.79	211.92	210.81	210.98	967700.0
2020-02-27 09:30:00	QQQ	ETF	211.05	212.62	209.79	211.365	14099868.0
2020-02-27 10:00:00	QQQ	ETF	211.36	212.03	208.93	209.26	8561320.0
2020-02-27 10:30:00	QQQ	ETF	209.25	211.32	207.7	211.29	8853593.0
2020-02-27 11:00:00	QQQ	ETF	211.28	212.93	210.915	210.985	7452519.0
2020-02-27 11:30:00	QQQ	ETF	210.99	212.23	209.87	212.0672	5843779.0
2020-02-27 12:00:00	QQQ	ETF	212.05	213.39	211.58	212.79	5084384.0
2020-02-27 12:30:00	QQQ	ETF	212.7818	214.37	212.64	212.96	4886468.0

> showing 50 of 23,001 rows — these rows as CSV

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