PREVIEW / stock_30min / 2017-05-10

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-10.parquet
  size:    1.6 MB
  rows:    81,925
  symbols: 3,025

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-05-10 04:00:00	AAPL	Stock	38.395	38.395	38.395	38.395	400.0
2017-05-10 05:00:00	AAPL	Stock	38.3175	38.3175	38.275	38.275	22052.0
2017-05-10 05:30:00	AAPL	Stock	38.3175	38.3175	38.3175	38.3175	400.0
2017-05-10 06:00:00	AAPL	Stock	38.33	38.33	38.325	38.325	9920.0
2017-05-10 06:30:00	AAPL	Stock	38.325	38.3575	38.305	38.3175	20568.0
2017-05-10 07:00:00	AAPL	Stock	38.325	38.3375	38.3	38.3125	113456.0
2017-05-10 07:30:00	AAPL	Stock	38.3125	38.3125	38.2625	38.305	108928.0
2017-05-10 08:00:00	AAPL	Stock	38.3175	38.4975	38.1875	38.2475	687052.0
2017-05-10 08:30:00	AAPL	Stock	38.2475	38.4975	38.225	38.2625	216964.0
2017-05-10 09:00:00	AAPL	Stock	38.2625	38.4125	38.25	38.4025	299684.0
2017-05-10 09:30:00	AAPL	Stock	38.4075	38.485	38.225	38.255	14405472.0
2017-05-10 10:00:00	AAPL	Stock	38.2525	38.255	38.04	38.05	12839480.0
2017-05-10 10:30:00	AAPL	Stock	38.0488	38.2862	38.0275	38.222	9911536.0
2017-05-10 11:00:00	AAPL	Stock	38.22	38.36	38.2125	38.33	6179868.0
2017-05-10 11:30:00	AAPL	Stock	38.33	38.3325	38.2412	38.256	3704068.0
2017-05-10 12:00:00	AAPL	Stock	38.257	38.325	38.2302	38.305	3505916.0
2017-05-10 12:30:00	AAPL	Stock	38.3043	38.3562	38.3025	38.345	3871036.0
2017-05-10 13:00:00	AAPL	Stock	38.3438	38.37	38.2975	38.31	4156324.0
2017-05-10 13:30:00	AAPL	Stock	38.3088	38.3675	38.2925	38.355	3216652.0
2017-05-10 14:00:00	AAPL	Stock	38.3545	38.41	38.3425	38.365	4220020.0
2017-05-10 14:30:00	AAPL	Stock	38.3653	38.3775	38.32	38.3375	3002680.0
2017-05-10 15:00:00	AAPL	Stock	38.3352	38.3575	38.2325	38.2325	4883148.0
2017-05-10 15:30:00	AAPL	Stock	38.2325	38.335	38.21	38.315	10620132.0
2017-05-10 16:00:00	AAPL	Stock	38.3075	38.3275	38.3	38.3275	5992940.0
2017-05-10 16:30:00	AAPL	Stock	38.3225	38.3375	38.315	38.3275	38812.0
2017-05-10 17:00:00	AAPL	Stock	38.32	38.3275	38.315	38.315	36544.0
2017-05-10 17:30:00	AAPL	Stock	38.3125	38.3375	38.3125	38.325	27332.0
2017-05-10 18:00:00	AAPL	Stock	38.325	38.34	38.3225	38.34	20980.0
2017-05-10 18:30:00	AAPL	Stock	38.3425	38.3425	38.325	38.3325	16112.0
2017-05-10 19:00:00	AAPL	Stock	38.3425	38.345	38.3325	38.3425	14460.0
2017-05-10 19:30:00	AAPL	Stock	38.3425	38.35	38.34	38.35	20732.0
2017-05-10 05:00:00	MSFT	Stock	69.05	69.05	69.05	69.05	100.0
2017-05-10 08:30:00	MSFT	Stock	69.02	69.02	69.02	69.02	175.0
2017-05-10 09:00:00	MSFT	Stock	68.96	69.02	68.96	69.02	450.0
2017-05-10 09:30:00	MSFT	Stock	68.99	69.15	68.93	69.09	1229491.0
2017-05-10 10:00:00	MSFT	Stock	69.08	69.15	68.95	69.06	1359802.0
2017-05-10 10:30:00	MSFT	Stock	69.06	69.06	68.92	68.98	1032185.0
2017-05-10 11:00:00	MSFT	Stock	68.99	69.12	68.96	69.06	678579.0
2017-05-10 11:30:00	MSFT	Stock	69.07	69.125	68.99	69.07	594643.0
2017-05-10 12:00:00	MSFT	Stock	69.08	69.13	69.03	69.11	444678.0
2017-05-10 12:30:00	MSFT	Stock	69.1	69.14	69.05	69.12	895806.0
2017-05-10 13:00:00	MSFT	Stock	69.112	69.3	69.08	69.29	1367440.0
2017-05-10 13:30:00	MSFT	Stock	69.29	69.337	69.265	69.29	716278.0
2017-05-10 14:00:00	MSFT	Stock	69.29	69.315	69.22	69.271	1134500.0
2017-05-10 14:30:00	MSFT	Stock	69.27	69.41	69.23	69.41	903952.0
2017-05-10 15:00:00	MSFT	Stock	69.405	69.56	69.39	69.45	1655657.0
2017-05-10 15:30:00	MSFT	Stock	69.455	69.46	69.26	69.31	3241791.0
2017-05-10 16:00:00	MSFT	Stock	69.32	69.34	69.25	69.28	1281817.0
2017-05-10 16:30:00	MSFT	Stock	69.26	69.28	69.26	69.28	5200.0
2017-05-10 17:00:00	MSFT	Stock	69.26	69.26	69.26	69.26	600.0

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

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