PREVIEW / etf_30min / 2019-11-12

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-12.parquet
  size:    510 KB
  rows:    17,713

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-11-12 04:00:00	SPY	ETF	308.67	308.7	308.6	308.66	2211.0
2019-11-12 04:30:00	SPY	ETF	308.68	308.75	308.4	308.53	3585.0
2019-11-12 05:00:00	SPY	ETF	308.7	308.92	308.61	308.78	7910.0
2019-11-12 05:30:00	SPY	ETF	308.78	308.9	308.78	308.82	4900.0
2019-11-12 06:00:00	SPY	ETF	308.87	308.97	308.85	308.85	5226.0
2019-11-12 06:30:00	SPY	ETF	308.82	308.82	308.65	308.7	7751.0
2019-11-12 07:00:00	SPY	ETF	308.71	308.75	308.65	308.75	50955.0
2019-11-12 07:30:00	SPY	ETF	308.74	308.78	308.7	308.7	11343.0
2019-11-12 08:00:00	SPY	ETF	308.76	309.05	308.0	308.72	212678.0
2019-11-12 08:30:00	SPY	ETF	308.69	308.69	308.46	308.6	81518.0
2019-11-12 09:00:00	SPY	ETF	308.62	308.82	308.62	308.721	153195.0
2019-11-12 09:30:00	SPY	ETF	308.75	309.465	308.55	309.45	3486793.0
2019-11-12 10:00:00	SPY	ETF	309.46	309.89	309.2801	309.7967	3702528.0
2019-11-12 10:30:00	SPY	ETF	309.8	309.99	309.71	309.7516	3936870.0
2019-11-12 11:00:00	SPY	ETF	309.755	309.87	309.6	309.7	1969736.0
2019-11-12 11:30:00	SPY	ETF	309.7	309.75	309.32	309.3803	3666862.0
2019-11-12 12:00:00	SPY	ETF	309.39	309.53	309.08	309.235	2385081.0
2019-11-12 12:30:00	SPY	ETF	309.23	309.42	308.96	309.33	2503711.0
2019-11-12 13:00:00	SPY	ETF	309.32	309.51	309.27	309.27	2473630.0
2019-11-12 13:30:00	SPY	ETF	309.275	309.6	309.23	309.505	1300433.0
2019-11-12 14:00:00	SPY	ETF	309.5	309.51	308.7	308.83	2412760.0
2019-11-12 14:30:00	SPY	ETF	308.8211	308.98	308.15	308.395	3259842.0
2019-11-12 15:00:00	SPY	ETF	308.3958	308.7	308.36	308.64	3543381.0
2019-11-12 15:30:00	SPY	ETF	308.65	309.04	308.62	308.94	6208003.0
2019-11-12 16:00:00	SPY	ETF	308.95	309.02	308.76	308.98	1703366.0
2019-11-12 16:30:00	SPY	ETF	308.99	309.01	308.8	308.85	219291.0
2019-11-12 17:00:00	SPY	ETF	308.85	309.03	308.67	308.68	1165224.0
2019-11-12 17:30:00	SPY	ETF	308.68	308.81	308.65	308.81	52101.0
2019-11-12 18:00:00	SPY	ETF	308.82	308.95	308.58	308.6	199493.0
2019-11-12 18:30:00	SPY	ETF	308.6	308.66	308.6	308.66	8141.0
2019-11-12 19:00:00	SPY	ETF	308.65	308.65	308.45	308.49	71201.0
2019-11-12 19:30:00	SPY	ETF	308.54	308.54	308.32	308.4	40461.0
2019-11-12 04:00:00	QQQ	ETF	201.09	201.15	201.09	201.13	592.0
2019-11-12 04:30:00	QQQ	ETF	201.18	201.19	200.93	200.98	1430.0
2019-11-12 05:00:00	QQQ	ETF	201.1	201.31	201.1	201.24	14400.0
2019-11-12 05:30:00	QQQ	ETF	201.27	201.37	201.27	201.32	8500.0
2019-11-12 06:00:00	QQQ	ETF	201.38	201.38	201.24	201.26	6050.0
2019-11-12 06:30:00	QQQ	ETF	201.25	201.29	201.14	201.16	5779.0
2019-11-12 07:00:00	QQQ	ETF	201.19	201.23	201.11	201.23	28106.0
2019-11-12 07:30:00	QQQ	ETF	201.21	201.23	201.18	201.21	6232.0
2019-11-12 08:00:00	QQQ	ETF	201.2199	201.5	200.97	201.21	20647.0
2019-11-12 08:30:00	QQQ	ETF	201.2	201.21	201.02	201.05	44591.0
2019-11-12 09:00:00	QQQ	ETF	201.1	201.2	201.09	201.11	42837.0
2019-11-12 09:30:00	QQQ	ETF	201.13	201.57	201.05	201.5401	1793308.0
2019-11-12 10:00:00	QQQ	ETF	201.55	201.9	201.44	201.84	2046798.0
2019-11-12 10:30:00	QQQ	ETF	201.83	202.085	201.77	201.94	665426.0
2019-11-12 11:00:00	QQQ	ETF	201.96	202.21	201.79	202.1	606963.0
2019-11-12 11:30:00	QQQ	ETF	202.11	202.15	201.81	201.85	573516.0
2019-11-12 12:00:00	QQQ	ETF	201.855	202.06	201.68	201.8274	699301.0
2019-11-12 12:30:00	QQQ	ETF	201.83	201.95	201.63	201.87	439022.0

> showing 50 of 17,713 rows — these rows as CSV

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