PREVIEW / etf_30min / 2019-01-08

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-08.parquet
  size:    508 KB
  rows:    17,868

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-01-08 04:00:00	SPY	ETF	255.4	256.15	255.4	255.77	14874.0
2019-01-08 04:30:00	SPY	ETF	255.71	255.8	254.52	255.42	51615.0
2019-01-08 05:00:00	SPY	ETF	255.37	255.5	255.28	255.5	18311.0
2019-01-08 05:30:00	SPY	ETF	255.37	255.92	255.37	255.87	23401.0
2019-01-08 06:00:00	SPY	ETF	255.83	255.94	255.68	255.74	14592.0
2019-01-08 06:30:00	SPY	ETF	255.8	256.43	255.77	256.21	182168.0
2019-01-08 07:00:00	SPY	ETF	256.25	256.39	255.89	255.95	220784.0
2019-01-08 07:30:00	SPY	ETF	255.91	256.08	255.57	255.92	224502.0
2019-01-08 08:00:00	SPY	ETF	255.9	256.37	254.565	256.05	753758.0
2019-01-08 08:30:00	SPY	ETF	256.04	256.65	255.93	256.61	994070.0
2019-01-08 09:00:00	SPY	ETF	256.59	256.82	256.51	256.78	616439.0
2019-01-08 09:30:00	SPY	ETF	256.82	257.31	255.98	256.22	12225749.0
2019-01-08 10:00:00	SPY	ETF	256.22	256.71	254.9826	255.39	10676772.0
2019-01-08 10:30:00	SPY	ETF	255.4	255.62	254.0	254.49	9384588.0
2019-01-08 11:00:00	SPY	ETF	254.48	255.31	254.42	254.82	5861267.0
2019-01-08 11:30:00	SPY	ETF	254.82	255.3799	254.31	255.29	5809762.0
2019-01-08 12:00:00	SPY	ETF	255.3	256.06	255.12	255.83	4829723.0
2019-01-08 12:30:00	SPY	ETF	255.83	255.98	254.71	255.2	5486580.0
2019-01-08 13:00:00	SPY	ETF	255.21	255.84	254.91	255.7	3856900.0
2019-01-08 13:30:00	SPY	ETF	255.7	256.47	255.36	256.21	5021951.0
2019-01-08 14:00:00	SPY	ETF	256.22	256.53	255.92	256.1201	3908546.0
2019-01-08 14:30:00	SPY	ETF	256.12	256.59	256.01	256.24	3731262.0
2019-01-08 15:00:00	SPY	ETF	256.24	256.69	255.8	256.69	4595068.0
2019-01-08 15:30:00	SPY	ETF	256.695	256.94	256.42	256.69	14872071.0
2019-01-08 16:00:00	SPY	ETF	256.7	256.82	256.4	256.42	6835015.0
2019-01-08 16:30:00	SPY	ETF	256.42	256.77	256.21	256.28	464475.0
2019-01-08 17:00:00	SPY	ETF	256.27	256.35	256.25	256.34	377694.0
2019-01-08 17:30:00	SPY	ETF	256.34	256.6	256.25	256.26	269189.0
2019-01-08 18:00:00	SPY	ETF	256.25	256.64	256.2	256.54	211495.0
2019-01-08 18:30:00	SPY	ETF	256.54	256.99	256.51	256.96	76697.0
2019-01-08 19:00:00	SPY	ETF	256.84	257.2	256.84	257.0	98840.0
2019-01-08 19:30:00	SPY	ETF	256.95	257.11	256.78	256.89	59478.0
2019-01-08 04:00:00	QQQ	ETF	158.78	159.0	158.75	158.84	92975.0
2019-01-08 04:30:00	QQQ	ETF	158.76	158.94	158.61	158.63	14222.0
2019-01-08 05:00:00	QQQ	ETF	158.59	158.64	158.45	158.52	7387.0
2019-01-08 05:30:00	QQQ	ETF	158.52	158.96	158.52	158.95	18438.0
2019-01-08 06:00:00	QQQ	ETF	158.85	158.95	158.77	158.77	9417.0
2019-01-08 06:30:00	QQQ	ETF	158.87	159.33	158.87	159.25	17205.0
2019-01-08 07:00:00	QQQ	ETF	159.22	159.4	159.1	159.11	81851.0
2019-01-08 07:30:00	QQQ	ETF	159.12	159.13	158.86	159.04	155707.0
2019-01-08 08:00:00	QQQ	ETF	159.3099	159.35	158.6	159.07	146607.0
2019-01-08 08:30:00	QQQ	ETF	159.1	159.46	159.05	159.42	375322.0
2019-01-08 09:00:00	QQQ	ETF	159.42	159.55	159.37	159.54	173707.0
2019-01-08 09:30:00	QQQ	ETF	159.56	160.11	158.87	159.012	7591207.0
2019-01-08 10:00:00	QQQ	ETF	159.01	159.4	158.21	158.47	4332299.0
2019-01-08 10:30:00	QQQ	ETF	158.49	158.63	157.2	157.6	4695791.0
2019-01-08 11:00:00	QQQ	ETF	157.605	158.48	157.54	158.1	2865888.0
2019-01-08 11:30:00	QQQ	ETF	158.11	158.54	157.73	158.4879	2397658.0
2019-01-08 12:00:00	QQQ	ETF	158.49	159.11	158.39	158.935	2348966.0
2019-01-08 12:30:00	QQQ	ETF	158.9399	159.06	158.25	158.54	2166985.0

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

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