PREVIEW / etf_30min / 2021-03-16

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-16.parquet
  size:    620 KB
  rows:    23,613

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-03-16 04:00:00	SPY	ETF	396.72	396.72	395.95	396.55	4008.0
2021-03-16 04:30:00	SPY	ETF	396.63	396.65	396.22	396.22	13000.0
2021-03-16 05:00:00	SPY	ETF	396.32	396.48	396.32	396.43	1000.0
2021-03-16 05:30:00	SPY	ETF	396.44	396.45	396.21	396.36	5961.0
2021-03-16 06:00:00	SPY	ETF	396.41	396.5	396.39	396.47	6299.0
2021-03-16 06:30:00	SPY	ETF	396.5	396.64	396.44	396.61	9615.0
2021-03-16 07:00:00	SPY	ETF	396.67	397.02	396.65	396.83	62002.0
2021-03-16 07:30:00	SPY	ETF	396.83	397.2	396.75	397.03	77380.0
2021-03-16 08:00:00	SPY	ETF	397.03	397.17	396.36	397.0	47917.0
2021-03-16 08:30:00	SPY	ETF	397.0	397.34	396.74	396.86	207746.0
2021-03-16 09:00:00	SPY	ETF	396.83	397.15	396.8	397.07	423027.0
2021-03-16 09:30:00	SPY	ETF	397.07	397.62	396.72	397.459	5034810.0
2021-03-16 10:00:00	SPY	ETF	397.45	397.63	397.02	397.58	3365726.0
2021-03-16 10:30:00	SPY	ETF	397.58	397.83	397.27	397.3	3687930.0
2021-03-16 11:00:00	SPY	ETF	397.315	397.49	396.99	397.285	3217451.0
2021-03-16 11:30:00	SPY	ETF	397.29	397.45	396.74	397.049	2447954.0
2021-03-16 12:00:00	SPY	ETF	397.04	397.19	396.03	396.315	3382494.0
2021-03-16 12:30:00	SPY	ETF	396.32	396.97	396.2219	396.855	2716855.0
2021-03-16 13:00:00	SPY	ETF	396.855	397.38	396.755	396.9762	3434124.0
2021-03-16 13:30:00	SPY	ETF	396.975	397.01	396.0889	396.275	2883394.0
2021-03-16 14:00:00	SPY	ETF	396.27	396.65	395.3	395.4	4447849.0
2021-03-16 14:30:00	SPY	ETF	395.391	396.15	395.08	395.95	5915138.0
2021-03-16 15:00:00	SPY	ETF	395.959	396.54	395.45	396.23	3821991.0
2021-03-16 15:30:00	SPY	ETF	396.23	397.02	395.87	395.94	10808001.0
2021-03-16 16:00:00	SPY	ETF	395.95	396.7094	395.83	396.4	4146452.0
2021-03-16 16:30:00	SPY	ETF	396.41	396.53	396.21	396.5	173991.0
2021-03-16 17:00:00	SPY	ETF	396.48	396.48	395.91	396.28	102906.0
2021-03-16 17:30:00	SPY	ETF	396.29	396.55	395.91	396.38	66231.0
2021-03-16 18:00:00	SPY	ETF	396.42	396.75	396.42	396.54	72181.0
2021-03-16 18:30:00	SPY	ETF	395.91	396.7	395.91	396.6	11163.0
2021-03-16 19:00:00	SPY	ETF	396.55	396.7	396.35	396.37	36165.0
2021-03-16 19:30:00	SPY	ETF	396.36	396.45	396.21	396.25	28833.0
2021-03-16 04:00:00	QQQ	ETF	320.44	320.44	319.62	319.84	14217.0
2021-03-16 04:30:00	QQQ	ETF	319.83	319.97	319.68	319.68	19902.0
2021-03-16 05:00:00	QQQ	ETF	319.73	320.19	319.64	320.19	9891.0
2021-03-16 05:30:00	QQQ	ETF	320.1	320.26	320.02	320.17	17848.0
2021-03-16 06:00:00	QQQ	ETF	320.24	320.26	319.98	320.17	17869.0
2021-03-16 06:30:00	QQQ	ETF	320.13	320.5	320.13	320.5	28830.0
2021-03-16 07:00:00	QQQ	ETF	320.5	320.72	320.21	320.58	67923.0
2021-03-16 07:30:00	QQQ	ETF	320.55	320.8	320.53	320.65	27850.0
2021-03-16 08:00:00	QQQ	ETF	320.52	321.16	319.96	320.79	60567.0
2021-03-16 08:30:00	QQQ	ETF	320.8	321.06	320.24	320.6	188416.0
2021-03-16 09:00:00	QQQ	ETF	320.59	321.22	320.45	321.14	119949.0
2021-03-16 09:30:00	QQQ	ETF	321.09	322.78	320.43	322.66	5545004.0
2021-03-16 10:00:00	QQQ	ETF	322.66	323.5099	322.3764	323.5	3843969.0
2021-03-16 10:30:00	QQQ	ETF	323.51	324.2	323.34	323.87	3283897.0
2021-03-16 11:00:00	QQQ	ETF	323.87	324.1	323.53	323.8	2121672.0
2021-03-16 11:30:00	QQQ	ETF	323.815	324.05	323.03	323.14	2158449.0
2021-03-16 12:00:00	QQQ	ETF	323.18	323.4482	321.34	321.68	2800335.0
2021-03-16 12:30:00	QQQ	ETF	321.7	322.6	321.565	322.36	1957140.0

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

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