PREVIEW / stock_30min / 2015-07-08

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-08.parquet
  size:    1.6 MB
  rows:    82,855
  symbols: 3,489

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-07-08 04:00:00	AAPL	Stock	31.1175	31.1525	31.0025	31.045	51664.0
2015-07-08 04:30:00	AAPL	Stock	31.0775	31.0775	31.0	31.0525	57600.0
2015-07-08 05:00:00	AAPL	Stock	31.075	31.0975	31.075	31.075	22352.0
2015-07-08 05:30:00	AAPL	Stock	31.075	31.1	31.0525	31.1	9908.0
2015-07-08 06:00:00	AAPL	Stock	31.1225	31.1725	31.0875	31.1325	33900.0
2015-07-08 06:30:00	AAPL	Stock	31.14	31.175	31.14	31.175	9108.0
2015-07-08 07:00:00	AAPL	Stock	31.2125	31.3	31.2	31.2875	84836.0
2015-07-08 07:30:00	AAPL	Stock	31.25	31.2825	31.19	31.205	58544.0
2015-07-08 08:00:00	AAPL	Stock	31.2025	31.3125	31.0875	31.22	267948.0
2015-07-08 08:30:00	AAPL	Stock	31.225	31.2325	31.15	31.1575	355860.0
2015-07-08 09:00:00	AAPL	Stock	31.1625	31.1675	31.1025	31.125	964680.0
2015-07-08 09:30:00	AAPL	Stock	31.1325	31.16	30.84	30.9182	39374672.0
2015-07-08 10:00:00	AAPL	Stock	30.92	30.95	30.8025	30.8475	26494024.0
2015-07-08 10:30:00	AAPL	Stock	30.8472	31.07	30.7525	31.0348	28345288.0
2015-07-08 11:00:00	AAPL	Stock	31.034	31.0375	30.8675	30.8925	14462124.0
2015-07-08 11:30:00	AAPL	Stock	30.8912	30.94	30.7775	30.81	11707032.0
2015-07-08 12:00:00	AAPL	Stock	30.8125	30.8925	30.8025	30.8712	7965292.0
2015-07-08 12:30:00	AAPL	Stock	30.87	30.8875	30.8075	30.8775	8600436.0
2015-07-08 13:00:00	AAPL	Stock	30.8788	30.8825	30.8125	30.865	7743652.0
2015-07-08 13:30:00	AAPL	Stock	30.865	30.975	30.8225	30.97	7282528.0
2015-07-08 14:00:00	AAPL	Stock	30.9712	30.99	30.8475	30.8698	9803644.0
2015-07-08 14:30:00	AAPL	Stock	30.87	30.8702	30.7025	30.7475	18421028.0
2015-07-08 15:00:00	AAPL	Stock	30.7472	30.845	30.71	30.725	14586496.0
2015-07-08 15:30:00	AAPL	Stock	30.725	30.7825	30.635	30.6475	25492824.0
2015-07-08 16:00:00	AAPL	Stock	30.6475	30.862	30.625	30.6475	5153576.0
2015-07-08 16:30:00	AAPL	Stock	30.6475	30.655	30.64	30.645	100024.0
2015-07-08 17:00:00	AAPL	Stock	30.6458	30.66	30.64	30.655	192048.0
2015-07-08 17:30:00	AAPL	Stock	30.64	30.6525	30.635	30.635	57408.0
2015-07-08 18:00:00	AAPL	Stock	30.635	30.6475	30.6275	30.635	105052.0
2015-07-08 18:30:00	AAPL	Stock	30.64	30.6625	30.6375	30.6508	97676.0
2015-07-08 19:00:00	AAPL	Stock	30.66	30.67	30.6525	30.665	55172.0
2015-07-08 19:30:00	AAPL	Stock	30.665	30.6725	30.6475	30.6525	134112.0
2015-07-08 04:00:00	MSFT	Stock	43.95	43.95	43.65	43.75	4100.0
2015-07-08 07:00:00	MSFT	Stock	43.9	44.04	43.9	44.03	9301.0
2015-07-08 07:30:00	MSFT	Stock	44.02	44.02	43.89	43.99	6762.0
2015-07-08 08:00:00	MSFT	Stock	43.81	44.11	43.81	44.09	11180.0
2015-07-08 08:30:00	MSFT	Stock	44.09	44.1	44.02	44.1	9100.0
2015-07-08 09:00:00	MSFT	Stock	44.1	44.47	43.94	44.36	102002.0
2015-07-08 09:30:00	MSFT	Stock	44.44	44.83	44.03	44.27	6239808.0
2015-07-08 10:00:00	MSFT	Stock	44.265	44.51	44.14	44.5	3761403.0
2015-07-08 10:30:00	MSFT	Stock	44.505	44.9	44.34	44.77	4528543.0
2015-07-08 11:00:00	MSFT	Stock	44.77	44.78	44.37	44.45	3105178.0
2015-07-08 11:30:00	MSFT	Stock	44.45	44.55	44.22	44.31	1820330.0
2015-07-08 12:00:00	MSFT	Stock	44.31	44.49	44.28	44.4	1669989.0
2015-07-08 12:30:00	MSFT	Stock	44.4	44.6	44.33	44.561	1094931.0
2015-07-08 13:00:00	MSFT	Stock	44.565	44.68	44.47	44.58	1375749.0
2015-07-08 13:30:00	MSFT	Stock	44.58	44.67	44.44	44.61	1261188.0
2015-07-08 14:00:00	MSFT	Stock	44.61	44.63	44.41	44.446	1792341.0
2015-07-08 14:30:00	MSFT	Stock	44.44	44.455	44.11	44.15	2654308.0
2015-07-08 15:00:00	MSFT	Stock	44.16	44.39	44.13	44.17	2474435.0

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

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