PREVIEW / etf_30min / 2016-01-08

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-08.parquet
  size:    411 KB
  rows:    13,775

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-01-08 04:00:00	SPY	ETF	196.24	196.45	196.08	196.08	56415.0
2016-01-08 04:30:00	SPY	ETF	196.06	196.25	195.87	196.25	33057.0
2016-01-08 05:00:00	SPY	ETF	196.2	196.29	195.89	195.93	13260.0
2016-01-08 05:30:00	SPY	ETF	195.98	195.98	195.38	195.6	43164.0
2016-01-08 06:00:00	SPY	ETF	195.6	195.64	195.11	195.34	105325.0
2016-01-08 06:30:00	SPY	ETF	195.23	195.33	194.33	194.75	152821.0
2016-01-08 07:00:00	SPY	ETF	194.73	195.35	194.67	195.3	299732.0
2016-01-08 07:30:00	SPY	ETF	195.32	195.59	195.16	195.43	381424.0
2016-01-08 08:00:00	SPY	ETF	195.42	195.69	194.74	195.56	791366.0
2016-01-08 08:30:00	SPY	ETF	195.66	196.98	195.62	195.9	5206267.0
2016-01-08 09:00:00	SPY	ETF	195.9	196.11	194.92	195.19	3036653.0
2016-01-08 09:30:00	SPY	ETF	195.19	195.85	194.73	195.4589	20434206.0
2016-01-08 10:00:00	SPY	ETF	195.46	195.46	194.1	194.65	16496471.0
2016-01-08 10:30:00	SPY	ETF	194.66	194.93	194.13	194.31	11012823.0
2016-01-08 11:00:00	SPY	ETF	194.31	194.64	193.48	193.62	10757591.0
2016-01-08 11:30:00	SPY	ETF	193.63	195.19	192.99	194.12	13574026.0
2016-01-08 12:00:00	SPY	ETF	194.125	194.85	193.95	194.79	8430432.0
2016-01-08 12:30:00	SPY	ETF	194.79	194.79	194.16	194.3	5133168.0
2016-01-08 13:00:00	SPY	ETF	194.3	194.55	193.57	193.83	6596687.0
2016-01-08 13:30:00	SPY	ETF	193.82	194.39	193.75	193.88	4970400.0
2016-01-08 14:00:00	SPY	ETF	193.89	194.25	193.28	193.32	10685831.0
2016-01-08 14:30:00	SPY	ETF	193.32	193.9	193.16	193.355	11141968.0
2016-01-08 15:00:00	SPY	ETF	193.35	193.635	192.87	192.94	15821267.0
2016-01-08 15:30:00	SPY	ETF	192.95	192.96	191.58	191.89	39233461.0
2016-01-08 16:00:00	SPY	ETF	191.92	192.35	191.55	191.86	15636635.0
2016-01-08 16:30:00	SPY	ETF	191.86	193.7245	191.65	191.85	6400570.0
2016-01-08 17:00:00	SPY	ETF	191.85	192.05	191.83	192.05	731128.0
2016-01-08 17:30:00	SPY	ETF	191.96	192.0	191.9	191.95	54632.0
2016-01-08 18:00:00	SPY	ETF	191.95	192.08	191.95	192.04	96436.0
2016-01-08 18:30:00	SPY	ETF	192.03	192.17	192.03	192.1	53176.0
2016-01-08 19:00:00	SPY	ETF	192.1	192.12	192.05	192.07	26758.0
2016-01-08 19:30:00	SPY	ETF	192.04	192.05	191.75	191.75	67616.0
2016-01-08 20:00:00	SPY	ETF	191.9654	191.9654	191.9654	191.9654	200000.0
2016-01-08 04:00:00	QQQ	ETF	106.13	106.25	106.11	106.11	9160.0
2016-01-08 04:30:00	QQQ	ETF	106.11	106.17	105.99	106.17	2885.0
2016-01-08 05:00:00	QQQ	ETF	106.11	106.11	106.11	106.11	100.0
2016-01-08 05:30:00	QQQ	ETF	105.91	105.91	105.7	105.82	500.0
2016-01-08 06:00:00	QQQ	ETF	105.72	105.79	105.71	105.71	10798.0
2016-01-08 06:30:00	QQQ	ETF	105.59	105.6	105.3	105.39	5075.0
2016-01-08 07:00:00	QQQ	ETF	105.42	105.66	105.42	105.63	28539.0
2016-01-08 07:30:00	QQQ	ETF	105.61	105.82	105.58	105.78	19389.0
2016-01-08 08:00:00	QQQ	ETF	105.65	105.92	105.45	105.91	217920.0
2016-01-08 08:30:00	QQQ	ETF	105.92	106.65	105.82	105.88	894261.0
2016-01-08 09:00:00	QQQ	ETF	105.91	106.02	104.8925	105.69	1473511.0
2016-01-08 09:30:00	QQQ	ETF	105.67	106.29	105.53	106.28	7944539.0
2016-01-08 10:00:00	QQQ	ETF	106.27	106.27	105.45	105.76	5272124.0
2016-01-08 10:30:00	QQQ	ETF	105.77	105.91	105.24	105.35	2765606.0
2016-01-08 11:00:00	QQQ	ETF	105.37	105.55	104.73	104.83	2979817.0
2016-01-08 11:30:00	QQQ	ETF	104.84	105.26	104.41	105.21	3671018.0
2016-01-08 12:00:00	QQQ	ETF	105.21	105.8	105.185	105.74	2843449.0

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

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