PREVIEW / stock_30min / 2015-05-15

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-15.parquet
  size:    1.6 MB
  rows:    82,254
  symbols: 3,500

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-05-15 04:00:00	AAPL	Stock	32.22	32.37	32.22	32.3125	5688.0
2015-05-15 04:30:00	AAPL	Stock	32.3275	32.3325	32.31	32.31	2800.0
2015-05-15 05:00:00	AAPL	Stock	32.325	32.325	32.325	32.325	3736.0
2015-05-15 05:30:00	AAPL	Stock	32.325	32.3475	32.325	32.3475	8472.0
2015-05-15 06:00:00	AAPL	Stock	32.35	32.38	32.3325	32.38	110336.0
2015-05-15 06:30:00	AAPL	Stock	32.375	32.4	32.355	32.39	68420.0
2015-05-15 07:00:00	AAPL	Stock	32.365	32.3825	32.3225	32.3225	110584.0
2015-05-15 07:30:00	AAPL	Stock	32.34	32.345	32.2825	32.3125	111248.0
2015-05-15 08:00:00	AAPL	Stock	32.3125	32.3825	32.23	32.2325	562924.0
2015-05-15 08:30:00	AAPL	Stock	32.23	32.2375	32.1375	32.2175	593076.0
2015-05-15 09:00:00	AAPL	Stock	32.2125	32.2975	32.1575	32.2675	1178504.0
2015-05-15 09:30:00	AAPL	Stock	32.2975	32.3725	32.095	32.1525	34653224.0
2015-05-15 10:00:00	AAPL	Stock	32.1525	32.1575	32.055	32.105	16593712.0
2015-05-15 10:30:00	AAPL	Stock	32.105	32.1925	32.0525	32.1875	10732820.0
2015-05-15 11:00:00	AAPL	Stock	32.1862	32.2175	32.07	32.0712	9232520.0
2015-05-15 11:30:00	AAPL	Stock	32.0712	32.1375	32.065	32.135	5471880.0
2015-05-15 12:00:00	AAPL	Stock	32.1375	32.175	32.115	32.14	5080508.0
2015-05-15 12:30:00	AAPL	Stock	32.1412	32.188	32.1335	32.1385	5028660.0
2015-05-15 13:00:00	AAPL	Stock	32.1395	32.17	32.1088	32.1225	4369120.0
2015-05-15 13:30:00	AAPL	Stock	32.12	32.1375	32.105	32.11	4489364.0
2015-05-15 14:00:00	AAPL	Stock	32.11	32.16	32.075	32.15	6569388.0
2015-05-15 14:30:00	AAPL	Stock	32.15	32.2275	32.1425	32.215	8483184.0
2015-05-15 15:00:00	AAPL	Stock	32.2162	32.22	32.14	32.14	6759252.0
2015-05-15 15:30:00	AAPL	Stock	32.1425	32.1975	32.1275	32.19	14102676.0
2015-05-15 16:00:00	AAPL	Stock	32.1925	32.2075	32.15	32.1875	5443600.0
2015-05-15 16:30:00	AAPL	Stock	32.19	32.1975	32.1875	32.1975	53068.0
2015-05-15 17:00:00	AAPL	Stock	32.1925	32.2	32.1875	32.19	52900.0
2015-05-15 17:30:00	AAPL	Stock	32.1925	32.205	32.1775	32.1875	73496.0
2015-05-15 18:00:00	AAPL	Stock	32.1875	32.195	32.1825	32.1825	10740.0
2015-05-15 18:30:00	AAPL	Stock	32.19	32.1925	32.185	32.185	9680.0
2015-05-15 19:00:00	AAPL	Stock	32.1825	32.1875	32.1825	32.1875	14656.0
2015-05-15 19:30:00	AAPL	Stock	32.1875	32.2	32.1825	32.2	50060.0
2015-05-15 06:00:00	MSFT	Stock	48.99	48.99	48.99	48.99	103.0
2015-05-15 07:00:00	MSFT	Stock	48.95	48.95	48.95	48.95	900.0
2015-05-15 07:30:00	MSFT	Stock	48.83	48.83	48.83	48.83	100.0
2015-05-15 08:00:00	MSFT	Stock	48.85	48.9	48.79	48.81	5194.0
2015-05-15 08:30:00	MSFT	Stock	48.84	48.86	48.84	48.84	3295.0
2015-05-15 09:00:00	MSFT	Stock	48.84	48.95	48.81	48.94	137734.0
2015-05-15 09:30:00	MSFT	Stock	48.92	48.95	48.456	48.59	4768857.0
2015-05-15 10:00:00	MSFT	Stock	48.59	48.62	48.39	48.48	1796407.0
2015-05-15 10:30:00	MSFT	Stock	48.48	48.56	48.365	48.465	1427187.0
2015-05-15 11:00:00	MSFT	Stock	48.47	48.49	48.31	48.34	1375912.0
2015-05-15 11:30:00	MSFT	Stock	48.33	48.42	48.26	48.28	982301.0
2015-05-15 12:00:00	MSFT	Stock	48.29	48.3	48.18	48.21	1105619.0
2015-05-15 12:30:00	MSFT	Stock	48.205	48.25	48.17	48.18	776173.0
2015-05-15 13:00:00	MSFT	Stock	48.18	48.25	48.05	48.105	1332344.0
2015-05-15 13:30:00	MSFT	Stock	48.11	48.16	48.05	48.09	1040158.0
2015-05-15 14:00:00	MSFT	Stock	48.09	48.16	48.05	48.136	851713.0
2015-05-15 14:30:00	MSFT	Stock	48.135	48.27	48.13	48.24	1184062.0
2015-05-15 15:00:00	MSFT	Stock	48.25	48.25	48.1	48.116	1373068.0

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

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