PREVIEW / etf_30min / 2021-04-30

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-30.parquet
  size:    598 KB
  rows:    23,094

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
2021-04-30 04:00:00	SPY	ETF	419.5	419.5	418.63	418.93	3100.0
2021-04-30 04:30:00	SPY	ETF	418.98	418.98	418.77	418.84	5200.0
2021-04-30 05:00:00	SPY	ETF	418.87	418.98	418.82	418.9	4900.0
2021-04-30 05:30:00	SPY	ETF	418.95	418.98	418.34	418.39	11455.0
2021-04-30 06:00:00	SPY	ETF	418.32	418.41	418.18	418.3	34838.0
2021-04-30 06:30:00	SPY	ETF	418.32	418.33	417.23	417.49	159467.0
2021-04-30 07:00:00	SPY	ETF	417.5	417.68	417.34	417.64	59177.0
2021-04-30 07:30:00	SPY	ETF	417.62	417.92	417.61	417.92	73334.0
2021-04-30 08:00:00	SPY	ETF	417.92	419.15	417.3	418.06	163518.0
2021-04-30 08:30:00	SPY	ETF	418.07	418.07	417.08	417.92	199585.0
2021-04-30 09:00:00	SPY	ETF	417.89	417.91	417.3	417.64	220734.0
2021-04-30 09:30:00	SPY	ETF	417.63	418.5	417.4	418.4656	4990478.0
2021-04-30 10:00:00	SPY	ETF	418.47	418.54	417.62	418.478	3806327.0
2021-04-30 10:30:00	SPY	ETF	418.475	418.48	417.33	417.48	4143334.0
2021-04-30 11:00:00	SPY	ETF	417.48	417.615	416.83	416.93	5322991.0
2021-04-30 11:30:00	SPY	ETF	416.93	417.76	416.71	417.635	3527043.0
2021-04-30 12:00:00	SPY	ETF	417.63	417.89	417.43	417.695	1787628.0
2021-04-30 12:30:00	SPY	ETF	417.69	417.81	417.1001	417.4701	1823133.0
2021-04-30 13:00:00	SPY	ETF	417.46	417.75	417.24	417.73	1651688.0
2021-04-30 13:30:00	SPY	ETF	417.73	417.9	416.38	416.6699	3449240.0
2021-04-30 14:00:00	SPY	ETF	416.66	417.35	416.49	417.26	3835065.0
2021-04-30 14:30:00	SPY	ETF	417.27	417.48	417.0	417.055	2709016.0
2021-04-30 15:00:00	SPY	ETF	417.07	417.53	416.57	417.4901	4844932.0
2021-04-30 15:30:00	SPY	ETF	417.475	417.57	416.34	417.29	17021044.0
2021-04-30 16:00:00	SPY	ETF	417.29	417.76	416.9672	417.7	4734961.0
2021-04-30 16:30:00	SPY	ETF	417.65	417.82	417.57	417.65	202827.0
2021-04-30 17:00:00	SPY	ETF	417.5	417.6	417.21	417.3	136024.0
2021-04-30 17:30:00	SPY	ETF	417.29	417.35	417.2	417.32	38446.0
2021-04-30 18:00:00	SPY	ETF	417.31	417.31	417.18	417.18	21895.0
2021-04-30 18:30:00	SPY	ETF	417.17	417.25	417.1	417.14	30610.0
2021-04-30 19:00:00	SPY	ETF	417.12	417.38	417.12	417.3	11590.0
2021-04-30 19:30:00	SPY	ETF	417.25	417.33	417.14	417.33	9998.0
2021-04-30 04:00:00	QQQ	ETF	339.0	339.15	338.7	339.13	19710.0
2021-04-30 04:30:00	QQQ	ETF	339.14	339.19	338.94	338.94	25289.0
2021-04-30 05:00:00	QQQ	ETF	339.0	339.23	338.98	339.05	9688.0
2021-04-30 05:30:00	QQQ	ETF	338.99	338.99	338.49	338.56	33872.0
2021-04-30 06:00:00	QQQ	ETF	338.49	338.65	338.22	338.53	41478.0
2021-04-30 06:30:00	QQQ	ETF	338.41	338.5	337.3	337.76	182200.0
2021-04-30 07:00:00	QQQ	ETF	337.76	337.97	337.53	337.78	92691.0
2021-04-30 07:30:00	QQQ	ETF	337.75	338.15	337.67	338.15	80130.0
2021-04-30 08:00:00	QQQ	ETF	337.8096	339.29	337.4496	337.97	89750.0
2021-04-30 08:30:00	QQQ	ETF	337.95	337.96	336.97	337.84	195680.0
2021-04-30 09:00:00	QQQ	ETF	337.73	337.98	337.35	337.68	266200.0
2021-04-30 09:30:00	QQQ	ETF	337.7	339.07	337.43	339.05	4074157.0
2021-04-30 10:00:00	QQQ	ETF	339.0311	339.99	338.26	339.99	2408330.0
2021-04-30 10:30:00	QQQ	ETF	339.985	340.26	338.83	338.83	2159063.0
2021-04-30 11:00:00	QQQ	ETF	338.8401	339.13	337.96	338.09	2301419.0
2021-04-30 11:30:00	QQQ	ETF	338.09	339.28	337.9103	339.02	1536645.0
2021-04-30 12:00:00	QQQ	ETF	339.03	339.33	338.72	338.92	965161.0
2021-04-30 12:30:00	QQQ	ETF	338.915	339.12	338.17	338.62	1119362.0

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

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