PREVIEW / stock_30min / 2018-04-10

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-10.parquet
  size:    1.7 MB
  rows:    83,808
  symbols: 2,868

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
2018-04-10 04:00:00	AAPL	Stock	43.0575	43.2625	43.0575	43.1825	17108.0
2018-04-10 04:30:00	AAPL	Stock	43.19	43.19	43.175	43.1875	5600.0
2018-04-10 05:00:00	AAPL	Stock	43.15	43.3	43.15	43.225	29400.0
2018-04-10 05:30:00	AAPL	Stock	43.265	43.265	43.175	43.175	13200.0
2018-04-10 06:00:00	AAPL	Stock	43.18	43.2125	43.18	43.2125	1228.0
2018-04-10 06:30:00	AAPL	Stock	43.2	43.2625	43.2	43.2375	4560.0
2018-04-10 07:00:00	AAPL	Stock	43.2	43.25	43.165	43.2125	146416.0
2018-04-10 07:30:00	AAPL	Stock	43.2	43.235	43.1825	43.225	73144.0
2018-04-10 08:00:00	AAPL	Stock	43.25	43.25	43.125	43.1625	225120.0
2018-04-10 08:30:00	AAPL	Stock	43.1425	43.2175	43.1	43.165	205992.0
2018-04-10 09:00:00	AAPL	Stock	43.165	43.275	43.165	43.2725	362824.0
2018-04-10 09:30:00	AAPL	Stock	43.25	43.3775	42.98	43.0975	16528660.0
2018-04-10 10:00:00	AAPL	Stock	43.0978	43.308	43.0788	43.28	8156580.0
2018-04-10 10:30:00	AAPL	Stock	43.2802	43.3625	43.2525	43.2975	6609252.0
2018-04-10 11:00:00	AAPL	Stock	43.3	43.3655	43.1875	43.2725	6182012.0
2018-04-10 11:30:00	AAPL	Stock	43.27	43.375	43.1275	43.295	6541652.0
2018-04-10 12:00:00	AAPL	Stock	43.2938	43.3152	42.8825	43.0	7057896.0
2018-04-10 12:30:00	AAPL	Stock	43.0	43.19	42.9675	43.145	4498464.0
2018-04-10 13:00:00	AAPL	Stock	43.145	43.235	43.0925	43.1975	3956376.0
2018-04-10 13:30:00	AAPL	Stock	43.1975	43.2988	43.1025	43.2948	5278152.0
2018-04-10 14:00:00	AAPL	Stock	43.295	43.3575	43.2225	43.2575	5276668.0
2018-04-10 14:30:00	AAPL	Stock	43.26	43.35	43.125	43.3475	6063416.0
2018-04-10 15:00:00	AAPL	Stock	43.3462	43.5	43.284	43.4688	7777176.0
2018-04-10 15:30:00	AAPL	Stock	43.4675	43.47	43.2175	43.3125	10128256.0
2018-04-10 16:00:00	AAPL	Stock	43.3125	43.3475	43.24	43.3	8305668.0
2018-04-10 16:30:00	AAPL	Stock	43.275	43.3125	43.275	43.3125	539200.0
2018-04-10 17:00:00	AAPL	Stock	43.275	43.3177	43.275	43.3177	86088.0
2018-04-10 17:30:00	AAPL	Stock	43.2825	43.3125	43.2725	43.28	35952.0
2018-04-10 18:00:00	AAPL	Stock	43.3	43.3	43.275	43.3	5096.0
2018-04-10 18:30:00	AAPL	Stock	43.3075	43.3125	43.275	43.31	47936.0
2018-04-10 19:00:00	AAPL	Stock	43.2875	43.2875	43.25	43.2525	20848.0
2018-04-10 19:30:00	AAPL	Stock	43.3	43.31	43.225	43.225	56240.0
2018-04-10 04:00:00	MSFT	Stock	92.15	92.15	92.15	92.15	900.0
2018-04-10 04:30:00	MSFT	Stock	92.5	92.5	92.4	92.5	2200.0
2018-04-10 05:30:00	MSFT	Stock	92.61	92.61	92.61	92.61	380.0
2018-04-10 06:00:00	MSFT	Stock	92.4	92.4	92.4	92.4	100.0
2018-04-10 06:30:00	MSFT	Stock	92.4	92.4	92.4	92.4	100.0
2018-04-10 07:00:00	MSFT	Stock	92.3	92.3	92.05	92.2	6338.0
2018-04-10 07:30:00	MSFT	Stock	92.2	92.37	92.2	92.3	9896.0
2018-04-10 08:00:00	MSFT	Stock	92.367	92.5	92.23	92.3	39239.0
2018-04-10 08:30:00	MSFT	Stock	92.255	92.32	92.05	92.15	18546.0
2018-04-10 09:00:00	MSFT	Stock	92.2	92.44	92.11	92.4	32913.0
2018-04-10 09:30:00	MSFT	Stock	92.36	92.97	91.64	91.885	3571633.0
2018-04-10 10:00:00	MSFT	Stock	91.89	92.33	91.86	92.18	1486614.0
2018-04-10 10:30:00	MSFT	Stock	92.18	92.85	92.18	92.51	1249961.0
2018-04-10 11:00:00	MSFT	Stock	92.51	92.73	92.24	92.47	1266384.0
2018-04-10 11:30:00	MSFT	Stock	92.46	93.0	92.3	92.535	1735899.0
2018-04-10 12:00:00	MSFT	Stock	92.53	92.68	91.65	92.03	1558791.0
2018-04-10 12:30:00	MSFT	Stock	92.02	92.43	91.92	92.14	940036.0
2018-04-10 13:00:00	MSFT	Stock	92.16	92.5	92.02	92.466	803314.0

> showing 50 of 83,808 rows — these rows as CSV

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