PREVIEW / etf_30min / 2021-04-27

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-27.parquet
  size:    605 KB
  rows:    22,685

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-27 04:00:00	SPY	ETF	418.06	418.27	417.81	418.04	4895.0
2021-04-27 04:30:00	SPY	ETF	418.01	418.07	417.97	418.01	2200.0
2021-04-27 05:00:00	SPY	ETF	418.07	418.09	417.98	417.99	9990.0
2021-04-27 05:30:00	SPY	ETF	418.01	418.01	417.32	417.52	23971.0
2021-04-27 06:00:00	SPY	ETF	417.47	417.87	417.43	417.82	11621.0
2021-04-27 06:30:00	SPY	ETF	417.8	418.05	417.72	417.99	38801.0
2021-04-27 07:00:00	SPY	ETF	418.0	418.11	417.88	417.98	21461.0
2021-04-27 07:30:00	SPY	ETF	417.98	418.1	417.8	417.94	49706.0
2021-04-27 08:00:00	SPY	ETF	418.0599	418.49	417.42	418.0	92876.0
2021-04-27 08:30:00	SPY	ETF	418.05	418.05	417.77	417.78	72116.0
2021-04-27 09:00:00	SPY	ETF	417.79	418.0	417.74	417.93	148225.0
2021-04-27 09:30:00	SPY	ETF	417.91	417.99	416.78	416.845	5725596.0
2021-04-27 10:00:00	SPY	ETF	416.85	417.24	416.3	417.22	3524044.0
2021-04-27 10:30:00	SPY	ETF	417.23	417.36	416.53	417.16	2232180.0
2021-04-27 11:00:00	SPY	ETF	417.17	417.39	416.9519	417.195	1768230.0
2021-04-27 11:30:00	SPY	ETF	417.19	417.66	417.15	417.535	1223733.0
2021-04-27 12:00:00	SPY	ETF	417.535	417.735	417.4	417.67	1865174.0
2021-04-27 12:30:00	SPY	ETF	417.67	417.68	416.98	417.09	1216805.0
2021-04-27 13:00:00	SPY	ETF	417.09	417.4804	417.05	417.345	1200906.0
2021-04-27 13:30:00	SPY	ETF	417.34	417.58	417.19	417.3933	1074160.0
2021-04-27 14:00:00	SPY	ETF	417.4	417.58	417.07	417.5499	2666449.0
2021-04-27 14:30:00	SPY	ETF	417.549	417.82	417.54	417.61	1466437.0
2021-04-27 15:00:00	SPY	ETF	417.61	417.95	417.285	417.855	1949981.0
2021-04-27 15:30:00	SPY	ETF	417.8511	418.14	417.26	417.4875	6090782.0
2021-04-27 16:00:00	SPY	ETF	417.49	417.96	417.28	417.5	2734249.0
2021-04-27 16:30:00	SPY	ETF	417.52	417.65	417.43	417.65	185771.0
2021-04-27 17:00:00	SPY	ETF	417.58	417.6	417.46	417.56	33243.0
2021-04-27 17:30:00	SPY	ETF	417.56	417.57	417.49	417.57	19000.0
2021-04-27 18:00:00	SPY	ETF	417.57	417.84	417.57	417.75	62697.0
2021-04-27 18:30:00	SPY	ETF	417.52	417.75	417.52	417.7	5779.0
2021-04-27 19:00:00	SPY	ETF	417.79	417.93	417.78	417.87	11163.0
2021-04-27 19:30:00	SPY	ETF	417.84	417.84	417.63	417.64	9767.0
2021-04-27 04:00:00	QQQ	ETF	341.9	342.1	341.69	341.94	27093.0
2021-04-27 04:30:00	QQQ	ETF	341.93	342.12	341.93	342.12	4454.0
2021-04-27 05:00:00	QQQ	ETF	342.06	342.2	342.0	342.16	16805.0
2021-04-27 05:30:00	QQQ	ETF	342.21	342.21	341.55	341.68	15464.0
2021-04-27 06:00:00	QQQ	ETF	341.6	341.88	341.6	341.87	9788.0
2021-04-27 06:30:00	QQQ	ETF	341.86	342.08	341.72	342.01	6949.0
2021-04-27 07:00:00	QQQ	ETF	342.06	342.16	341.96	342.0	87318.0
2021-04-27 07:30:00	QQQ	ETF	341.99	342.13	341.88	342.11	77626.0
2021-04-27 08:00:00	QQQ	ETF	342.11	342.4	341.71	342.14	128916.0
2021-04-27 08:30:00	QQQ	ETF	342.17	342.28	342.01	342.05	78091.0
2021-04-27 09:00:00	QQQ	ETF	342.07	342.13	341.88	341.92	174747.0
2021-04-27 09:30:00	QQQ	ETF	341.93	342.15	340.02	340.16	5361771.0
2021-04-27 10:00:00	QQQ	ETF	340.18	340.34	339.29	340.305	3526781.0
2021-04-27 10:30:00	QQQ	ETF	340.3	340.41	339.17	339.97	1964762.0
2021-04-27 11:00:00	QQQ	ETF	339.98	340.25	339.64	340.19	1220431.0
2021-04-27 11:30:00	QQQ	ETF	340.2	340.615	340.05	340.44	962703.0
2021-04-27 12:00:00	QQQ	ETF	340.4399	340.69	340.22	340.59	1082668.0
2021-04-27 12:30:00	QQQ	ETF	340.575	340.9	340.25	340.34	775739.0

> showing 50 of 22,685 rows — these rows as CSV

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