PREVIEW / stock_30min / 2016-03-01

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-01.parquet
  size:    1.6 MB
  rows:    82,349
  symbols: 3,368

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
2016-03-01 04:00:00	AAPL	Stock	24.16	24.385	24.16	24.385	10904.0
2016-03-01 05:00:00	AAPL	Stock	24.41	24.41	24.41	24.41	400.0
2016-03-01 05:30:00	AAPL	Stock	24.4325	24.4325	24.4325	24.4325	400.0
2016-03-01 06:00:00	AAPL	Stock	24.4125	24.4125	24.4125	24.4125	400.0
2016-03-01 06:30:00	AAPL	Stock	24.42	24.435	24.42	24.42	6136.0
2016-03-01 07:00:00	AAPL	Stock	24.445	24.4625	24.4	24.4075	69012.0
2016-03-01 07:30:00	AAPL	Stock	24.4	24.425	24.37	24.38	29792.0
2016-03-01 08:00:00	AAPL	Stock	24.385	24.4425	24.325	24.3375	210156.0
2016-03-01 08:30:00	AAPL	Stock	24.3425	24.39	24.33	24.385	204680.0
2016-03-01 09:00:00	AAPL	Stock	24.4	24.4375	24.1725	24.425	162168.0
2016-03-01 09:30:00	AAPL	Stock	24.4225	24.5125	24.355	24.49	18465204.0
2016-03-01 10:00:00	AAPL	Stock	24.49	24.67	24.485	24.645	17050324.0
2016-03-01 10:30:00	AAPL	Stock	24.6425	24.7013	24.6275	24.6767	10420444.0
2016-03-01 11:00:00	AAPL	Stock	24.6775	24.8425	24.6762	24.8225	12296732.0
2016-03-01 11:30:00	AAPL	Stock	24.8205	25.0	24.82	24.9775	18127056.0
2016-03-01 12:00:00	AAPL	Stock	24.9762	25.075	24.935	24.976	17059316.0
2016-03-01 12:30:00	AAPL	Stock	24.9765	25.0725	24.9425	25.065	11659068.0
2016-03-01 13:00:00	AAPL	Stock	25.0655	25.14	24.9845	25.1362	13704400.0
2016-03-01 13:30:00	AAPL	Stock	25.135	25.1725	25.0175	25.0675	11840224.0
2016-03-01 14:00:00	AAPL	Stock	25.0662	25.1625	25.0625	25.1225	9862672.0
2016-03-01 14:30:00	AAPL	Stock	25.1225	25.1775	25.08	25.171	8216604.0
2016-03-01 15:00:00	AAPL	Stock	25.1725	25.1925	25.105	25.1085	9871544.0
2016-03-01 15:30:00	AAPL	Stock	25.1075	25.1375	25.0588	25.1325	19539300.0
2016-03-01 16:00:00	AAPL	Stock	25.1325	25.1725	24.1725	25.1525	7560512.0
2016-03-01 16:30:00	AAPL	Stock	25.1525	25.1625	25.1525	25.1575	141812.0
2016-03-01 17:00:00	AAPL	Stock	25.1575	25.1725	25.1525	25.1575	66604.0
2016-03-01 17:30:00	AAPL	Stock	25.1575	25.16	25.1525	25.1525	32512.0
2016-03-01 18:00:00	AAPL	Stock	25.1525	25.155	25.1525	25.1525	34000.0
2016-03-01 18:30:00	AAPL	Stock	25.1525	25.1675	25.15	25.1575	42488.0
2016-03-01 19:00:00	AAPL	Stock	25.1575	25.1575	25.1275	25.1375	58324.0
2016-03-01 19:30:00	AAPL	Stock	25.1375	25.1625	25.1275	25.1625	51144.0
2016-03-01 05:00:00	MSFT	Stock	51.25	51.25	51.25	51.25	575.0
2016-03-01 06:00:00	MSFT	Stock	51.29	51.3	51.29	51.3	1883.0
2016-03-01 06:30:00	MSFT	Stock	51.2	51.2	51.2	51.2	300.0
2016-03-01 07:00:00	MSFT	Stock	51.22	51.24	51.17	51.17	3300.0
2016-03-01 07:30:00	MSFT	Stock	51.18	51.18	51.17	51.18	5822.0
2016-03-01 08:00:00	MSFT	Stock	51.1	51.3	50.88	51.11	8139.0
2016-03-01 08:30:00	MSFT	Stock	51.13	51.13	51.09	51.1	3500.0
2016-03-01 09:00:00	MSFT	Stock	51.13	51.17	50.88	50.93	45045.0
2016-03-01 09:30:00	MSFT	Stock	50.94	51.2	50.92	51.17	2916139.0
2016-03-01 10:00:00	MSFT	Stock	51.17	51.5	51.13	51.46	2799349.0
2016-03-01 10:30:00	MSFT	Stock	51.46	51.61	51.41	51.495	2604337.0
2016-03-01 11:00:00	MSFT	Stock	51.5	51.8	51.38	51.721	2399054.0
2016-03-01 11:30:00	MSFT	Stock	51.73	52.17	51.72	52.078	2904285.0
2016-03-01 12:00:00	MSFT	Stock	52.075	52.271	52.02	52.14	1561467.0
2016-03-01 12:30:00	MSFT	Stock	52.15	52.36	52.04	52.36	1243684.0
2016-03-01 13:00:00	MSFT	Stock	52.35	52.43	52.199	52.42	1117378.0
2016-03-01 13:30:00	MSFT	Stock	52.425	52.58	52.42	52.475	1672633.0
2016-03-01 14:00:00	MSFT	Stock	52.48	52.52	52.19	52.25	1457432.0
2016-03-01 14:30:00	MSFT	Stock	52.26	52.39	52.17	52.385	1274075.0

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

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