PREVIEW / etf_30min / 2020-07-22

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-22.parquet
  size:    550 KB
  rows:    20,440

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
2020-07-22 04:00:00	SPY	ETF	324.5	324.5	324.1	324.29	13948.0
2020-07-22 04:30:00	SPY	ETF	324.34	324.34	323.33	323.57	42972.0
2020-07-22 05:00:00	SPY	ETF	323.61	323.61	322.79	323.15	31049.0
2020-07-22 05:30:00	SPY	ETF	323.12	324.11	323.12	324.11	29676.0
2020-07-22 06:00:00	SPY	ETF	324.16	324.16	323.62	323.92	61208.0
2020-07-22 06:30:00	SPY	ETF	323.92	324.37	323.89	324.14	130040.0
2020-07-22 07:00:00	SPY	ETF	324.22	324.82	324.17	324.65	275510.0
2020-07-22 07:30:00	SPY	ETF	324.66	324.85	324.45	324.75	147835.0
2020-07-22 08:00:00	SPY	ETF	324.76	326.3	323.7	324.67	205902.0
2020-07-22 08:30:00	SPY	ETF	324.69	324.83	324.35	324.81	221978.0
2020-07-22 09:00:00	SPY	ETF	324.72	324.86	324.37	324.61	292823.0
2020-07-22 09:30:00	SPY	ETF	324.62	326.16	324.54	325.71	6050357.0
2020-07-22 10:00:00	SPY	ETF	325.72	326.02	325.28	325.3	2723247.0
2020-07-22 10:30:00	SPY	ETF	325.305	325.79	324.7	325.2001	3373333.0
2020-07-22 11:00:00	SPY	ETF	325.21	325.465	324.5	325.39	2422568.0
2020-07-22 11:30:00	SPY	ETF	325.39	325.8	325.32	325.6	1655122.0
2020-07-22 12:00:00	SPY	ETF	325.61	326.3216	325.44	325.99	1924923.0
2020-07-22 12:30:00	SPY	ETF	325.99	326.09	325.68	325.865	1445754.0
2020-07-22 13:00:00	SPY	ETF	325.8614	326.03	325.66	325.762	1181569.0
2020-07-22 13:30:00	SPY	ETF	325.77	325.82	324.74	324.77	2340551.0
2020-07-22 14:00:00	SPY	ETF	324.77	325.53	324.73	325.529	2704202.0
2020-07-22 14:30:00	SPY	ETF	325.52	325.9377	325.22	325.76	3389096.0
2020-07-22 15:00:00	SPY	ETF	325.7783	326.48	325.67	326.02	6650534.0
2020-07-22 15:30:00	SPY	ETF	326.02	327.2	325.93	326.82	10019589.0
2020-07-22 16:00:00	SPY	ETF	326.81	327.13	326.43	326.67	9032767.0
2020-07-22 16:30:00	SPY	ETF	326.69	326.96	326.64	326.73	192073.0
2020-07-22 17:00:00	SPY	ETF	326.7	326.82	326.65	326.78	52148.0
2020-07-22 17:30:00	SPY	ETF	326.78	326.78	326.6	326.72	37716.0
2020-07-22 18:00:00	SPY	ETF	326.72	326.99	326.41	326.81	107158.0
2020-07-22 18:30:00	SPY	ETF	326.76	326.77	326.57	326.7	21287.0
2020-07-22 19:00:00	SPY	ETF	326.7	326.72	326.44	326.59	65923.0
2020-07-22 19:30:00	SPY	ETF	326.56	326.59	326.05	326.11	49581.0
2020-07-22 04:00:00	QQQ	ETF	263.81	263.87	263.44	263.79	16480.0
2020-07-22 04:30:00	QQQ	ETF	263.75	263.75	263.11	263.53	20581.0
2020-07-22 05:00:00	QQQ	ETF	263.5	263.71	263.15	263.45	9942.0
2020-07-22 05:30:00	QQQ	ETF	263.89	264.47	263.89	264.31	17458.0
2020-07-22 06:00:00	QQQ	ETF	264.35	265.06	264.22	264.84	12243.0
2020-07-22 06:30:00	QQQ	ETF	264.88	265.29	264.81	265.17	26699.0
2020-07-22 07:00:00	QQQ	ETF	265.14	265.45	265.13	265.42	122029.0
2020-07-22 07:30:00	QQQ	ETF	265.37	265.42	264.94	265.0	98248.0
2020-07-22 08:00:00	QQQ	ETF	265.21	265.77	263.81	265.19	113085.0
2020-07-22 08:30:00	QQQ	ETF	265.19	265.68	264.59	265.13	95551.0
2020-07-22 09:00:00	QQQ	ETF	265.2	265.4	264.0	264.45	275455.0
2020-07-22 09:30:00	QQQ	ETF	264.44	265.795	263.99	265.3299	3689896.0
2020-07-22 10:00:00	QQQ	ETF	265.33	265.89	264.61	264.62	1698875.0
2020-07-22 10:30:00	QQQ	ETF	264.61	264.94	263.11	263.475	2347035.0
2020-07-22 11:00:00	QQQ	ETF	263.47	263.89	262.55	263.87	2403625.0
2020-07-22 11:30:00	QQQ	ETF	263.87	264.49	263.83	264.24	1180565.0
2020-07-22 12:00:00	QQQ	ETF	264.28	264.97	263.85	264.68	1247895.0
2020-07-22 12:30:00	QQQ	ETF	264.709	264.78	263.9101	264.2076	811198.0

> showing 50 of 20,440 rows — these rows as CSV

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