PREVIEW / stock_30min / 2017-02-01

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-01.parquet
  size:    1.6 MB
  rows:    82,635
  symbols: 3,108

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-02-01 04:00:00	AAPL	Stock	31.125	31.2375	31.125	31.2375	23244.0
2017-02-01 04:30:00	AAPL	Stock	31.2225	31.235	31.185	31.185	22220.0
2017-02-01 05:00:00	AAPL	Stock	31.175	31.2275	31.1425	31.2275	32028.0
2017-02-01 05:30:00	AAPL	Stock	31.235	31.275	31.2325	31.27	69828.0
2017-02-01 06:00:00	AAPL	Stock	31.25	31.2975	31.25	31.295	73048.0
2017-02-01 06:30:00	AAPL	Stock	31.3	31.3775	31.3	31.325	222192.0
2017-02-01 07:00:00	AAPL	Stock	31.35	31.525	31.3325	31.5175	687888.0
2017-02-01 07:30:00	AAPL	Stock	31.5125	31.715	31.475	31.6825	1724824.0
2017-02-01 08:00:00	AAPL	Stock	31.6875	31.7975	31.2	31.7875	3776368.0
2017-02-01 08:30:00	AAPL	Stock	31.7925	31.9175	31.75	31.8375	5331444.0
2017-02-01 09:00:00	AAPL	Stock	31.845	31.9125	31.72	31.76	10258260.0
2017-02-01 09:30:00	AAPL	Stock	31.7575	32.0725	31.7525	32.03	99216696.0
2017-02-01 10:00:00	AAPL	Stock	32.0325	32.075	31.915	32.02	34526828.0
2017-02-01 10:30:00	AAPL	Stock	32.02	32.1125	32.0	32.042	29826780.0
2017-02-01 11:00:00	AAPL	Stock	32.0412	32.12	31.9625	32.01	22781264.0
2017-02-01 11:30:00	AAPL	Stock	32.0112	32.0825	32.01	32.0825	14638176.0
2017-02-01 12:00:00	AAPL	Stock	32.0825	32.205	32.0775	32.2	18137856.0
2017-02-01 12:30:00	AAPL	Stock	32.2	32.375	32.1975	32.3038	23168532.0
2017-02-01 13:00:00	AAPL	Stock	32.3038	32.3575	32.2675	32.3175	13018772.0
2017-02-01 13:30:00	AAPL	Stock	32.315	32.3325	32.235	32.26	13003996.0
2017-02-01 14:00:00	AAPL	Stock	32.2575	32.5	32.25	32.5	27437376.0
2017-02-01 14:30:00	AAPL	Stock	32.495	32.53	32.4125	32.4975	22452220.0
2017-02-01 15:00:00	AAPL	Stock	32.4975	32.6225	32.465	32.4775	24545848.0
2017-02-01 15:30:00	AAPL	Stock	32.4775	32.4838	32.1875	32.1875	34160332.0
2017-02-01 16:00:00	AAPL	Stock	32.2	32.295	32.1875	32.2275	14586252.0
2017-02-01 16:30:00	AAPL	Stock	32.2025	32.2425	32.2025	32.225	123148.0
2017-02-01 17:00:00	AAPL	Stock	32.235	32.25	32.1875	32.225	526208.0
2017-02-01 17:30:00	AAPL	Stock	32.2275	32.2275	32.2	32.205	99764.0
2017-02-01 18:00:00	AAPL	Stock	32.2175	32.2875	32.205	32.2625	129740.0
2017-02-01 18:30:00	AAPL	Stock	32.2525	32.275	32.225	32.2325	85892.0
2017-02-01 19:00:00	AAPL	Stock	32.25	32.2625	32.2275	32.25	73520.0
2017-02-01 19:30:00	AAPL	Stock	32.25	32.26	32.2	32.2025	43864.0
2017-02-01 04:30:00	MSFT	Stock	64.6	64.94	64.6	64.94	2514.0
2017-02-01 05:00:00	MSFT	Stock	64.8	64.8	64.8	64.8	540.0
2017-02-01 06:30:00	MSFT	Stock	64.8	64.8	64.77	64.8	1900.0
2017-02-01 07:00:00	MSFT	Stock	64.75	64.8	64.73	64.75	6740.0
2017-02-01 07:30:00	MSFT	Stock	64.76	64.77	64.73	64.77	15500.0
2017-02-01 08:00:00	MSFT	Stock	64.75	64.85	64.73	64.82	25178.0
2017-02-01 08:30:00	MSFT	Stock	64.75	64.79	64.6	64.7	41930.0
2017-02-01 09:00:00	MSFT	Stock	64.7	64.75	64.3	64.36	86920.0
2017-02-01 09:30:00	MSFT	Stock	64.36	64.62	64.12	64.24	4647197.0
2017-02-01 10:00:00	MSFT	Stock	64.245	64.37	64.0	64.05	2269154.0
2017-02-01 10:30:00	MSFT	Stock	64.06	64.07	63.845	63.86	3121405.0
2017-02-01 11:00:00	MSFT	Stock	63.87	63.89	63.69	63.696	2246796.0
2017-02-01 11:30:00	MSFT	Stock	63.7	63.78	63.65	63.715	1565622.0
2017-02-01 12:00:00	MSFT	Stock	63.72	63.755	63.6	63.67	1671906.0
2017-02-01 12:30:00	MSFT	Stock	63.67	63.86	63.66	63.805	2124532.0
2017-02-01 13:00:00	MSFT	Stock	63.81	63.87	63.705	63.715	1212450.0
2017-02-01 13:30:00	MSFT	Stock	63.715	63.74	63.47	63.55	2162133.0
2017-02-01 14:00:00	MSFT	Stock	63.54	63.77	63.5	63.675	2410961.0

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

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