PREVIEW / stock_30min / 2014-10-23

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-23.parquet
  size:    1.6 MB
  rows:    83,733
  symbols: 3,559

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-10-23 04:00:00	AAPL	Stock	25.7825	25.9225	25.7825	25.8625	19476.0
2014-10-23 04:30:00	AAPL	Stock	25.875	25.895	25.875	25.895	1200.0
2014-10-23 05:00:00	AAPL	Stock	25.92	25.93	25.9025	25.9025	10000.0
2014-10-23 05:30:00	AAPL	Stock	25.8925	25.92	25.885	25.9025	14192.0
2014-10-23 06:00:00	AAPL	Stock	25.905	25.91	25.8925	25.9	23972.0
2014-10-23 06:30:00	AAPL	Stock	25.9	25.9125	25.885	25.8925	24632.0
2014-10-23 07:00:00	AAPL	Stock	25.87	25.9175	25.8625	25.9175	72844.0
2014-10-23 07:30:00	AAPL	Stock	25.9125	26.0	25.9125	25.995	403696.0
2014-10-23 08:00:00	AAPL	Stock	25.9875	26.0	25.675	25.965	794216.0
2014-10-23 08:30:00	AAPL	Stock	25.97	26.0125	25.9425	25.9975	874716.0
2014-10-23 09:00:00	AAPL	Stock	26.0	26.055	25.975	26.0	1648276.0
2014-10-23 09:30:00	AAPL	Stock	26.0025	26.0375	25.9075	26.01	27304436.0
2014-10-23 10:00:00	AAPL	Stock	26.01	26.1875	26.0	26.1737	34731416.0
2014-10-23 10:30:00	AAPL	Stock	26.1737	26.2628	26.165	26.2425	38359444.0
2014-10-23 11:00:00	AAPL	Stock	26.2425	26.25	26.15	26.2075	21073468.0
2014-10-23 11:30:00	AAPL	Stock	26.2075	26.24	26.1925	26.2312	14085080.0
2014-10-23 12:00:00	AAPL	Stock	26.23	26.25	26.205	26.2375	9933828.0
2014-10-23 12:30:00	AAPL	Stock	26.2375	26.245	26.2125	26.2292	8729992.0
2014-10-23 13:00:00	AAPL	Stock	26.229	26.2375	26.205	26.2175	8111924.0
2014-10-23 13:30:00	AAPL	Stock	26.2175	26.25	26.2162	26.2475	10109828.0
2014-10-23 14:00:00	AAPL	Stock	26.2462	26.2575	26.21	26.2412	12822900.0
2014-10-23 14:30:00	AAPL	Stock	26.2412	26.2425	26.145	26.195	13672484.0
2014-10-23 15:00:00	AAPL	Stock	26.1965	26.21	26.14	26.1775	19011924.0
2014-10-23 15:30:00	AAPL	Stock	26.175	26.2325	26.165	26.2075	38446088.0
2014-10-23 16:00:00	AAPL	Stock	26.2075	26.2375	26.1585	26.2275	794772.0
2014-10-23 16:30:00	AAPL	Stock	26.2275	26.24	26.2075	26.23	2391672.0
2014-10-23 17:00:00	AAPL	Stock	26.235	26.245	26.2075	26.23	356192.0
2014-10-23 17:30:00	AAPL	Stock	26.23	26.2425	26.2075	26.2375	755120.0
2014-10-23 18:00:00	AAPL	Stock	26.2325	26.24	26.2175	26.2175	37484.0
2014-10-23 18:30:00	AAPL	Stock	26.23	26.24	26.2075	26.225	136872.0
2014-10-23 19:00:00	AAPL	Stock	26.225	26.235	26.225	26.2325	48380.0
2014-10-23 19:30:00	AAPL	Stock	26.2325	26.2475	26.2275	26.2475	80956.0
2014-10-23 08:00:00	MSFT	Stock	44.73	44.74	44.73	44.74	1300.0
2014-10-23 08:30:00	MSFT	Stock	44.73	44.73	44.71	44.73	21142.0
2014-10-23 09:00:00	MSFT	Stock	44.73	44.73	44.61	44.61	18592.0
2014-10-23 09:30:00	MSFT	Stock	44.62	44.79	44.53	44.674	2747578.0
2014-10-23 10:00:00	MSFT	Stock	44.68	44.85	44.66	44.8	2591779.0
2014-10-23 10:30:00	MSFT	Stock	44.81	44.88	44.66	44.76	2400772.0
2014-10-23 11:00:00	MSFT	Stock	44.765	44.8	44.62	44.63	2136212.0
2014-10-23 11:30:00	MSFT	Stock	44.637	44.89	44.63	44.69	2306939.0
2014-10-23 12:00:00	MSFT	Stock	44.69	44.89	44.68	44.885	1689174.0
2014-10-23 12:30:00	MSFT	Stock	44.887	44.94	44.79	44.885	1359960.0
2014-10-23 13:00:00	MSFT	Stock	44.88	45.02	44.85	45.015	1200879.0
2014-10-23 13:30:00	MSFT	Stock	45.02	45.28	45.0	45.21	2777437.0
2014-10-23 14:00:00	MSFT	Stock	45.21	45.445	45.19	45.42	2885672.0
2014-10-23 14:30:00	MSFT	Stock	45.42	45.44	45.04	45.135	2810172.0
2014-10-23 15:00:00	MSFT	Stock	45.14	45.15	44.89	44.93	3091576.0
2014-10-23 15:30:00	MSFT	Stock	44.93	45.07	44.915	44.99	7096332.0
2014-10-23 16:00:00	MSFT	Stock	45.02	46.69	44.751	46.29	3875089.0
2014-10-23 16:30:00	MSFT	Stock	46.29	47.05	45.02	46.75	1093106.0

> showing 50 of 83,733 rows — these rows as CSV

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