PREVIEW / etf_30min / 2021-06-21

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-21.parquet
  size:    610 KB
  rows:    23,678

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-06-21 04:00:00	SPY	ETF	416.0	416.17	413.0	416.0	72457.0
2021-06-21 04:30:00	SPY	ETF	416.0	416.37	415.88	416.3	103590.0
2021-06-21 05:00:00	SPY	ETF	416.32	417.19	416.22	417.17	28167.0
2021-06-21 05:30:00	SPY	ETF	417.02	417.13	416.7	416.7	26925.0
2021-06-21 06:00:00	SPY	ETF	416.74	416.9	416.45	416.67	23805.0
2021-06-21 06:30:00	SPY	ETF	416.58	416.91	416.49	416.7	77855.0
2021-06-21 07:00:00	SPY	ETF	416.67	416.88	415.99	416.13	256596.0
2021-06-21 07:30:00	SPY	ETF	416.13	416.77	416.08	416.62	140186.0
2021-06-21 08:00:00	SPY	ETF	416.69	416.8504	412.94	416.25	320929.0
2021-06-21 08:30:00	SPY	ETF	416.27	416.85	416.19	416.8	214335.0
2021-06-21 09:00:00	SPY	ETF	416.78	416.93	416.63	416.89	310294.0
2021-06-21 09:30:00	SPY	ETF	416.8	418.03	415.93	417.8601	8095031.0
2021-06-21 10:00:00	SPY	ETF	417.88	419.21	417.81	419.09	6092931.0
2021-06-21 10:30:00	SPY	ETF	419.08	420.26	419.07	420.03	4620179.0
2021-06-21 11:00:00	SPY	ETF	420.03	420.175	419.67	419.855	3137106.0
2021-06-21 11:30:00	SPY	ETF	419.87	420.39	419.815	420.18	2759639.0
2021-06-21 12:00:00	SPY	ETF	420.19	420.34	419.83	420.01	1510378.0
2021-06-21 12:30:00	SPY	ETF	420.02	420.193	419.86	419.89	1622361.0
2021-06-21 13:00:00	SPY	ETF	419.89	420.21	419.8019	420.13	1352227.0
2021-06-21 13:30:00	SPY	ETF	420.14	420.99	420.14	420.75	2833647.0
2021-06-21 14:00:00	SPY	ETF	420.75	420.91	420.49	420.5857	2270430.0
2021-06-21 14:30:00	SPY	ETF	420.58	420.76	420.36	420.6404	2114389.0
2021-06-21 15:00:00	SPY	ETF	420.64	420.95	420.32	420.64	3040901.0
2021-06-21 15:30:00	SPY	ETF	420.64	421.06	420.34	420.84	10601216.0
2021-06-21 16:00:00	SPY	ETF	420.84	421.4	420.6358	421.31	3522511.0
2021-06-21 16:30:00	SPY	ETF	421.3	421.4	420.86	421.27	257478.0
2021-06-21 17:00:00	SPY	ETF	421.25	421.31	421.2	421.26	81084.0
2021-06-21 17:30:00	SPY	ETF	421.26	421.35	421.26	421.29	15666.0
2021-06-21 18:00:00	SPY	ETF	421.29	421.35	421.24	421.29	28656.0
2021-06-21 18:30:00	SPY	ETF	421.27	421.27	421.15	421.16	25337.0
2021-06-21 19:00:00	SPY	ETF	421.24	421.57	421.14	421.54	37551.0
2021-06-21 19:30:00	SPY	ETF	421.54	421.61	421.13	421.21	58473.0
2021-06-21 04:00:00	QQQ	ETF	343.0	343.5	342.92	343.19	70845.0
2021-06-21 04:30:00	QQQ	ETF	343.13	343.69	343.1	343.68	14321.0
2021-06-21 05:00:00	QQQ	ETF	343.57	344.24	343.57	344.13	16862.0
2021-06-21 05:30:00	QQQ	ETF	344.11	344.18	343.95	343.97	7935.0
2021-06-21 06:00:00	QQQ	ETF	343.97	343.97	343.53	343.69	19771.0
2021-06-21 06:30:00	QQQ	ETF	343.5	343.76	343.5	343.58	22130.0
2021-06-21 07:00:00	QQQ	ETF	343.62	343.78	343.02	343.16	78751.0
2021-06-21 07:30:00	QQQ	ETF	343.15	343.23	342.69	343.06	68674.0
2021-06-21 08:00:00	QQQ	ETF	343.6396	343.9696	341.02	342.6	94830.0
2021-06-21 08:30:00	QQQ	ETF	342.63	342.97	342.4	342.87	186232.0
2021-06-21 09:00:00	QQQ	ETF	342.8	342.93	342.36	342.401	132791.0
2021-06-21 09:30:00	QQQ	ETF	342.43	342.92	340.15	342.58	5788822.0
2021-06-21 10:00:00	QQQ	ETF	342.6	343.11	341.51	342.1401	2808091.0
2021-06-21 10:30:00	QQQ	ETF	342.13	343.99	342.03	343.56	2207918.0
2021-06-21 11:00:00	QQQ	ETF	343.58	344.41	343.5	343.77	1869036.0
2021-06-21 11:30:00	QQQ	ETF	343.77	344.16	343.45	343.97	1255978.0
2021-06-21 12:00:00	QQQ	ETF	343.98	344.2	343.645	343.95	760136.0
2021-06-21 12:30:00	QQQ	ETF	343.9697	344.2699	343.7726	343.79	871712.0

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

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