PREVIEW / etf_30min / 2014-11-03

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-03.parquet
  size:    369 KB
  rows:    12,443

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
2014-11-03 04:00:00	SPY	ETF	201.4	201.48	201.35	201.42	13650.0
2014-11-03 04:30:00	SPY	ETF	201.38	201.48	201.3	201.45	6750.0
2014-11-03 05:00:00	SPY	ETF	201.5	201.55	201.43	201.5	5171.0
2014-11-03 05:30:00	SPY	ETF	201.5	201.56	201.49	201.5	6543.0
2014-11-03 06:00:00	SPY	ETF	201.48	201.55	201.46	201.54	4718.0
2014-11-03 06:30:00	SPY	ETF	201.52	201.52	201.41	201.41	52229.0
2014-11-03 07:00:00	SPY	ETF	201.41	201.48	201.31	201.31	80960.0
2014-11-03 07:30:00	SPY	ETF	201.33	201.49	201.28	201.48	141678.0
2014-11-03 08:00:00	SPY	ETF	201.67	201.67	201.33	201.54	397162.0
2014-11-03 08:30:00	SPY	ETF	201.54	201.78	201.51	201.7	513888.0
2014-11-03 09:00:00	SPY	ETF	201.7	202.16	201.7	201.93	1657110.0
2014-11-03 09:30:00	SPY	ETF	201.92	202.04	201.64	201.89	14151370.0
2014-11-03 10:00:00	SPY	ETF	201.89	202.21	201.35	201.47	12760619.0
2014-11-03 10:30:00	SPY	ETF	201.47	201.93	201.43	201.89	5454276.0
2014-11-03 11:00:00	SPY	ETF	201.89	202.03	201.72	201.79	4901903.0
2014-11-03 11:30:00	SPY	ETF	201.78	202.04	201.67	201.98	4713915.0
2014-11-03 12:00:00	SPY	ETF	201.98	202.1	201.9	202.05	3543670.0
2014-11-03 12:30:00	SPY	ETF	202.049	202.45	201.99	202.37	3665797.0
2014-11-03 13:00:00	SPY	ETF	202.36	202.39	202.21	202.34	3061015.0
2014-11-03 13:30:00	SPY	ETF	202.34	202.425	202.18	202.18	3692630.0
2014-11-03 14:00:00	SPY	ETF	202.19	202.23	201.95	201.96	4547559.0
2014-11-03 14:30:00	SPY	ETF	201.97	201.97	201.55	201.64	6642316.0
2014-11-03 15:00:00	SPY	ETF	201.64	201.86	201.305	201.345	5877023.0
2014-11-03 15:30:00	SPY	ETF	201.345	201.77	201.34	201.75	11257611.0
2014-11-03 16:00:00	SPY	ETF	201.74	201.85	201.61	201.61	4669919.0
2014-11-03 16:30:00	SPY	ETF	201.61	201.77	201.53	201.6	1292402.0
2014-11-03 17:00:00	SPY	ETF	201.62	201.7	201.62	201.7	55377.0
2014-11-03 17:30:00	SPY	ETF	201.69	201.69	201.6	201.61	32948.0
2014-11-03 18:00:00	SPY	ETF	201.61	201.63	201.47	201.6	69807.0
2014-11-03 18:30:00	SPY	ETF	201.62	201.62	201.49	201.49	26440.0
2014-11-03 19:00:00	SPY	ETF	201.51	201.51	201.3	201.32	96164.0
2014-11-03 19:30:00	SPY	ETF	201.32	201.35	201.25	201.29	38378.0
2014-11-03 04:00:00	QQQ	ETF	101.33	101.33	101.23	101.23	2800.0
2014-11-03 04:30:00	QQQ	ETF	101.25	101.28	101.24	101.25	3940.0
2014-11-03 05:30:00	QQQ	ETF	101.32	101.32	101.32	101.32	10000.0
2014-11-03 06:00:00	QQQ	ETF	101.32	101.36	101.32	101.36	1300.0
2014-11-03 06:30:00	QQQ	ETF	101.3	101.33	101.29	101.33	2600.0
2014-11-03 07:00:00	QQQ	ETF	101.33	101.36	101.28	101.28	14568.0
2014-11-03 07:30:00	QQQ	ETF	101.27	101.35	101.25	101.35	15568.0
2014-11-03 08:00:00	QQQ	ETF	101.36	101.38	101.31	101.36	48218.0
2014-11-03 08:30:00	QQQ	ETF	101.37	101.5	101.37	101.46	90564.0
2014-11-03 09:00:00	QQQ	ETF	101.49	101.65	101.49	101.54	324802.0
2014-11-03 09:30:00	QQQ	ETF	101.53	101.895	101.43	101.8365	3722553.0
2014-11-03 10:00:00	QQQ	ETF	101.84	101.9701	101.52	101.5772	4160551.0
2014-11-03 10:30:00	QQQ	ETF	101.58	101.85	101.56	101.815	1909205.0
2014-11-03 11:00:00	QQQ	ETF	101.81	101.87	101.705	101.71	1557520.0
2014-11-03 11:30:00	QQQ	ETF	101.72	101.85	101.67	101.78	1295665.0
2014-11-03 12:00:00	QQQ	ETF	101.79	101.815	101.7	101.74	1160490.0
2014-11-03 12:30:00	QQQ	ETF	101.74	101.91	101.73	101.83	1034252.0
2014-11-03 13:00:00	QQQ	ETF	101.835	101.8463	101.75	101.8135	795721.0

> showing 50 of 12,443 rows — these rows as CSV

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