PREVIEW / etf_30min / 2020-06-01

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-01.parquet
  size:    554 KB
  rows:    20,739

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-06-01 04:00:00	SPY	ETF	305.0	305.31	302.45	303.15	812143.0
2020-06-01 04:30:00	SPY	ETF	303.26	304.01	303.02	303.88	454228.0
2020-06-01 05:00:00	SPY	ETF	303.84	304.21	303.65	303.83	222635.0
2020-06-01 05:30:00	SPY	ETF	303.81	304.19	303.39	303.56	228381.0
2020-06-01 06:00:00	SPY	ETF	303.5	304.06	303.2	303.95	152836.0
2020-06-01 06:30:00	SPY	ETF	303.98	304.37	303.62	304.36	69225.0
2020-06-01 07:00:00	SPY	ETF	304.42	305.05	304.2	304.78	242267.0
2020-06-01 07:30:00	SPY	ETF	304.79	305.02	304.56	304.58	172556.0
2020-06-01 08:00:00	SPY	ETF	304.8899	305.5	303.8396	304.21	431265.0
2020-06-01 08:30:00	SPY	ETF	304.21	304.78	303.56	303.84	1402802.0
2020-06-01 09:00:00	SPY	ETF	303.81	303.81	303.26	303.6	384821.0
2020-06-01 09:30:00	SPY	ETF	303.62	304.71	303.06	304.21	7749463.0
2020-06-01 10:00:00	SPY	ETF	304.2065	305.09	303.95	304.98	5859795.0
2020-06-01 10:30:00	SPY	ETF	305.0	305.29	304.66	305.07	2718107.0
2020-06-01 11:00:00	SPY	ETF	305.055	305.14	304.25	304.52	3080207.0
2020-06-01 11:30:00	SPY	ETF	304.51	305.08	304.45	305.005	2244402.0
2020-06-01 12:00:00	SPY	ETF	304.99	305.43	304.705	305.299	2142292.0
2020-06-01 12:30:00	SPY	ETF	305.29	305.67	305.29	305.5	2220296.0
2020-06-01 13:00:00	SPY	ETF	305.5	306.11	305.4733	305.995	1950876.0
2020-06-01 13:30:00	SPY	ETF	305.99	306.205	305.76	305.905	2270504.0
2020-06-01 14:00:00	SPY	ETF	305.91	305.99	305.55	305.56	2242442.0
2020-06-01 14:30:00	SPY	ETF	305.55	306.04	305.47	305.98	2492693.0
2020-06-01 15:00:00	SPY	ETF	305.99	306.15	305.41	305.84	3387380.0
2020-06-01 15:30:00	SPY	ETF	305.84	306.02	305.25	305.58	7828276.0
2020-06-01 16:00:00	SPY	ETF	305.59	305.75	305.1196	305.74	3070521.0
2020-06-01 16:30:00	SPY	ETF	305.72	305.86	305.55	305.75	211143.0
2020-06-01 17:00:00	SPY	ETF	305.68	305.75	305.55	305.62	58253.0
2020-06-01 17:30:00	SPY	ETF	305.63	305.67	305.54	305.54	36650.0
2020-06-01 18:00:00	SPY	ETF	305.54	305.77	305.43	305.74	117381.0
2020-06-01 18:30:00	SPY	ETF	305.75	305.76	304.56	304.9299	395043.0
2020-06-01 19:00:00	SPY	ETF	304.8	304.87	303.88	304.23	411830.0
2020-06-01 19:30:00	SPY	ETF	304.33	304.64	304.0	304.19	158271.0
2020-06-01 04:00:00	QQQ	ETF	233.37	233.52	231.42	231.87	68473.0
2020-06-01 04:30:00	QQQ	ETF	231.99	232.48	231.83	232.26	30258.0
2020-06-01 05:00:00	QQQ	ETF	232.21	232.45	232.1	232.2	14989.0
2020-06-01 05:30:00	QQQ	ETF	232.31	232.43	231.69	231.89	19340.0
2020-06-01 06:00:00	QQQ	ETF	231.8	232.36	231.69	232.16	45354.0
2020-06-01 06:30:00	QQQ	ETF	232.25	232.52	231.9	232.52	16625.0
2020-06-01 07:00:00	QQQ	ETF	232.59	233.0	232.55	232.89	53905.0
2020-06-01 07:30:00	QQQ	ETF	232.9	233.07	232.75	232.75	52172.0
2020-06-01 08:00:00	QQQ	ETF	232.86	233.89	231.96	232.5201	142133.0
2020-06-01 08:30:00	QQQ	ETF	232.53	232.91	232.25	232.4	274520.0
2020-06-01 09:00:00	QQQ	ETF	232.3	232.479	232.05	232.37	252652.0
2020-06-01 09:30:00	QQQ	ETF	232.4	233.47	232.0	233.12	3916874.0
2020-06-01 10:00:00	QQQ	ETF	233.13	233.92	232.9	233.48	2615825.0
2020-06-01 10:30:00	QQQ	ETF	233.5	233.79	233.06	233.63	1524380.0
2020-06-01 11:00:00	QQQ	ETF	233.64	233.72	232.74	233.08	1442708.0
2020-06-01 11:30:00	QQQ	ETF	233.05	233.5	233.03	233.42	1003857.0
2020-06-01 12:00:00	QQQ	ETF	233.4	233.79	233.11	233.67	1035871.0
2020-06-01 12:30:00	QQQ	ETF	233.67	234.14	233.662	233.845	989979.0

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

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