PREVIEW / etf_30min / 2021-04-20

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-20.parquet
  size:    629 KB
  rows:    23,952

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-20 04:00:00	SPY	ETF	415.66	415.72	415.3	415.44	18120.0
2021-04-20 04:30:00	SPY	ETF	415.31	415.31	415.0	415.08	21792.0
2021-04-20 05:00:00	SPY	ETF	415.02	415.02	414.25	414.25	13505.0
2021-04-20 05:30:00	SPY	ETF	414.23	414.23	413.35	413.55	62888.0
2021-04-20 06:00:00	SPY	ETF	413.54	413.57	413.23	413.55	12095.0
2021-04-20 06:30:00	SPY	ETF	413.56	413.75	412.68	413.55	87743.0
2021-04-20 07:00:00	SPY	ETF	413.57	413.63	413.25	413.35	115193.0
2021-04-20 07:30:00	SPY	ETF	413.35	413.73	413.35	413.63	121012.0
2021-04-20 08:00:00	SPY	ETF	413.4301	413.75	413.2204	413.43	167968.0
2021-04-20 08:30:00	SPY	ETF	413.44	415.21	413.29	413.6	529759.0
2021-04-20 09:00:00	SPY	ETF	413.6	414.17	413.6	413.89	185457.0
2021-04-20 09:30:00	SPY	ETF	413.91	414.68	413.73	414.34	4709624.0
2021-04-20 10:00:00	SPY	ETF	414.34	414.57	413.66	413.92	4109917.0
2021-04-20 10:30:00	SPY	ETF	413.93	413.93	411.76	412.35	6801490.0
2021-04-20 11:00:00	SPY	ETF	412.35	412.51	411.12	411.575	6092892.0
2021-04-20 11:30:00	SPY	ETF	411.57	411.72	410.62	411.46	5133565.0
2021-04-20 12:00:00	SPY	ETF	411.46	412.4	411.3009	412.145	2599248.0
2021-04-20 12:30:00	SPY	ETF	412.15	412.22	411.46	412.03	2591074.0
2021-04-20 13:00:00	SPY	ETF	412.02	412.05	411.25	411.29	2211540.0
2021-04-20 13:30:00	SPY	ETF	411.3097	411.95	411.2	411.905	2658736.0
2021-04-20 14:00:00	SPY	ETF	411.895	412.1	411.5	411.535	2064623.0
2021-04-20 14:30:00	SPY	ETF	411.535	411.54	410.59	410.849	2865591.0
2021-04-20 15:00:00	SPY	ETF	410.8499	412.02	410.84	411.905	3153005.0
2021-04-20 15:30:00	SPY	ETF	411.9	412.67	411.8	412.24	8597966.0
2021-04-20 16:00:00	SPY	ETF	412.22	412.34	411.61	411.7	3653665.0
2021-04-20 16:30:00	SPY	ETF	411.7	412.17	411.51	411.61	193430.0
2021-04-20 17:00:00	SPY	ETF	411.6	412.17	411.59	411.95	69377.0
2021-04-20 17:30:00	SPY	ETF	411.9	411.91	411.76	411.76	9671.0
2021-04-20 18:00:00	SPY	ETF	411.77	411.88	411.66	411.88	47439.0
2021-04-20 18:30:00	SPY	ETF	412.17	412.17	411.77	411.99	19781.0
2021-04-20 19:00:00	SPY	ETF	411.93	411.94	411.76	411.87	16037.0
2021-04-20 19:30:00	SPY	ETF	411.74	411.971	411.64	411.8	27981.0
2021-04-20 04:00:00	QQQ	ETF	339.2	339.61	338.93	339.3	39765.0
2021-04-20 04:30:00	QQQ	ETF	339.3	339.36	338.91	338.91	17269.0
2021-04-20 05:00:00	QQQ	ETF	339.01	339.11	338.41	338.48	24946.0
2021-04-20 05:30:00	QQQ	ETF	338.48	338.48	337.11	337.34	62524.0
2021-04-20 06:00:00	QQQ	ETF	337.52	337.62	337.22	337.47	24754.0
2021-04-20 06:30:00	QQQ	ETF	337.5	337.79	336.74	337.64	86111.0
2021-04-20 07:00:00	QQQ	ETF	337.64	337.71	337.29	337.42	50742.0
2021-04-20 07:30:00	QQQ	ETF	337.33	338.01	337.3	337.85	54260.0
2021-04-20 08:00:00	QQQ	ETF	337.86	339.19	337.0696	337.74	109974.0
2021-04-20 08:30:00	QQQ	ETF	337.67	337.95	337.47	337.69	68546.0
2021-04-20 09:00:00	QQQ	ETF	337.7	338.26	337.67	338.15	82712.0
2021-04-20 09:30:00	QQQ	ETF	338.2	339.52	337.65	338.921	3726042.0
2021-04-20 10:00:00	QQQ	ETF	338.92	339.16	337.92	338.39	2315857.0
2021-04-20 10:30:00	QQQ	ETF	338.345	338.41	336.03	336.48	4333616.0
2021-04-20 11:00:00	QQQ	ETF	336.465	336.92	334.81	335.22	4267810.0
2021-04-20 11:30:00	QQQ	ETF	335.215	335.94	334.3816	335.57	2966804.0
2021-04-20 12:00:00	QQQ	ETF	335.58	336.5084	335.36	336.19	1610311.0
2021-04-20 12:30:00	QQQ	ETF	336.21	336.31	335.4182	335.85	1536370.0

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

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