PREVIEW / etf_30min / 2018-07-09

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-07-09.parquet
  size:    471 KB
  rows:    16,487

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
2018-07-09 04:00:00	SPY	ETF	276.52	276.62	276.42	276.46	2306.0
2018-07-09 04:30:00	SPY	ETF	276.49	276.49	276.28	276.28	663.0
2018-07-09 05:00:00	SPY	ETF	276.35	276.46	276.35	276.46	742.0
2018-07-09 05:30:00	SPY	ETF	276.5	276.62	276.5	276.62	6190.0
2018-07-09 06:00:00	SPY	ETF	276.6	276.6	276.6	276.6	150.0
2018-07-09 06:30:00	SPY	ETF	276.57	276.6	276.5	276.6	6500.0
2018-07-09 07:00:00	SPY	ETF	276.6	276.74	276.47	276.52	93991.0
2018-07-09 07:30:00	SPY	ETF	276.48	276.56	276.44	276.53	58307.0
2018-07-09 08:00:00	SPY	ETF	276.52	276.68	275.42	276.54	98478.0
2018-07-09 08:30:00	SPY	ETF	276.57	276.57	276.42	276.45	106864.0
2018-07-09 09:00:00	SPY	ETF	276.45	276.59	276.45	276.54	218159.0
2018-07-09 09:30:00	SPY	ETF	276.55	277.13	276.52	276.86	5400311.0
2018-07-09 10:00:00	SPY	ETF	276.87	276.94	276.5	276.77	4619359.0
2018-07-09 10:30:00	SPY	ETF	276.775	277.26	276.76	277.255	2435373.0
2018-07-09 11:00:00	SPY	ETF	277.25	277.5	277.19	277.31	3383120.0
2018-07-09 11:30:00	SPY	ETF	277.31	277.61	277.14	277.5	2636032.0
2018-07-09 12:00:00	SPY	ETF	277.5	277.77	277.4601	277.57	2791928.0
2018-07-09 12:30:00	SPY	ETF	277.58	277.6299	277.33	277.5	2828767.0
2018-07-09 13:00:00	SPY	ETF	277.495	277.63	277.18	277.355	2641613.0
2018-07-09 13:30:00	SPY	ETF	277.35	277.56	277.33	277.505	1433987.0
2018-07-09 14:00:00	SPY	ETF	277.51	277.59	277.37	277.54	1125037.0
2018-07-09 14:30:00	SPY	ETF	277.54	277.81	277.51	277.74	1750948.0
2018-07-09 15:00:00	SPY	ETF	277.74	277.85	277.47	277.65	2086516.0
2018-07-09 15:30:00	SPY	ETF	277.65	277.96	277.575	277.89	7582516.0
2018-07-09 16:00:00	SPY	ETF	277.89	278.01	276.5	277.96	5928342.0
2018-07-09 16:30:00	SPY	ETF	277.98	278.03	277.94	277.97	68134.0
2018-07-09 17:00:00	SPY	ETF	277.97	278.06	277.95	278.04	81150.0
2018-07-09 17:30:00	SPY	ETF	278.02	278.02	277.9	278.0	678616.0
2018-07-09 18:00:00	SPY	ETF	278.01	278.01	277.9	278.01	94369.0
2018-07-09 18:30:00	SPY	ETF	277.97	278.3	277.97	278.3	34703.0
2018-07-09 19:00:00	SPY	ETF	278.24	278.35	278.24	278.3	39247.0
2018-07-09 19:30:00	SPY	ETF	278.31	278.43	278.25	278.37	42207.0
2018-07-09 03:30:00	QQQ	ETF	176.29	176.29	176.29	176.29	100.0
2018-07-09 04:00:00	QQQ	ETF	176.4	176.4	176.26	176.31	1900.0
2018-07-09 04:30:00	QQQ	ETF	176.3	176.3	176.28	176.28	200.0
2018-07-09 05:30:00	QQQ	ETF	176.32	176.4	176.31	176.4	1405.0
2018-07-09 06:00:00	QQQ	ETF	176.35	176.37	176.3	176.32	1227.0
2018-07-09 06:30:00	QQQ	ETF	176.35	176.61	176.23	176.32	16010.0
2018-07-09 07:00:00	QQQ	ETF	176.29	176.41	176.23	176.29	34660.0
2018-07-09 07:30:00	QQQ	ETF	176.27	176.35	176.25	176.32	15127.0
2018-07-09 08:00:00	QQQ	ETF	176.29	176.52	176.26	176.49	60311.0
2018-07-09 08:30:00	QQQ	ETF	176.5	176.57	176.43	176.46	60451.0
2018-07-09 09:00:00	QQQ	ETF	176.47	176.51	176.4	176.5	134579.0
2018-07-09 09:30:00	QQQ	ETF	176.5	176.83	176.22	176.385	3373968.0
2018-07-09 10:00:00	QQQ	ETF	176.38	176.45	175.82	175.92	1839367.0
2018-07-09 10:30:00	QQQ	ETF	175.92	176.34	175.86	176.31	1860710.0
2018-07-09 11:00:00	QQQ	ETF	176.31	176.58	176.25	176.4266	1219451.0
2018-07-09 11:30:00	QQQ	ETF	176.43	176.59	176.19	176.51	967573.0
2018-07-09 12:00:00	QQQ	ETF	176.53	176.65	176.3	176.35	710213.0
2018-07-09 12:30:00	QQQ	ETF	176.345	176.4251	176.21	176.35	771461.0

> showing 50 of 16,487 rows — these rows as CSV

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