PREVIEW / etf_30min / 2019-02-15

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-15.parquet
  size:    493 KB
  rows:    17,191

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-02-15 04:00:00	SPY	ETF	273.4	273.46	273.37	273.46	1486.0
2019-02-15 04:30:00	SPY	ETF	273.73	273.9	273.73	273.9	3400.0
2019-02-15 05:00:00	SPY	ETF	273.9	274.03	273.7	273.73	10562.0
2019-02-15 05:30:00	SPY	ETF	273.75	274.55	273.75	274.37	54406.0
2019-02-15 06:00:00	SPY	ETF	274.46	274.79	274.42	274.74	17484.0
2019-02-15 06:30:00	SPY	ETF	274.66	274.68	274.37	274.37	38961.0
2019-02-15 07:00:00	SPY	ETF	274.37	274.59	274.35	274.44	70345.0
2019-02-15 07:30:00	SPY	ETF	274.43	275.07	274.43	275.04	438092.0
2019-02-15 08:00:00	SPY	ETF	273.8	275.16	272.85	274.97	413098.0
2019-02-15 08:30:00	SPY	ETF	274.97	275.52	274.89	275.31	672057.0
2019-02-15 09:00:00	SPY	ETF	275.35	276.71	275.27	276.37	1320177.0
2019-02-15 09:30:00	SPY	ETF	276.36	276.96	276.19	276.58	13758134.0
2019-02-15 10:00:00	SPY	ETF	276.58	276.98	276.22	276.77	10867184.0
2019-02-15 10:30:00	SPY	ETF	276.77	277.13	276.41	276.49	7685246.0
2019-02-15 11:00:00	SPY	ETF	276.49	276.92	276.13	276.65	5304369.0
2019-02-15 11:30:00	SPY	ETF	276.64	276.77	276.31	276.7	3398207.0
2019-02-15 12:00:00	SPY	ETF	276.71	276.9	276.51	276.74	2895068.0
2019-02-15 12:30:00	SPY	ETF	276.75	276.88	276.575	276.6	1923622.0
2019-02-15 13:00:00	SPY	ETF	276.605	276.74	276.27	276.28	2424309.0
2019-02-15 13:30:00	SPY	ETF	276.28	276.64	276.26	276.49	1799911.0
2019-02-15 14:00:00	SPY	ETF	276.49	276.745	276.49	276.61	4139918.0
2019-02-15 14:30:00	SPY	ETF	276.61	277.03	276.595	276.94	3143972.0
2019-02-15 15:00:00	SPY	ETF	276.9348	276.9375	276.5	276.655	6133990.0
2019-02-15 15:30:00	SPY	ETF	276.65	277.41	276.6	277.39	14309661.0
2019-02-15 16:00:00	SPY	ETF	277.39	279.0643	277.1318	277.5	12188411.0
2019-02-15 16:30:00	SPY	ETF	277.51	277.63	277.37	277.55	478657.0
2019-02-15 17:00:00	SPY	ETF	277.56	277.75	277.37	277.65	811707.0
2019-02-15 17:30:00	SPY	ETF	277.63	277.7	277.59	277.7	50962.0
2019-02-15 18:00:00	SPY	ETF	277.73	277.95	277.7	277.84	129390.0
2019-02-15 18:30:00	SPY	ETF	277.85	277.96	277.85	277.85	124939.0
2019-02-15 19:00:00	SPY	ETF	277.86	277.91	277.83	277.89	28729.0
2019-02-15 19:30:00	SPY	ETF	277.89	278.0	277.89	278.0	47084.0
2019-02-15 04:00:00	QQQ	ETF	170.45	170.51	170.42	170.5	4238.0
2019-02-15 04:30:00	QQQ	ETF	170.5	170.71	170.5	170.71	4141.0
2019-02-15 05:00:00	QQQ	ETF	170.62	170.85	170.62	170.85	14493.0
2019-02-15 05:30:00	QQQ	ETF	170.73	171.15	170.73	171.12	18155.0
2019-02-15 06:00:00	QQQ	ETF	171.15	171.38	171.1	171.29	33989.0
2019-02-15 06:30:00	QQQ	ETF	171.35	171.35	171.08	171.08	12280.0
2019-02-15 07:00:00	QQQ	ETF	171.07	171.22	171.04	171.08	12948.0
2019-02-15 07:30:00	QQQ	ETF	171.07	171.56	171.07	171.52	136844.0
2019-02-15 08:00:00	QQQ	ETF	171.22	171.64	170.0	171.49	123600.0
2019-02-15 08:30:00	QQQ	ETF	171.5	171.97	171.45	171.81	175416.0
2019-02-15 09:00:00	QQQ	ETF	171.86	172.81	171.77	172.54	506039.0
2019-02-15 09:30:00	QQQ	ETF	172.51	172.53	171.43	171.64	4831222.0
2019-02-15 10:00:00	QQQ	ETF	171.66	172.06	171.4	171.93	2676318.0
2019-02-15 10:30:00	QQQ	ETF	171.93	172.3	171.57	171.6375	2634673.0
2019-02-15 11:00:00	QQQ	ETF	171.65	171.94	171.1392	171.51	2346220.0
2019-02-15 11:30:00	QQQ	ETF	171.51	171.58	171.19	171.42	1491734.0
2019-02-15 12:00:00	QQQ	ETF	171.42	171.71	171.315	171.65	909407.0
2019-02-15 12:30:00	QQQ	ETF	171.635	171.7	171.42	171.44	698894.0

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

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