PREVIEW / etf_30min / 2015-11-13

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-13.parquet
  size:    387 KB
  rows:    13,150

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
2015-11-13 04:00:00	SPY	ETF	205.04	205.26	204.93	204.98	3873.0
2015-11-13 04:30:00	SPY	ETF	204.9	204.9	204.76	204.88	1735.0
2015-11-13 05:00:00	SPY	ETF	204.93	204.93	204.83	204.83	1900.0
2015-11-13 05:30:00	SPY	ETF	204.79	204.88	204.78	204.88	6800.0
2015-11-13 06:00:00	SPY	ETF	204.68	204.68	204.36	204.38	15014.0
2015-11-13 06:30:00	SPY	ETF	204.34	204.43	204.11	204.41	69641.0
2015-11-13 07:00:00	SPY	ETF	204.41	204.53	204.36	204.43	61619.0
2015-11-13 07:30:00	SPY	ETF	204.43	204.58	204.4	204.4	237718.0
2015-11-13 08:00:00	SPY	ETF	204.4	205.27	204.25	204.44	574551.0
2015-11-13 08:30:00	SPY	ETF	204.44	204.7	204.08	204.49	963325.0
2015-11-13 09:00:00	SPY	ETF	204.48	204.59	204.26	204.36	585606.0
2015-11-13 09:30:00	SPY	ETF	204.35	204.67	203.88	204.06	14187432.0
2015-11-13 10:00:00	SPY	ETF	204.041	204.24	203.01	203.23	14666671.0
2015-11-13 10:30:00	SPY	ETF	203.22	203.61	203.02	203.61	11455945.0
2015-11-13 11:00:00	SPY	ETF	203.61	203.63	202.875	203.45	8621565.0
2015-11-13 11:30:00	SPY	ETF	203.44	203.86	203.19	203.85	9031255.0
2015-11-13 12:00:00	SPY	ETF	203.85	204.41	203.76	203.9	10320679.0
2015-11-13 12:30:00	SPY	ETF	203.9	203.99	203.48	203.72	5136568.0
2015-11-13 13:00:00	SPY	ETF	203.72	203.81	203.32	203.48	7817344.0
2015-11-13 13:30:00	SPY	ETF	203.47	203.63	203.11	203.255	6101861.0
2015-11-13 14:00:00	SPY	ETF	203.26	203.43	203.03	203.15	4001243.0
2015-11-13 14:30:00	SPY	ETF	203.145	203.26	202.51	202.67	12861942.0
2015-11-13 15:00:00	SPY	ETF	202.67	203.05	202.435	202.55	11119964.0
2015-11-13 15:30:00	SPY	ETF	202.55	203.01	202.47	202.54	22806737.0
2015-11-13 16:00:00	SPY	ETF	202.56	202.65	202.34	202.64	7358023.0
2015-11-13 16:30:00	SPY	ETF	202.63	202.73	201.92	201.97	1098338.0
2015-11-13 17:00:00	SPY	ETF	202.0	202.04	201.71	201.76	1581034.0
2015-11-13 17:30:00	SPY	ETF	201.76	201.8	201.2	201.34	494529.0
2015-11-13 18:00:00	SPY	ETF	201.38	201.44	200.85	200.94	171097.0
2015-11-13 18:30:00	SPY	ETF	200.95	201.0	200.83	201.0	150805.0
2015-11-13 19:00:00	SPY	ETF	201.05	201.15	200.8	200.9	66383.0
2015-11-13 19:30:00	SPY	ETF	200.9	200.95	200.76	200.9	56139.0
2015-11-13 04:00:00	QQQ	ETF	111.92	111.97	111.92	111.97	205.0
2015-11-13 04:30:00	QQQ	ETF	111.74	111.79	111.74	111.79	210.0
2015-11-13 05:00:00	QQQ	ETF	111.91	111.91	111.86	111.87	15100.0
2015-11-13 05:30:00	QQQ	ETF	111.8	111.8	111.8	111.8	2500.0
2015-11-13 06:00:00	QQQ	ETF	111.67	111.7	111.55	111.55	50390.0
2015-11-13 06:30:00	QQQ	ETF	111.53	111.58	111.45	111.58	52780.0
2015-11-13 07:00:00	QQQ	ETF	111.58	111.66	111.58	111.6	13900.0
2015-11-13 07:30:00	QQQ	ETF	111.6	111.65	111.56	111.6	88443.0
2015-11-13 08:00:00	QQQ	ETF	111.55	111.65	111.49	111.6	18539.0
2015-11-13 08:30:00	QQQ	ETF	111.61	111.77	111.45	111.66	155230.0
2015-11-13 09:00:00	QQQ	ETF	111.66	111.76	111.5	111.55	379009.0
2015-11-13 09:30:00	QQQ	ETF	111.57	111.69	111.17	111.33	4208988.0
2015-11-13 10:00:00	QQQ	ETF	111.32	111.3901	110.62	110.84	4284043.0
2015-11-13 10:30:00	QQQ	ETF	110.83	110.895	110.57	110.88	3999674.0
2015-11-13 11:00:00	QQQ	ETF	110.88	110.8895	110.38	110.75	3211833.0
2015-11-13 11:30:00	QQQ	ETF	110.75	110.85	110.48	110.84	2235780.0
2015-11-13 12:00:00	QQQ	ETF	110.85	111.18	110.8	110.91	2605378.0
2015-11-13 12:30:00	QQQ	ETF	110.92	110.965	110.63	110.77	1033526.0

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

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