PREVIEW / etf_30min / 2021-05-04

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-04.parquet
  size:    633 KB
  rows:    24,251

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-05-04 04:00:00	SPY	ETF	417.2	417.73	417.02	417.61	7958.0
2021-05-04 04:30:00	SPY	ETF	417.56	417.56	417.13	417.43	8810.0
2021-05-04 05:00:00	SPY	ETF	417.36	417.44	417.28	417.34	5295.0
2021-05-04 05:30:00	SPY	ETF	417.5	417.88	417.49	417.78	6683.0
2021-05-04 06:00:00	SPY	ETF	417.78	417.96	417.75	417.75	3045.0
2021-05-04 06:30:00	SPY	ETF	417.79	417.9	417.56	417.79	5400.0
2021-05-04 07:00:00	SPY	ETF	417.83	417.94	417.71	417.82	99382.0
2021-05-04 07:30:00	SPY	ETF	417.79	417.79	415.82	416.49	951327.0
2021-05-04 08:00:00	SPY	ETF	417.7701	418.0	415.36	415.66	558730.0
2021-05-04 08:30:00	SPY	ETF	415.58	416.09	415.58	415.94	221908.0
2021-05-04 09:00:00	SPY	ETF	415.95	416.08	415.59	416.07	231090.0
2021-05-04 09:30:00	SPY	ETF	416.08	416.6	413.75	413.88	9745639.0
2021-05-04 10:00:00	SPY	ETF	413.88	414.5899	413.15	414.325	8161096.0
2021-05-04 10:30:00	SPY	ETF	414.32	414.5	413.23	413.276	4882682.0
2021-05-04 11:00:00	SPY	ETF	413.28	413.74	411.965	412.9181	7442650.0
2021-05-04 11:30:00	SPY	ETF	412.9181	413.22	411.67	412.122	5427333.0
2021-05-04 12:00:00	SPY	ETF	412.125	413.51	411.98	413.47	4204398.0
2021-05-04 12:30:00	SPY	ETF	413.47	413.47	412.59	412.8	2788588.0
2021-05-04 13:00:00	SPY	ETF	412.78	413.93	412.6	413.69	3236579.0
2021-05-04 13:30:00	SPY	ETF	413.683	413.9799	413.19	413.51	3235417.0
2021-05-04 14:00:00	SPY	ETF	413.5	414.28	413.19	413.7501	3787968.0
2021-05-04 14:30:00	SPY	ETF	413.75	414.4	413.66	414.07	2556707.0
2021-05-04 15:00:00	SPY	ETF	414.0719	414.32	413.481	413.88	4503348.0
2021-05-04 15:30:00	SPY	ETF	413.873	415.66	413.61	415.65	14192568.0
2021-05-04 16:00:00	SPY	ETF	415.65	415.82	415.12	415.24	3071861.0
2021-05-04 16:30:00	SPY	ETF	415.24	415.44	415.0	415.44	305501.0
2021-05-04 17:00:00	SPY	ETF	415.49	415.54	415.41	415.41	37166.0
2021-05-04 17:30:00	SPY	ETF	415.43	415.59	415.43	415.52	28896.0
2021-05-04 18:00:00	SPY	ETF	415.52	415.55	415.18	415.29	37138.0
2021-05-04 18:30:00	SPY	ETF	415.33	415.5	415.16	415.398	44386.0
2021-05-04 19:00:00	SPY	ETF	415.4	415.62	415.3	415.3	26056.0
2021-05-04 19:30:00	SPY	ETF	415.31	415.62	415.31	415.58	71364.0
2021-05-04 04:00:00	QQQ	ETF	335.0	335.51	334.93	335.38	42726.0
2021-05-04 04:30:00	QQQ	ETF	335.39	335.39	334.63	334.91	24891.0
2021-05-04 05:00:00	QQQ	ETF	334.94	335.03	334.75	334.93	3926.0
2021-05-04 05:30:00	QQQ	ETF	335.09	335.34	335.03	335.29	8376.0
2021-05-04 06:00:00	QQQ	ETF	335.35	335.5	335.04	335.04	8394.0
2021-05-04 06:30:00	QQQ	ETF	335.02	335.09	334.77	335.05	18962.0
2021-05-04 07:00:00	QQQ	ETF	335.07	335.28	334.95	335.14	54196.0
2021-05-04 07:30:00	QQQ	ETF	335.08	335.08	332.81	333.71	536569.0
2021-05-04 08:00:00	QQQ	ETF	333.71	335.66	332.91	333.18	363717.0
2021-05-04 08:30:00	QQQ	ETF	333.11	333.67	333.11	333.58	192206.0
2021-05-04 09:00:00	QQQ	ETF	333.55	333.61	333.05	333.53	442244.0
2021-05-04 09:30:00	QQQ	ETF	333.56	333.89	329.96	330.15	10200435.0
2021-05-04 10:00:00	QQQ	ETF	330.16	330.38	328.93	330.2101	7198486.0
2021-05-04 10:30:00	QQQ	ETF	330.2	330.2	328.41	328.57	3672676.0
2021-05-04 11:00:00	QQQ	ETF	328.58	329.02	327.06	327.895	5126685.0
2021-05-04 11:30:00	QQQ	ETF	327.905	328.12	326.21	326.73	3764790.0
2021-05-04 12:00:00	QQQ	ETF	326.72	327.93	326.54	327.72	3023789.0
2021-05-04 12:30:00	QQQ	ETF	327.72	327.72	326.6	326.96	2041511.0

> showing 50 of 24,251 rows — these rows as CSV

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