PREVIEW / stock_30min / 2017-06-14

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-14.parquet
  size:    1.6 MB
  rows:    81,836
  symbols: 3,029

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-06-14 05:00:00	AAPL	Stock	36.745	36.8	36.7425	36.8	4784.0
2017-06-14 05:30:00	AAPL	Stock	36.8	36.8175	36.7975	36.8	12240.0
2017-06-14 06:00:00	AAPL	Stock	36.755	36.8425	36.7525	36.8425	11524.0
2017-06-14 06:30:00	AAPL	Stock	36.8025	36.8125	36.8025	36.8125	4352.0
2017-06-14 07:00:00	AAPL	Stock	36.8125	36.8675	36.805	36.84	44944.0
2017-06-14 07:30:00	AAPL	Stock	36.84	36.84	36.8125	36.8175	36224.0
2017-06-14 08:00:00	AAPL	Stock	36.835	36.8675	36.7375	36.7375	111620.0
2017-06-14 08:30:00	AAPL	Stock	36.745	36.8225	36.7125	36.7725	150492.0
2017-06-14 09:00:00	AAPL	Stock	36.7725	36.875	36.75	36.8725	221808.0
2017-06-14 09:30:00	AAPL	Stock	36.87	36.875	36.5275	36.66	11531616.0
2017-06-14 10:00:00	AAPL	Stock	36.66	36.66	36.4375	36.4425	7864220.0
2017-06-14 10:30:00	AAPL	Stock	36.4438	36.51	36.38	36.4325	7443096.0
2017-06-14 11:00:00	AAPL	Stock	36.435	36.44	36.345	36.39	5974164.0
2017-06-14 11:30:00	AAPL	Stock	36.388	36.545	36.3775	36.525	4375012.0
2017-06-14 12:00:00	AAPL	Stock	36.5255	36.5275	36.3525	36.4025	4082132.0
2017-06-14 12:30:00	AAPL	Stock	36.405	36.4595	36.37	36.3775	3193912.0
2017-06-14 13:00:00	AAPL	Stock	36.3805	36.465	36.375	36.4375	2904660.0
2017-06-14 13:30:00	AAPL	Stock	36.4375	36.46	36.3725	36.3975	3222992.0
2017-06-14 14:00:00	AAPL	Stock	36.395	36.5375	36.2925	36.3925	8812732.0
2017-06-14 14:30:00	AAPL	Stock	36.393	36.395	36.1525	36.19	12841840.0
2017-06-14 15:00:00	AAPL	Stock	36.1875	36.2312	35.96	36.1025	15368980.0
2017-06-14 15:30:00	AAPL	Stock	36.1025	36.33	36.0425	36.29	16940140.0
2017-06-14 16:00:00	AAPL	Stock	36.29	36.33	36.2575	36.275	7189660.0
2017-06-14 16:30:00	AAPL	Stock	36.29	36.29	36.27	36.29	134252.0
2017-06-14 17:00:00	AAPL	Stock	36.275	36.29	36.275	36.275	7120.0
2017-06-14 17:30:00	AAPL	Stock	36.2675	36.2725	36.2625	36.265	36596.0
2017-06-14 18:00:00	AAPL	Stock	36.2625	36.275	36.255	36.2725	20980.0
2017-06-14 18:30:00	AAPL	Stock	36.2525	36.2525	36.1325	36.18	70268.0
2017-06-14 19:00:00	AAPL	Stock	36.15	36.155	36.1275	36.1375	44572.0
2017-06-14 19:30:00	AAPL	Stock	36.14	36.1625	36.135	36.15	39140.0
2017-06-14 04:00:00	MSFT	Stock	70.7	70.7	70.7	70.7	100.0
2017-06-14 07:00:00	MSFT	Stock	70.84	70.84	70.84	70.84	200.0
2017-06-14 07:30:00	MSFT	Stock	70.87	70.87	70.81	70.81	2500.0
2017-06-14 08:00:00	MSFT	Stock	70.7	70.8	70.7	70.8	6901.0
2017-06-14 08:30:00	MSFT	Stock	70.77	70.99	70.65	70.95	19377.0
2017-06-14 09:00:00	MSFT	Stock	70.95	71.0	70.95	70.99	1828.0
2017-06-14 09:30:00	MSFT	Stock	70.91	71.1	70.74	70.9	1814473.0
2017-06-14 10:00:00	MSFT	Stock	70.91	70.995	70.55	70.56	1274103.0
2017-06-14 10:30:00	MSFT	Stock	70.56	70.88	70.49	70.79	1158069.0
2017-06-14 11:00:00	MSFT	Stock	70.79	70.97	70.7	70.96	966937.0
2017-06-14 11:30:00	MSFT	Stock	70.96	71.08	70.869	71.08	1146617.0
2017-06-14 12:00:00	MSFT	Stock	71.075	71.075	70.82	70.935	1010909.0
2017-06-14 12:30:00	MSFT	Stock	70.935	71.02	70.825	70.87	991308.0
2017-06-14 13:00:00	MSFT	Stock	70.87	71.04	70.87	70.956	1094842.0
2017-06-14 13:30:00	MSFT	Stock	70.95	71.01	70.75	70.82	656092.0
2017-06-14 14:00:00	MSFT	Stock	70.82	71.05	70.59	70.744	1225240.0
2017-06-14 14:30:00	MSFT	Stock	70.74	70.746	69.8	70.01	2746456.0
2017-06-14 15:00:00	MSFT	Stock	70.01	70.14	69.43	69.815	3643246.0
2017-06-14 15:30:00	MSFT	Stock	69.81	70.32	69.7	70.27	4058346.0
2017-06-14 16:00:00	MSFT	Stock	70.27	70.33	70.26	70.27	2096964.0

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

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