PREVIEW / etf_30min / 2016-03-11

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-11.parquet
  size:    397 KB
  rows:    13,497

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-11 04:00:00	SPY	ETF	201.1	201.56	201.1	201.15	44037.0
2016-03-11 04:30:00	SPY	ETF	201.15	201.39	201.05	201.29	36251.0
2016-03-11 05:00:00	SPY	ETF	201.31	201.72	201.31	201.65	49618.0
2016-03-11 05:30:00	SPY	ETF	201.56	201.63	201.47	201.49	104434.0
2016-03-11 06:00:00	SPY	ETF	201.66	201.7	201.49	201.67	105792.0
2016-03-11 06:30:00	SPY	ETF	201.71	201.72	201.31	201.36	77830.0
2016-03-11 07:00:00	SPY	ETF	201.33	201.4	201.27	201.33	170938.0
2016-03-11 07:30:00	SPY	ETF	201.37	201.42	201.19	201.3	431624.0
2016-03-11 08:00:00	SPY	ETF	201.3	201.5	200.615	201.21	576858.0
2016-03-11 08:30:00	SPY	ETF	201.21	201.29	201.05	201.21	582401.0
2016-03-11 09:00:00	SPY	ETF	201.23	201.88	201.19	201.24	933099.0
2016-03-11 09:30:00	SPY	ETF	201.26	201.67	201.12	201.48	13939194.0
2016-03-11 10:00:00	SPY	ETF	201.48	201.61	201.14	201.47	11201415.0
2016-03-11 10:30:00	SPY	ETF	201.475	202.039	201.4727	201.78	12854637.0
2016-03-11 11:00:00	SPY	ETF	201.79	202.28	201.73	202.215	9148837.0
2016-03-11 11:30:00	SPY	ETF	202.21	202.33	202.105	202.24	5546691.0
2016-03-11 12:00:00	SPY	ETF	202.24	202.431	202.13	202.36	5417624.0
2016-03-11 12:30:00	SPY	ETF	202.35	202.48	202.15	202.17	4443003.0
2016-03-11 13:00:00	SPY	ETF	202.1625	202.19	201.84	202.07	4272399.0
2016-03-11 13:30:00	SPY	ETF	202.07	202.3	201.82	202.23	4864646.0
2016-03-11 14:00:00	SPY	ETF	202.23	202.32	202.08	202.16	4182300.0
2016-03-11 14:30:00	SPY	ETF	202.17	202.3	201.94	202.11	5561861.0
2016-03-11 15:00:00	SPY	ETF	202.11	202.675	202.07	202.59	10153025.0
2016-03-11 15:30:00	SPY	ETF	202.59	202.81	202.43	202.73	22767383.0
2016-03-11 16:00:00	SPY	ETF	202.73	202.7725	199.4636	202.66	16704885.0
2016-03-11 16:30:00	SPY	ETF	202.66	202.76	202.59	202.68	646887.0
2016-03-11 17:00:00	SPY	ETF	202.65	202.68	202.61	202.67	1297711.0
2016-03-11 17:30:00	SPY	ETF	202.66	202.73	202.66	202.68	33335.0
2016-03-11 18:00:00	SPY	ETF	202.68	202.69	202.64	202.68	31785.0
2016-03-11 18:30:00	SPY	ETF	202.66	202.73	202.66	202.73	14242.0
2016-03-11 19:00:00	SPY	ETF	202.72	202.72	202.68	202.68	6062.0
2016-03-11 19:30:00	SPY	ETF	202.7	202.7	202.65	202.68	17815.0
2016-03-11 04:00:00	QQQ	ETF	105.73	105.9	105.73	105.82	1616.0
2016-03-11 04:30:00	QQQ	ETF	105.72	105.85	105.72	105.85	5200.0
2016-03-11 05:00:00	QQQ	ETF	105.86	105.97	105.86	105.97	1100.0
2016-03-11 05:30:00	QQQ	ETF	105.94	105.97	105.93	105.95	403.0
2016-03-11 06:00:00	QQQ	ETF	105.92	105.98	105.92	105.97	1767.0
2016-03-11 06:30:00	QQQ	ETF	105.98	106.0	105.79	105.79	3450.0
2016-03-11 07:00:00	QQQ	ETF	105.78	105.82	105.75	105.82	16476.0
2016-03-11 07:30:00	QQQ	ETF	105.82	105.84	105.73	105.78	18785.0
2016-03-11 08:00:00	QQQ	ETF	105.78	105.89	105.7	105.7	223274.0
2016-03-11 08:30:00	QQQ	ETF	105.71	105.76	105.67	105.75	94910.0
2016-03-11 09:00:00	QQQ	ETF	105.77	105.85	105.71	105.8	172007.0
2016-03-11 09:30:00	QQQ	ETF	105.8	105.98	105.55	105.84	4243198.0
2016-03-11 10:00:00	QQQ	ETF	105.84	105.919	105.46	105.81	2203454.0
2016-03-11 10:30:00	QQQ	ETF	105.81	106.13	105.81	105.98	2804340.0
2016-03-11 11:00:00	QQQ	ETF	105.98	106.06	105.95	106.0	1882820.0
2016-03-11 11:30:00	QQQ	ETF	106.0	106.06	105.96	106.01	1263408.0
2016-03-11 12:00:00	QQQ	ETF	106.01	106.09	105.951	106.05	1056816.0
2016-03-11 12:30:00	QQQ	ETF	106.05	106.12	105.9635	105.99	858904.0

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

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