PREVIEW / etf_30min / 2019-07-03

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-03.parquet
  size:    323 KB
  rows:    10,855

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
2019-07-03 04:00:00	SPY	ETF	297.16	297.31	297.13	297.23	15367.0
2019-07-03 04:30:00	SPY	ETF	297.34	297.56	297.34	297.5	5614.0
2019-07-03 05:00:00	SPY	ETF	297.55	297.66	297.51	297.63	6740.0
2019-07-03 05:30:00	SPY	ETF	297.58	297.6	297.53	297.6	1140.0
2019-07-03 06:00:00	SPY	ETF	297.55	297.69	297.5	297.6	8100.0
2019-07-03 06:30:00	SPY	ETF	297.6	297.68	297.58	297.68	36440.0
2019-07-03 07:00:00	SPY	ETF	297.63	297.7	297.47	297.5	37867.0
2019-07-03 07:30:00	SPY	ETF	297.5	297.54	297.39	297.39	59575.0
2019-07-03 08:00:00	SPY	ETF	297.63	297.68	296.41	297.49	221061.0
2019-07-03 08:30:00	SPY	ETF	297.5	297.51	297.29	297.43	88926.0
2019-07-03 09:00:00	SPY	ETF	297.42	297.49	297.18	297.19	127308.0
2019-07-03 09:30:00	SPY	ETF	297.18	297.44	297.02	297.345	4146272.0
2019-07-03 10:00:00	SPY	ETF	297.32	297.68	297.2	297.66	2496086.0
2019-07-03 10:30:00	SPY	ETF	297.66	298.01	297.6	297.91	4013298.0
2019-07-03 11:00:00	SPY	ETF	297.905	298.05	297.65	297.8201	2576199.0
2019-07-03 11:30:00	SPY	ETF	297.82	298.35	297.7901	298.34	3786193.0
2019-07-03 12:00:00	SPY	ETF	298.33	298.52	298.2602	298.44	4186623.0
2019-07-03 12:30:00	SPY	ETF	298.44	298.82	298.3	298.76	8775666.0
2019-07-03 13:00:00	SPY	ETF	298.75	298.95	298.66	298.86	2499355.0
2019-07-03 13:30:00	SPY	ETF	298.86	298.89	298.48	298.56	3083662.0
2019-07-03 14:00:00	SPY	ETF	298.56	298.87	298.53	298.63	77050.0
2019-07-03 14:30:00	SPY	ETF	298.61	298.88	298.59	298.6	518922.0
2019-07-03 15:00:00	SPY	ETF	298.62	298.7201	298.62	298.71	6842.0
2019-07-03 15:30:00	SPY	ETF	298.6999	298.74	298.67	298.72	4780.0
2019-07-03 16:00:00	SPY	ETF	298.7	298.79	298.67	298.73	10265.0
2019-07-03 16:30:00	SPY	ETF	298.75	298.77	298.56	298.77	15788.0
2019-07-03 04:00:00	QQQ	ETF	190.75	190.91	190.74	190.81	9902.0
2019-07-03 04:30:00	QQQ	ETF	190.87	191.03	190.87	190.99	8967.0
2019-07-03 05:00:00	QQQ	ETF	191.03	191.16	190.96	191.1	7008.0
2019-07-03 05:30:00	QQQ	ETF	191.06	191.06	190.96	191.03	4400.0
2019-07-03 06:00:00	QQQ	ETF	190.99	191.16	190.97	191.16	13038.0
2019-07-03 06:30:00	QQQ	ETF	191.1	191.12	191.06	191.08	2400.0
2019-07-03 07:00:00	QQQ	ETF	191.07	191.08	190.93	190.93	16342.0
2019-07-03 07:30:00	QQQ	ETF	190.85	190.91	190.76	190.76	20455.0
2019-07-03 08:00:00	QQQ	ETF	190.74	191.06	190.12	190.84	39495.0
2019-07-03 08:30:00	QQQ	ETF	190.82	190.84	190.64	190.72	92417.0
2019-07-03 09:00:00	QQQ	ETF	190.73	190.77	190.45	190.45	66043.0
2019-07-03 09:30:00	QQQ	ETF	190.45	190.68	190.29	190.58	2414130.0
2019-07-03 10:00:00	QQQ	ETF	190.58	190.865	190.48	190.8599	1508002.0
2019-07-03 10:30:00	QQQ	ETF	190.86	191.13	190.83	191.05	1696739.0
2019-07-03 11:00:00	QQQ	ETF	191.05	191.19	190.79	190.875	1426230.0
2019-07-03 11:30:00	QQQ	ETF	190.87	191.16	190.85	191.12	1167367.0
2019-07-03 12:00:00	QQQ	ETF	191.115	191.26	191.01	191.1723	850444.0
2019-07-03 12:30:00	QQQ	ETF	191.1727	191.44	191.15	191.44	3080462.0
2019-07-03 13:00:00	QQQ	ETF	191.43	191.68	191.42	191.56	755472.0
2019-07-03 13:30:00	QQQ	ETF	191.55	191.64	191.4	191.4	19275.0
2019-07-03 14:00:00	QQQ	ETF	191.39	191.52	191.35	191.52	359926.0
2019-07-03 14:30:00	QQQ	ETF	191.54	191.64	191.46	191.5139	8669.0
2019-07-03 15:00:00	QQQ	ETF	191.53	191.53	191.5	191.5	5251.0
2019-07-03 15:30:00	QQQ	ETF	191.5	191.54	191.5	191.54	5555.0

> showing 50 of 10,855 rows — these rows as CSV

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