PREVIEW / stock_30min / 2014-08-22

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-22.parquet
  size:    1.5 MB
  rows:    79,731
  symbols: 3,554

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-08-22 04:00:00	AAPL	Stock	25.1525	25.1525	25.1525	25.1525	400.0
2014-08-22 05:00:00	AAPL	Stock	25.165	25.17	25.025	25.105	35704.0
2014-08-22 05:30:00	AAPL	Stock	25.0875	25.0975	25.05	25.0975	12560.0
2014-08-22 06:00:00	AAPL	Stock	25.0925	25.0925	25.0375	25.0375	11328.0
2014-08-22 06:30:00	AAPL	Stock	25.0575	25.0575	25.025	25.05	41276.0
2014-08-22 07:00:00	AAPL	Stock	25.0375	25.09	25.0375	25.06	109164.0
2014-08-22 07:30:00	AAPL	Stock	25.065	25.07	25.0625	25.0625	94948.0
2014-08-22 08:00:00	AAPL	Stock	25.0675	25.145	25.035	25.105	421656.0
2014-08-22 08:30:00	AAPL	Stock	25.1025	25.105	25.0625	25.075	232704.0
2014-08-22 09:00:00	AAPL	Stock	25.075	25.3162	25.0625	25.07	393532.0
2014-08-22 09:30:00	AAPL	Stock	25.07	25.2225	25.0475	25.22	23291016.0
2014-08-22 10:00:00	AAPL	Stock	25.2175	25.275	25.1525	25.275	18687932.0
2014-08-22 10:30:00	AAPL	Stock	25.2725	25.31	25.2175	25.2425	16056584.0
2014-08-22 11:00:00	AAPL	Stock	25.2425	25.35	25.2125	25.3475	14192584.0
2014-08-22 11:30:00	AAPL	Stock	25.3475	25.3518	25.2725	25.3375	10693644.0
2014-08-22 12:00:00	AAPL	Stock	25.3382	25.35	25.2925	25.35	6180112.0
2014-08-22 12:30:00	AAPL	Stock	25.35	25.3675	25.3275	25.3288	5974824.0
2014-08-22 13:00:00	AAPL	Stock	25.3275	25.335	25.245	25.2675	10132900.0
2014-08-22 13:30:00	AAPL	Stock	25.27	25.3125	25.2685	25.2888	8059044.0
2014-08-22 14:00:00	AAPL	Stock	25.2888	25.2913	25.2475	25.2775	8164288.0
2014-08-22 14:30:00	AAPL	Stock	25.278	25.31	25.2625	25.3	7648568.0
2014-08-22 15:00:00	AAPL	Stock	25.3	25.3375	25.2975	25.33	8349096.0
2014-08-22 15:30:00	AAPL	Stock	25.3307	25.35	25.28	25.33	19707348.0
2014-08-22 16:00:00	AAPL	Stock	25.3275	25.3725	25.0725	25.3675	6340032.0
2014-08-22 16:30:00	AAPL	Stock	25.37	25.3775	25.3275	25.37	646120.0
2014-08-22 17:00:00	AAPL	Stock	25.37	25.37	25.3275	25.3525	416904.0
2014-08-22 17:30:00	AAPL	Stock	25.3525	25.36	25.34	25.35	222424.0
2014-08-22 18:00:00	AAPL	Stock	25.35	25.3675	25.3425	25.36	116612.0
2014-08-22 18:30:00	AAPL	Stock	25.36	25.365	25.3275	25.3625	82764.0
2014-08-22 19:00:00	AAPL	Stock	25.3625	25.365	25.3525	25.355	92688.0
2014-08-22 19:30:00	AAPL	Stock	25.3525	25.365	25.3525	25.3625	76184.0
2014-08-22 08:00:00	MSFT	Stock	45.07	45.23	45.07	45.2	1200.0
2014-08-22 08:30:00	MSFT	Stock	45.15	45.2	45.15	45.2	1258.0
2014-08-22 09:00:00	MSFT	Stock	45.17	45.37	45.16	45.35	25233.0
2014-08-22 09:30:00	MSFT	Stock	45.35	45.47	45.225	45.31	3683826.0
2014-08-22 10:00:00	MSFT	Stock	45.31	45.35	45.08	45.15	1900130.0
2014-08-22 10:30:00	MSFT	Stock	45.145	45.235	45.1	45.15	1506883.0
2014-08-22 11:00:00	MSFT	Stock	45.15	45.39	45.115	45.38	1336036.0
2014-08-22 11:30:00	MSFT	Stock	45.37	45.39	45.22	45.265	968035.0
2014-08-22 12:00:00	MSFT	Stock	45.27	45.31	45.21	45.275	607956.0
2014-08-22 12:30:00	MSFT	Stock	45.28	45.305	45.215	45.22	479388.0
2014-08-22 13:00:00	MSFT	Stock	45.22	45.22	45.13	45.175	648350.0
2014-08-22 13:30:00	MSFT	Stock	45.18	45.23	45.17	45.22	558802.0
2014-08-22 14:00:00	MSFT	Stock	45.225	45.23	45.14	45.18	480764.0
2014-08-22 14:30:00	MSFT	Stock	45.18	45.21	45.11	45.16	545622.0
2014-08-22 15:00:00	MSFT	Stock	45.16	45.27	45.15	45.175	693367.0
2014-08-22 15:30:00	MSFT	Stock	45.17	45.175	45.07	45.16	1835318.0
2014-08-22 16:00:00	MSFT	Stock	45.16	45.229	45.147	45.17	2022799.0
2014-08-22 16:30:00	MSFT	Stock	45.16	45.16	45.16	45.16	36167.0
2014-08-22 17:00:00	MSFT	Stock	45.16	45.16	45.15	45.15	1300.0

> showing 50 of 79,731 rows — these rows as CSV

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