PREVIEW / etf_30min / 2018-02-26

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-26.parquet
  size:    480 KB
  rows:    16,573

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-02-26 04:00:00	SPY	ETF	275.7	276.1	275.69	275.81	22974.0
2018-02-26 04:30:00	SPY	ETF	275.69	275.93	275.65	275.75	6926.0
2018-02-26 05:00:00	SPY	ETF	275.76	275.95	275.76	275.91	17365.0
2018-02-26 05:30:00	SPY	ETF	275.95	275.98	275.83	275.96	8789.0
2018-02-26 06:00:00	SPY	ETF	276.0	276.07	275.92	275.92	4605.0
2018-02-26 06:30:00	SPY	ETF	275.88	275.98	275.8	275.88	13629.0
2018-02-26 07:00:00	SPY	ETF	275.88	276.05	275.82	275.87	121155.0
2018-02-26 07:30:00	SPY	ETF	275.84	275.94	275.63	275.91	34034.0
2018-02-26 08:00:00	SPY	ETF	275.95	276.03	275.35	275.66	134330.0
2018-02-26 08:30:00	SPY	ETF	275.69	276.05	275.69	275.8	395263.0
2018-02-26 09:00:00	SPY	ETF	275.77	276.04	275.72	275.89	299792.0
2018-02-26 09:30:00	SPY	ETF	275.93	276.69	275.69	276.22	8290008.0
2018-02-26 10:00:00	SPY	ETF	276.21	276.39	275.47	275.61	4523689.0
2018-02-26 10:30:00	SPY	ETF	275.62	275.96	275.26	275.62	3433305.0
2018-02-26 11:00:00	SPY	ETF	275.63	276.5	275.44	276.45	3684519.0
2018-02-26 11:30:00	SPY	ETF	276.45	276.55	276.14	276.28	2875754.0
2018-02-26 12:00:00	SPY	ETF	276.29	276.89	276.28	276.8701	2902639.0
2018-02-26 12:30:00	SPY	ETF	276.88	277.21	276.53	277.12	3313819.0
2018-02-26 13:00:00	SPY	ETF	277.11	277.3	277.0	277.3	2565780.0
2018-02-26 13:30:00	SPY	ETF	277.2902	277.34	277.08	277.2499	2425136.0
2018-02-26 14:00:00	SPY	ETF	277.245	277.53	277.22	277.25	3496687.0
2018-02-26 14:30:00	SPY	ETF	277.26	277.42	276.92	277.23	4919937.0
2018-02-26 15:00:00	SPY	ETF	277.22	277.95	277.13	277.87	10987650.0
2018-02-26 15:30:00	SPY	ETF	277.87	278.01	277.33	277.89	17452759.0
2018-02-26 16:00:00	SPY	ETF	277.89	278.4	274.6616	278.35	10268203.0
2018-02-26 16:30:00	SPY	ETF	278.37	278.54	278.32	278.35	506154.0
2018-02-26 17:00:00	SPY	ETF	278.35	278.39	278.32	278.37	35207.0
2018-02-26 17:30:00	SPY	ETF	278.33	278.39	275.72	278.33	1304805.0
2018-02-26 18:00:00	SPY	ETF	278.34	278.43	278.29	278.38	67102.0
2018-02-26 18:30:00	SPY	ETF	278.38	278.51	278.26	278.36	61727.0
2018-02-26 19:00:00	SPY	ETF	278.36	278.39	278.2	278.23	32253.0
2018-02-26 19:30:00	SPY	ETF	278.23	278.38	278.15	278.36	28273.0
2018-02-26 04:00:00	QQQ	ETF	168.5	168.75	168.5	168.52	7095.0
2018-02-26 04:30:00	QQQ	ETF	168.5	168.6	168.4	168.5	66850.0
2018-02-26 05:00:00	QQQ	ETF	168.49	168.64	168.49	168.57	5606.0
2018-02-26 05:30:00	QQQ	ETF	168.61	169.0	168.56	168.56	10845.0
2018-02-26 06:00:00	QQQ	ETF	168.78	168.81	168.75	168.79	16418.0
2018-02-26 06:30:00	QQQ	ETF	168.74	168.83	168.72	168.76	6072.0
2018-02-26 07:00:00	QQQ	ETF	168.77	168.9	168.77	168.81	38731.0
2018-02-26 07:30:00	QQQ	ETF	168.81	169.0	168.8	169.0	62039.0
2018-02-26 08:00:00	QQQ	ETF	168.8	169.08	168.48	168.89	160409.0
2018-02-26 08:30:00	QQQ	ETF	168.89	169.06	168.89	168.92	86759.0
2018-02-26 09:00:00	QQQ	ETF	168.94	169.02	168.85	168.9	157145.0
2018-02-26 09:30:00	QQQ	ETF	168.93	169.67	168.82	169.515	4224060.0
2018-02-26 10:00:00	QQQ	ETF	169.515	169.71	169.1	169.205	2723348.0
2018-02-26 10:30:00	QQQ	ETF	169.21	169.34	168.92	169.11	1828817.0
2018-02-26 11:00:00	QQQ	ETF	169.11	169.645	168.97	169.63	2318227.0
2018-02-26 11:30:00	QQQ	ETF	169.62	169.7052	169.4904	169.53	1328613.0
2018-02-26 12:00:00	QQQ	ETF	169.52	169.75	169.49	169.69	861145.0
2018-02-26 12:30:00	QQQ	ETF	169.69	169.85	169.5	169.8	1561695.0

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

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