PREVIEW / stock_30min / 2015-06-25

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-25.parquet
  size:    1.6 MB
  rows:    82,611
  symbols: 3,492

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-06-25 04:00:00	AAPL	Stock	32.105	32.17	32.105	32.17	15200.0
2015-06-25 04:30:00	AAPL	Stock	32.185	32.2125	32.185	32.185	5032.0
2015-06-25 05:00:00	AAPL	Stock	32.1675	32.1675	32.1675	32.1675	7800.0
2015-06-25 05:30:00	AAPL	Stock	32.1675	32.1675	32.135	32.1675	11796.0
2015-06-25 06:00:00	AAPL	Stock	32.155	32.2125	32.155	32.2125	15772.0
2015-06-25 06:30:00	AAPL	Stock	32.1875	32.205	32.1875	32.1975	13280.0
2015-06-25 07:00:00	AAPL	Stock	32.2	32.2125	32.15	32.195	66680.0
2015-06-25 07:30:00	AAPL	Stock	32.195	32.2025	32.1675	32.1875	55464.0
2015-06-25 08:00:00	AAPL	Stock	32.1925	32.225	31.95	32.2	386596.0
2015-06-25 08:30:00	AAPL	Stock	32.2	32.2025	32.1525	32.195	184268.0
2015-06-25 09:00:00	AAPL	Stock	32.2	32.24	32.1825	32.2225	409364.0
2015-06-25 09:30:00	AAPL	Stock	32.2125	32.3	32.115	32.185	21583528.0
2015-06-25 10:00:00	AAPL	Stock	32.1865	32.2525	32.105	32.2125	11977528.0
2015-06-25 10:30:00	AAPL	Stock	32.215	32.215	32.1325	32.185	5413376.0
2015-06-25 11:00:00	AAPL	Stock	32.185	32.235	32.1582	32.165	5986064.0
2015-06-25 11:30:00	AAPL	Stock	32.165	32.2075	32.16	32.1825	4274160.0
2015-06-25 12:00:00	AAPL	Stock	32.1825	32.185	32.1125	32.1175	4626896.0
2015-06-25 12:30:00	AAPL	Stock	32.117	32.1375	32.0375	32.0575	6185796.0
2015-06-25 13:00:00	AAPL	Stock	32.0625	32.0725	32.02	32.0538	5423928.0
2015-06-25 13:30:00	AAPL	Stock	32.0525	32.055	31.985	32.02	5167860.0
2015-06-25 14:00:00	AAPL	Stock	32.0198	32.0198	31.89	31.9175	9890600.0
2015-06-25 14:30:00	AAPL	Stock	31.9175	31.9625	31.8925	31.9175	6192996.0
2015-06-25 15:00:00	AAPL	Stock	31.915	31.9925	31.9025	31.939	6274644.0
2015-06-25 15:30:00	AAPL	Stock	31.9375	31.96	31.875	31.8775	12894396.0
2015-06-25 16:00:00	AAPL	Stock	31.8812	32.1995	31.875	31.885	13463404.0
2015-06-25 16:30:00	AAPL	Stock	31.8992	31.8992	31.875	31.8925	87272.0
2015-06-25 17:00:00	AAPL	Stock	31.88	31.8925	31.875	31.8925	68576.0
2015-06-25 17:30:00	AAPL	Stock	31.89	31.89	31.8825	31.885	12960.0
2015-06-25 18:00:00	AAPL	Stock	31.8825	31.8925	31.875	31.89	24836.0
2015-06-25 18:30:00	AAPL	Stock	31.8992	31.912	31.8825	31.8825	38916.0
2015-06-25 19:00:00	AAPL	Stock	31.89	31.89	31.885	31.89	5920.0
2015-06-25 19:30:00	AAPL	Stock	31.8892	31.8992	31.8625	31.875	71436.0
2015-06-25 06:00:00	MSFT	Stock	45.95	45.95	45.92	45.92	5299.0
2015-06-25 06:30:00	MSFT	Stock	46.09	46.09	46.09	46.09	100.0
2015-06-25 07:00:00	MSFT	Stock	46.02	46.02	45.92	45.92	1501.0
2015-06-25 07:30:00	MSFT	Stock	45.92	45.92	45.92	45.92	2182.0
2015-06-25 08:00:00	MSFT	Stock	45.93	45.93	45.85	45.85	2048.0
2015-06-25 08:30:00	MSFT	Stock	45.85	45.85	45.8	45.84	8104.0
2015-06-25 09:00:00	MSFT	Stock	45.89	46.05	45.86	46.02	18766.0
2015-06-25 09:30:00	MSFT	Stock	46.02	46.06	45.69	45.97	2879130.0
2015-06-25 10:00:00	MSFT	Stock	45.97	45.99	45.8	45.8	1625756.0
2015-06-25 10:30:00	MSFT	Stock	45.8	45.91	45.7	45.91	1174444.0
2015-06-25 11:00:00	MSFT	Stock	45.905	45.97	45.82	45.83	957250.0
2015-06-25 11:30:00	MSFT	Stock	45.84	45.87	45.74	45.78	737893.0
2015-06-25 12:00:00	MSFT	Stock	45.78	45.84	45.65	45.665	733525.0
2015-06-25 12:30:00	MSFT	Stock	45.66	45.72	45.63	45.714	640575.0
2015-06-25 13:00:00	MSFT	Stock	45.71	45.75	45.65	45.715	532594.0
2015-06-25 13:30:00	MSFT	Stock	45.72	45.77	45.66	45.745	775913.0
2015-06-25 14:00:00	MSFT	Stock	45.75	45.755	45.5	45.524	1237914.0
2015-06-25 14:30:00	MSFT	Stock	45.53	45.67	45.51	45.67	1248706.0

> showing 50 of 82,611 rows — these rows as CSV

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