PREVIEW / etf_30min / 2020-08-14

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-14.parquet
  size:    538 KB
  rows:    19,747

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-08-14 04:00:00	SPY	ETF	336.19	336.22	335.14	335.46	30946.0
2020-08-14 04:30:00	SPY	ETF	335.41	335.55	335.05	335.39	19281.0
2020-08-14 05:00:00	SPY	ETF	335.3	335.74	335.16	335.73	17009.0
2020-08-14 05:30:00	SPY	ETF	335.64	335.85	335.48	335.85	39948.0
2020-08-14 06:00:00	SPY	ETF	335.8	335.8	335.31	335.53	26408.0
2020-08-14 06:30:00	SPY	ETF	335.59	336.05	335.48	336.03	52904.0
2020-08-14 07:00:00	SPY	ETF	336.03	336.4	335.95	336.39	138243.0
2020-08-14 07:30:00	SPY	ETF	336.37	336.85	336.34	336.7	131442.0
2020-08-14 08:00:00	SPY	ETF	336.5801	337.89	335.5696	336.68	133689.0
2020-08-14 08:30:00	SPY	ETF	336.64	337.06	336.28	336.42	229590.0
2020-08-14 09:00:00	SPY	ETF	336.4	336.65	336.26	336.43	197519.0
2020-08-14 09:30:00	SPY	ETF	336.41	336.76	335.9	336.68	3551928.0
2020-08-14 10:00:00	SPY	ETF	336.68	336.9099	336.17	336.31	2280149.0
2020-08-14 10:30:00	SPY	ETF	336.32	337.05	336.23	336.55	1898652.0
2020-08-14 11:00:00	SPY	ETF	336.54	337.23	336.36	337.16	1486673.0
2020-08-14 11:30:00	SPY	ETF	337.16	337.34	336.74	337.1	1495389.0
2020-08-14 12:00:00	SPY	ETF	337.105	337.3	336.88	336.945	2267885.0
2020-08-14 12:30:00	SPY	ETF	336.95	337.295	336.94	336.98	2248050.0
2020-08-14 13:00:00	SPY	ETF	336.975	337.18	336.79	337.1367	2054212.0
2020-08-14 13:30:00	SPY	ETF	337.14	337.42	337.02	337.415	1994779.0
2020-08-14 14:00:00	SPY	ETF	337.41	337.4101	336.72	336.98	2659771.0
2020-08-14 14:30:00	SPY	ETF	336.97	337.15	336.555	336.57	3418203.0
2020-08-14 15:00:00	SPY	ETF	336.58	336.72	335.85	336.1	4667259.0
2020-08-14 15:30:00	SPY	ETF	336.095	336.88	335.62	336.86	9813758.0
2020-08-14 16:00:00	SPY	ETF	336.86	336.88	336.13	336.35	4950644.0
2020-08-14 16:30:00	SPY	ETF	336.34	336.84	336.31	336.44	750656.0
2020-08-14 17:00:00	SPY	ETF	336.3	336.84	336.3	336.5	40019.0
2020-08-14 17:30:00	SPY	ETF	336.53	336.84	336.4	336.4	17354.0
2020-08-14 18:00:00	SPY	ETF	336.4	336.49	336.36	336.36	8234.0
2020-08-14 18:30:00	SPY	ETF	336.37	336.49	336.37	336.49	1963.0
2020-08-14 19:00:00	SPY	ETF	336.49	336.54	336.48	336.53	3211.0
2020-08-14 19:30:00	SPY	ETF	336.57	336.6	336.43	336.6	7845.0
2020-08-14 04:00:00	QQQ	ETF	272.48	272.52	271.95	272.22	15921.0
2020-08-14 04:30:00	QQQ	ETF	272.28	272.42	272.11	272.26	13122.0
2020-08-14 05:00:00	QQQ	ETF	272.26	272.39	272.04	272.38	13652.0
2020-08-14 05:30:00	QQQ	ETF	272.33	272.37	272.12	272.37	5435.0
2020-08-14 06:00:00	QQQ	ETF	272.31	272.41	271.76	271.94	17114.0
2020-08-14 06:30:00	QQQ	ETF	272.04	273.07	272.04	272.92	74435.0
2020-08-14 07:00:00	QQQ	ETF	272.92	273.55	272.72	273.48	153361.0
2020-08-14 07:30:00	QQQ	ETF	273.45	273.59	273.23	273.41	75234.0
2020-08-14 08:00:00	QQQ	ETF	272.9001	273.5996	272.22	273.41	60417.0
2020-08-14 08:30:00	QQQ	ETF	273.42	273.66	272.99	273.2	117945.0
2020-08-14 09:00:00	QQQ	ETF	273.14	273.27	272.83	273.02	196707.0
2020-08-14 09:30:00	QQQ	ETF	273.02	273.4	271.68	272.58	2806945.0
2020-08-14 10:00:00	QQQ	ETF	272.58	272.89	270.85	270.95	2711469.0
2020-08-14 10:30:00	QQQ	ETF	270.94	272.12	270.72	271.19	1836308.0
2020-08-14 11:00:00	QQQ	ETF	271.19	272.05	270.94	271.9959	1206098.0
2020-08-14 11:30:00	QQQ	ETF	272.02	272.3832	271.38	271.75	884079.0
2020-08-14 12:00:00	QQQ	ETF	271.7599	272.21	271.67	272.02	820463.0
2020-08-14 12:30:00	QQQ	ETF	272.03	272.7086	272.02	272.44	773623.0

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

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