PREVIEW / stock_30min / 2014-11-05

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-05.parquet
  size:    1.6 MB
  rows:    82,748
  symbols: 3,544

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-05 04:00:00	AAPL	Stock	27.225	27.2375	27.2125	27.225	7600.0
2014-11-05 04:30:00	AAPL	Stock	27.225	27.2625	27.225	27.2625	20456.0
2014-11-05 05:00:00	AAPL	Stock	27.2625	27.3375	27.2625	27.32	16124.0
2014-11-05 05:30:00	AAPL	Stock	27.29	27.29	27.29	27.29	400.0
2014-11-05 06:00:00	AAPL	Stock	27.295	27.32	27.265	27.265	11108.0
2014-11-05 06:30:00	AAPL	Stock	27.265	27.275	27.265	27.2725	23604.0
2014-11-05 07:00:00	AAPL	Stock	27.265	27.285	27.25	27.285	72392.0
2014-11-05 07:30:00	AAPL	Stock	27.2875	27.2925	27.28	27.2875	45480.0
2014-11-05 08:00:00	AAPL	Stock	27.2875	27.32	27.1	27.275	490384.0
2014-11-05 08:30:00	AAPL	Stock	27.2712	27.295	27.2625	27.29	157588.0
2014-11-05 09:00:00	AAPL	Stock	27.295	27.3	27.2675	27.27	348560.0
2014-11-05 09:30:00	AAPL	Stock	27.2825	27.325	27.0312	27.14	25704040.0
2014-11-05 10:00:00	AAPL	Stock	27.135	27.265	27.09	27.1975	13537208.0
2014-11-05 10:30:00	AAPL	Stock	27.1975	27.2525	27.1075	27.235	10333036.0
2014-11-05 11:00:00	AAPL	Stock	27.235	27.27	27.2125	27.2142	6764780.0
2014-11-05 11:30:00	AAPL	Stock	27.2138	27.2475	27.195	27.24	5789520.0
2014-11-05 12:00:00	AAPL	Stock	27.24	27.2525	27.215	27.2225	3936920.0
2014-11-05 12:30:00	AAPL	Stock	27.2225	27.235	27.2	27.2312	3689776.0
2014-11-05 13:00:00	AAPL	Stock	27.2325	27.235	27.175	27.185	3880036.0
2014-11-05 13:30:00	AAPL	Stock	27.1875	27.205	27.115	27.1525	7532808.0
2014-11-05 14:00:00	AAPL	Stock	27.1525	27.25	27.1462	27.2325	7049816.0
2014-11-05 14:30:00	AAPL	Stock	27.231	27.2375	27.16	27.2025	7229140.0
2014-11-05 15:00:00	AAPL	Stock	27.2025	27.23	27.1925	27.2025	7584404.0
2014-11-05 15:30:00	AAPL	Stock	27.2042	27.23	27.18	27.215	12570492.0
2014-11-05 16:00:00	AAPL	Stock	27.215	27.2325	27.15	27.2175	4555640.0
2014-11-05 16:30:00	AAPL	Stock	27.225	27.225	27.2025	27.215	1985460.0
2014-11-05 17:00:00	AAPL	Stock	27.205	27.2975	27.2025	27.2175	110192.0
2014-11-05 17:30:00	AAPL	Stock	27.22	27.225	27.21	27.225	76096.0
2014-11-05 18:00:00	AAPL	Stock	27.225	27.225	27.22	27.225	45324.0
2014-11-05 18:30:00	AAPL	Stock	27.225	27.23	27.22	27.22	28996.0
2014-11-05 19:00:00	AAPL	Stock	27.225	27.225	27.215	27.2175	15604.0
2014-11-05 19:30:00	AAPL	Stock	27.2175	27.23	27.2175	27.2225	88756.0
2014-11-05 07:30:00	MSFT	Stock	47.75	47.75	47.75	47.75	100.0
2014-11-05 08:00:00	MSFT	Stock	47.75	47.88	47.75	47.83	1311.0
2014-11-05 08:30:00	MSFT	Stock	47.84	47.9	47.781	47.88	3343.0
2014-11-05 09:00:00	MSFT	Stock	47.9	47.9	47.76	47.84	16189.0
2014-11-05 09:30:00	MSFT	Stock	47.8	47.85	47.26	47.56	2904823.0
2014-11-05 10:00:00	MSFT	Stock	47.56	47.66	47.4	47.49	1397642.0
2014-11-05 10:30:00	MSFT	Stock	47.49	47.55	47.33	47.52	1505463.0
2014-11-05 11:00:00	MSFT	Stock	47.53	47.66	47.51	47.595	1259854.0
2014-11-05 11:30:00	MSFT	Stock	47.59	47.63	47.47	47.61	875944.0
2014-11-05 12:00:00	MSFT	Stock	47.615	47.765	47.59	47.64	1038849.0
2014-11-05 12:30:00	MSFT	Stock	47.65	47.67	47.59	47.59	581164.0
2014-11-05 13:00:00	MSFT	Stock	47.59	47.66	47.5	47.51	530838.0
2014-11-05 13:30:00	MSFT	Stock	47.52	47.54	47.39	47.48	1009308.0
2014-11-05 14:00:00	MSFT	Stock	47.47	47.72	47.46	47.7	1009075.0
2014-11-05 14:30:00	MSFT	Stock	47.69	47.835	47.66	47.815	1415977.0
2014-11-05 15:00:00	MSFT	Stock	47.82	47.9	47.77	47.775	1713635.0
2014-11-05 15:30:00	MSFT	Stock	47.775	47.9	47.76	47.855	3868424.0
2014-11-05 16:00:00	MSFT	Stock	47.86	47.91	47.57	47.86	2439398.0

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

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