PREVIEW / stock_30min / 2015-05-01

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-01.parquet
  size:    1.6 MB
  rows:    82,047
  symbols: 3,516

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-01 05:00:00	AAPL	Stock	31.3025	31.3025	31.2625	31.2625	1600.0
2015-05-01 05:30:00	AAPL	Stock	31.3875	31.3875	31.3875	31.3875	2400.0
2015-05-01 06:00:00	AAPL	Stock	31.3925	31.43	31.3875	31.4175	15116.0
2015-05-01 06:30:00	AAPL	Stock	31.425	31.425	31.305	31.3925	60684.0
2015-05-01 07:00:00	AAPL	Stock	31.3975	31.545	31.375	31.54	198324.0
2015-05-01 07:30:00	AAPL	Stock	31.5325	31.56	31.475	31.475	192132.0
2015-05-01 08:00:00	AAPL	Stock	31.4925	31.56	31.375	31.4725	612496.0
2015-05-01 08:30:00	AAPL	Stock	31.47	31.4775	31.445	31.4575	255520.0
2015-05-01 09:00:00	AAPL	Stock	31.4575	31.56	31.45	31.5225	812216.0
2015-05-01 09:30:00	AAPL	Stock	31.5225	31.6325	31.325	31.5375	35027500.0
2015-05-01 10:00:00	AAPL	Stock	31.535	31.755	31.5	31.66	23932036.0
2015-05-01 10:30:00	AAPL	Stock	31.66	31.7175	31.5575	31.58	11935420.0
2015-05-01 11:00:00	AAPL	Stock	31.585	31.6725	31.5475	31.62	9211148.0
2015-05-01 11:30:00	AAPL	Stock	31.62	31.6475	31.495	31.5438	10298232.0
2015-05-01 12:00:00	AAPL	Stock	31.545	31.5598	31.44	31.525	8703776.0
2015-05-01 12:30:00	AAPL	Stock	31.5225	31.6125	31.515	31.605	6589628.0
2015-05-01 13:00:00	AAPL	Stock	31.605	31.6425	31.555	31.6325	6168068.0
2015-05-01 13:30:00	AAPL	Stock	31.6325	31.8325	31.6325	31.7962	14158060.0
2015-05-01 14:00:00	AAPL	Stock	31.795	31.9275	31.78	31.9225	11196056.0
2015-05-01 14:30:00	AAPL	Stock	31.9225	31.9875	31.8875	31.98	13774940.0
2015-05-01 15:00:00	AAPL	Stock	31.9825	32.045	31.9575	32.0075	15487048.0
2015-05-01 15:30:00	AAPL	Stock	32.005	32.5325	31.9862	32.2375	35825384.0
2015-05-01 16:00:00	AAPL	Stock	32.2375	32.255	31.5052	32.24	8448392.0
2015-05-01 16:30:00	AAPL	Stock	32.235	32.2525	32.2275	32.2525	320980.0
2015-05-01 17:00:00	AAPL	Stock	32.2525	32.255	32.24	32.24	148204.0
2015-05-01 17:30:00	AAPL	Stock	32.2425	32.255	32.24	32.245	83196.0
2015-05-01 18:00:00	AAPL	Stock	32.2425	32.255	32.2425	32.255	124580.0
2015-05-01 18:30:00	AAPL	Stock	32.255	32.2625	32.25	32.2575	99596.0
2015-05-01 19:00:00	AAPL	Stock	32.2575	32.2675	32.2502	32.2625	53984.0
2015-05-01 19:30:00	AAPL	Stock	32.27	32.2725	32.2525	32.2625	81620.0
2015-05-01 06:00:00	MSFT	Stock	48.79	48.8	48.79	48.8	2050.0
2015-05-01 06:30:00	MSFT	Stock	48.8	48.8	48.8	48.8	1550.0
2015-05-01 07:00:00	MSFT	Stock	48.79	48.83	48.74	48.74	2042.0
2015-05-01 07:30:00	MSFT	Stock	48.77	48.85	48.76	48.76	2600.0
2015-05-01 08:00:00	MSFT	Stock	48.79	48.85	48.72	48.72	10518.0
2015-05-01 08:30:00	MSFT	Stock	48.74	48.75	48.72	48.73	7420.0
2015-05-01 09:00:00	MSFT	Stock	48.73	48.88	48.54	48.69	114466.0
2015-05-01 09:30:00	MSFT	Stock	48.65	48.84	48.51	48.66	4639870.0
2015-05-01 10:00:00	MSFT	Stock	48.66	48.875	48.57	48.8	3463695.0
2015-05-01 10:30:00	MSFT	Stock	48.81	48.84	48.65	48.665	2227270.0
2015-05-01 11:00:00	MSFT	Stock	48.67	48.85	48.66	48.85	2600414.0
2015-05-01 11:30:00	MSFT	Stock	48.841	48.87	48.625	48.685	1989398.0
2015-05-01 12:00:00	MSFT	Stock	48.69	48.74	48.56	48.68	1342526.0
2015-05-01 12:30:00	MSFT	Stock	48.68	48.81	48.61	48.67	1813967.0
2015-05-01 13:00:00	MSFT	Stock	48.665	48.7	48.54	48.57	1220389.0
2015-05-01 13:30:00	MSFT	Stock	48.57	48.685	48.47	48.61	2333925.0
2015-05-01 14:00:00	MSFT	Stock	48.605	48.69	48.54	48.68	1532402.0
2015-05-01 14:30:00	MSFT	Stock	48.68	48.69	48.52	48.55	1440509.0
2015-05-01 15:00:00	MSFT	Stock	48.55	48.58	48.4	48.42	2127795.0
2015-05-01 15:30:00	MSFT	Stock	48.42	48.66	48.41	48.65	5661934.0

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

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