PREVIEW / stock_30min / 2017-01-10

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-10.parquet
  size:    1.6 MB
  rows:    81,943
  symbols: 3,120

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
2017-01-10 06:00:00	AAPL	Stock	29.7875	29.7875	29.7875	29.7875	1312.0
2017-01-10 07:00:00	AAPL	Stock	29.75	29.7925	29.75	29.77	14008.0
2017-01-10 07:30:00	AAPL	Stock	29.775	29.775	29.775	29.775	4400.0
2017-01-10 08:00:00	AAPL	Stock	29.7825	29.7825	29.675	29.755	71088.0
2017-01-10 08:30:00	AAPL	Stock	29.735	29.755	29.715	29.7375	118780.0
2017-01-10 09:00:00	AAPL	Stock	29.73	29.7375	29.6925	29.7	183748.0
2017-01-10 09:30:00	AAPL	Stock	29.6925	29.7425	29.575	29.695	16706088.0
2017-01-10 10:00:00	AAPL	Stock	29.695	29.7375	29.65	29.66	9195564.0
2017-01-10 10:30:00	AAPL	Stock	29.6588	29.725	29.6275	29.685	5548996.0
2017-01-10 11:00:00	AAPL	Stock	29.685	29.815	29.685	29.8075	7705388.0
2017-01-10 11:30:00	AAPL	Stock	29.81	29.845	29.785	29.7875	5176952.0
2017-01-10 12:00:00	AAPL	Stock	29.7865	29.83	29.7865	29.815	3381908.0
2017-01-10 12:30:00	AAPL	Stock	29.815	29.8225	29.77	29.78	2842924.0
2017-01-10 13:00:00	AAPL	Stock	29.7815	29.795	29.75	29.765	3255056.0
2017-01-10 13:30:00	AAPL	Stock	29.7662	29.7975	29.7	29.71	4539872.0
2017-01-10 14:00:00	AAPL	Stock	29.7078	29.782	29.6925	29.7625	4027620.0
2017-01-10 14:30:00	AAPL	Stock	29.761	29.7975	29.7488	29.77	3777816.0
2017-01-10 15:00:00	AAPL	Stock	29.77	29.7725	29.73	29.75	2813516.0
2017-01-10 15:30:00	AAPL	Stock	29.7512	29.805	29.751	29.7775	8700708.0
2017-01-10 16:00:00	AAPL	Stock	29.7775	29.785	29.7525	29.775	11753988.0
2017-01-10 16:30:00	AAPL	Stock	29.7725	29.7875	29.77	29.77	38444.0
2017-01-10 17:00:00	AAPL	Stock	29.7675	29.7675	29.7675	29.7675	9380.0
2017-01-10 17:30:00	AAPL	Stock	29.7675	29.7775	29.7675	29.7775	3840.0
2017-01-10 18:30:00	AAPL	Stock	29.765	29.765	29.7625	29.7625	8800.0
2017-01-10 19:00:00	AAPL	Stock	29.7625	29.7875	29.7525	29.7875	21340.0
2017-01-10 19:30:00	AAPL	Stock	29.785	29.7875	29.785	29.7875	1600.0
2017-01-10 06:30:00	MSFT	Stock	62.7	62.7	62.7	62.7	194.0
2017-01-10 07:30:00	MSFT	Stock	62.7	62.7	62.7	62.7	5585.0
2017-01-10 08:00:00	MSFT	Stock	62.71	62.71	62.71	62.71	1000.0
2017-01-10 08:30:00	MSFT	Stock	62.7	62.74	62.65	62.65	11311.0
2017-01-10 09:00:00	MSFT	Stock	62.65	62.65	62.6	62.64	4099.0
2017-01-10 09:30:00	MSFT	Stock	62.73	62.79	62.28	62.48	2229083.0
2017-01-10 10:00:00	MSFT	Stock	62.485	62.64	62.39	62.64	1920197.0
2017-01-10 10:30:00	MSFT	Stock	62.645	62.8	62.64	62.674	961668.0
2017-01-10 11:00:00	MSFT	Stock	62.68	62.9	62.66	62.88	933563.0
2017-01-10 11:30:00	MSFT	Stock	62.875	63.07	62.86	62.97	1075466.0
2017-01-10 12:00:00	MSFT	Stock	62.98	62.987	62.85	62.95	803859.0
2017-01-10 12:30:00	MSFT	Stock	62.945	62.96	62.79	62.79	562812.0
2017-01-10 13:00:00	MSFT	Stock	62.79	62.83	62.74	62.75	501673.0
2017-01-10 13:30:00	MSFT	Stock	62.75	62.82	62.615	62.63	760125.0
2017-01-10 14:00:00	MSFT	Stock	62.63	62.77	62.57	62.69	1083677.0
2017-01-10 14:30:00	MSFT	Stock	62.685	62.745	62.64	62.665	615174.0
2017-01-10 15:00:00	MSFT	Stock	62.68	62.72	62.635	62.635	602445.0
2017-01-10 15:30:00	MSFT	Stock	62.63	62.74	62.59	62.62	1673910.0
2017-01-10 16:00:00	MSFT	Stock	62.62	62.7	62.62	62.69	2656930.0
2017-01-10 16:30:00	MSFT	Stock	62.62	62.62	62.54	62.54	40118.0
2017-01-10 17:30:00	MSFT	Stock	62.72	62.72	62.68	62.72	4884.0
2017-01-10 18:00:00	MSFT	Stock	62.66	62.66	62.66	62.66	170.0
2017-01-10 18:30:00	MSFT	Stock	62.71	62.71	62.71	62.71	200.0
2017-01-10 19:00:00	MSFT	Stock	62.66	62.7	62.66	62.7	300.0

> showing 50 of 81,943 rows — these rows as CSV

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