PREVIEW / etf_30min / 2016-03-10

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-10.parquet
  size:    395 KB
  rows:    13,267

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
2016-03-10 04:00:00	SPY	ETF	199.93	200.13	199.9	200.0	23666.0
2016-03-10 04:30:00	SPY	ETF	199.96	200.01	199.69	199.72	19235.0
2016-03-10 05:00:00	SPY	ETF	199.6	199.85	199.59	199.76	6751.0
2016-03-10 05:30:00	SPY	ETF	199.8	199.94	199.74	199.78	13002.0
2016-03-10 06:00:00	SPY	ETF	199.76	200.1	199.72	200.08	8274.0
2016-03-10 06:30:00	SPY	ETF	200.2	200.22	199.97	200.01	33491.0
2016-03-10 07:00:00	SPY	ETF	200.07	200.49	200.07	200.35	243802.0
2016-03-10 07:30:00	SPY	ETF	200.35	201.59	200.0	201.41	2260137.0
2016-03-10 08:00:00	SPY	ETF	201.39	201.49	199.41	201.13	1306307.0
2016-03-10 08:30:00	SPY	ETF	201.14	201.46	200.43	200.74	1913240.0
2016-03-10 09:00:00	SPY	ETF	200.73	200.85	199.89	199.98	3588945.0
2016-03-10 09:30:00	SPY	ETF	199.96	200.89	199.6	200.79	15765725.0
2016-03-10 10:00:00	SPY	ETF	200.8	201.07	200.18	200.24	10301371.0
2016-03-10 10:30:00	SPY	ETF	200.24	200.24	199.01	199.095	14356441.0
2016-03-10 11:00:00	SPY	ETF	199.11	199.27	198.1	198.48	15598087.0
2016-03-10 11:30:00	SPY	ETF	198.48	198.8	198.01	198.58	10237967.0
2016-03-10 12:00:00	SPY	ETF	198.58	198.94	198.14	198.37	6756837.0
2016-03-10 12:30:00	SPY	ETF	198.37	198.42	197.45	197.885	11375698.0
2016-03-10 13:00:00	SPY	ETF	197.88	198.33	197.38	198.23	9313160.0
2016-03-10 13:30:00	SPY	ETF	198.23	198.38	198.02	198.07	5010634.0
2016-03-10 14:00:00	SPY	ETF	198.07	198.5592	197.74	198.4801	5572354.0
2016-03-10 14:30:00	SPY	ETF	198.49	199.32	198.34	198.95	8139288.0
2016-03-10 15:00:00	SPY	ETF	198.958	199.83	198.74	199.69	10866996.0
2016-03-10 15:30:00	SPY	ETF	199.69	199.73	199.05	199.54	13132653.0
2016-03-10 16:00:00	SPY	ETF	199.54	199.6	199.43	199.56	4608935.0
2016-03-10 16:30:00	SPY	ETF	199.56	199.78	199.52	199.6	1618468.0
2016-03-10 17:00:00	SPY	ETF	199.66	199.66	199.52	199.56	72030.0
2016-03-10 17:30:00	SPY	ETF	199.56	199.57	199.49	199.49	29035.0
2016-03-10 18:00:00	SPY	ETF	199.49	199.63	199.38	199.6	55896.0
2016-03-10 18:30:00	SPY	ETF	199.61	199.88	199.51	199.52	86282.0
2016-03-10 19:00:00	SPY	ETF	199.56	199.67	199.46	199.65	41225.0
2016-03-10 19:30:00	SPY	ETF	199.58	199.65	199.49	199.62	35114.0
2016-03-10 04:00:00	QQQ	ETF	105.0	105.0	105.0	105.0	100.0
2016-03-10 05:00:00	QQQ	ETF	104.96	104.96	104.96	104.96	339.0
2016-03-10 06:00:00	QQQ	ETF	104.95	105.12	104.95	105.09	1602.0
2016-03-10 06:30:00	QQQ	ETF	105.16	105.18	105.16	105.17	900.0
2016-03-10 07:00:00	QQQ	ETF	105.15	105.36	105.15	105.3	13620.0
2016-03-10 07:30:00	QQQ	ETF	105.31	106.15	105.3	106.07	93691.0
2016-03-10 08:00:00	QQQ	ETF	106.03	106.06	105.28	105.89	131222.0
2016-03-10 08:30:00	QQQ	ETF	105.88	106.03	105.51	105.65	201582.0
2016-03-10 09:00:00	QQQ	ETF	105.65	105.76	105.22	105.29	488384.0
2016-03-10 09:30:00	QQQ	ETF	105.31	105.82	104.99	105.78	5209818.0
2016-03-10 10:00:00	QQQ	ETF	105.7701	105.86	105.34	105.37	3140297.0
2016-03-10 10:30:00	QQQ	ETF	105.39	105.39	104.5399	104.58	3529249.0
2016-03-10 11:00:00	QQQ	ETF	104.59	104.7	104.01	104.18	3181465.0
2016-03-10 11:30:00	QQQ	ETF	104.2	104.49	103.98	104.33	2357263.0
2016-03-10 12:00:00	QQQ	ETF	104.33	104.57	104.06	104.21	1262513.0
2016-03-10 12:30:00	QQQ	ETF	104.21	104.2211	103.47	103.7	3298075.0
2016-03-10 13:00:00	QQQ	ETF	103.68	103.85	103.31	103.81	2108168.0
2016-03-10 13:30:00	QQQ	ETF	103.8	103.8835	103.6281	103.6395	1440265.0

> showing 50 of 13,267 rows — these rows as CSV

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