PREVIEW / stock_30min / 2016-03-30

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-30.parquet
  size:    1.6 MB
  rows:    81,892
  symbols: 3,349

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-30 04:00:00	AAPL	Stock	26.9775	27.0625	26.9775	27.0575	5328.0
2016-03-30 05:30:00	AAPL	Stock	27.0625	27.0625	27.0625	27.0625	680.0
2016-03-30 06:00:00	AAPL	Stock	27.0625	27.2225	27.03	27.18	148396.0
2016-03-30 06:30:00	AAPL	Stock	27.2175	27.22	27.175	27.2	49188.0
2016-03-30 07:00:00	AAPL	Stock	27.1975	27.275	27.1625	27.25	247352.0
2016-03-30 07:30:00	AAPL	Stock	27.275	27.3575	27.22	27.25	267344.0
2016-03-30 08:00:00	AAPL	Stock	27.2275	27.2875	26.875	27.2625	598364.0
2016-03-30 08:30:00	AAPL	Stock	27.2625	27.2875	27.23	27.265	332388.0
2016-03-30 09:00:00	AAPL	Stock	27.2675	27.2775	27.1575	27.1575	571092.0
2016-03-30 09:30:00	AAPL	Stock	27.1625	27.545	27.15	27.4932	40921080.0
2016-03-30 10:00:00	AAPL	Stock	27.4975	27.605	27.42	27.4275	19965000.0
2016-03-30 10:30:00	AAPL	Stock	27.4275	27.525	27.4262	27.4525	10492408.0
2016-03-30 11:00:00	AAPL	Stock	27.4525	27.5175	27.3125	27.355	12161516.0
2016-03-30 11:30:00	AAPL	Stock	27.355	27.36	27.2025	27.2998	12314224.0
2016-03-30 12:00:00	AAPL	Stock	27.2978	27.36	27.27	27.3	6289080.0
2016-03-30 12:30:00	AAPL	Stock	27.3	27.32	27.2188	27.2515	5854516.0
2016-03-30 13:00:00	AAPL	Stock	27.2525	27.3025	27.2075	27.215	4966360.0
2016-03-30 13:30:00	AAPL	Stock	27.215	27.375	27.1875	27.3525	8227692.0
2016-03-30 14:00:00	AAPL	Stock	27.3505	27.3775	27.2812	27.3475	5824392.0
2016-03-30 14:30:00	AAPL	Stock	27.35	27.4325	27.3175	27.4275	6976992.0
2016-03-30 15:00:00	AAPL	Stock	27.425	27.4775	27.3925	27.4375	9552872.0
2016-03-30 15:30:00	AAPL	Stock	27.44	27.455	27.385	27.3975	12256280.0
2016-03-30 16:00:00	AAPL	Stock	27.39	27.5145	27.3625	27.3625	5904952.0
2016-03-30 16:30:00	AAPL	Stock	27.3675	27.3895	27.355	27.375	105824.0
2016-03-30 17:00:00	AAPL	Stock	27.375	27.3875	27.3675	27.3875	79612.0
2016-03-30 17:30:00	AAPL	Stock	27.39	27.4	27.39	27.4	17996.0
2016-03-30 18:00:00	AAPL	Stock	27.4	27.4075	27.395	27.4075	26068.0
2016-03-30 18:30:00	AAPL	Stock	27.405	27.405	27.3925	27.395	29556.0
2016-03-30 19:00:00	AAPL	Stock	27.395	27.3975	27.39	27.39	9572.0
2016-03-30 19:30:00	AAPL	Stock	27.3875	27.4375	27.3825	27.39	56464.0
2016-03-30 04:00:00	MSFT	Stock	54.87	54.88	54.87	54.88	600.0
2016-03-30 06:30:00	MSFT	Stock	55.26	55.26	55.26	55.26	100.0
2016-03-30 07:00:00	MSFT	Stock	55.03	55.03	55.03	55.03	909.0
2016-03-30 08:00:00	MSFT	Stock	55.02	55.05	54.96	54.99	17624.0
2016-03-30 08:30:00	MSFT	Stock	54.99	55.05	54.99	55.05	7705.0
2016-03-30 09:00:00	MSFT	Stock	55.02	55.05	54.86	54.86	31191.0
2016-03-30 09:30:00	MSFT	Stock	54.86	55.5	54.86	55.495	3567119.0
2016-03-30 10:00:00	MSFT	Stock	55.49	55.625	55.34	55.58	2237829.0
2016-03-30 10:30:00	MSFT	Stock	55.58	55.64	55.32	55.525	1581425.0
2016-03-30 11:00:00	MSFT	Stock	55.53	55.59	55.17	55.18	1465726.0
2016-03-30 11:30:00	MSFT	Stock	55.18	55.205	55.03	55.06	1461744.0
2016-03-30 12:00:00	MSFT	Stock	55.06	55.1	54.94	55.01	919766.0
2016-03-30 12:30:00	MSFT	Stock	55.017	55.13	54.95	55.125	554716.0
2016-03-30 13:00:00	MSFT	Stock	55.12	55.3	55.112	55.205	773557.0
2016-03-30 13:30:00	MSFT	Stock	55.2	55.24	55.11	55.19	902854.0
2016-03-30 14:00:00	MSFT	Stock	55.18	55.25	55.09	55.165	900628.0
2016-03-30 14:30:00	MSFT	Stock	55.165	55.25	55.12	55.245	827302.0
2016-03-30 15:00:00	MSFT	Stock	55.24	55.32	55.21	55.25	1056914.0
2016-03-30 15:30:00	MSFT	Stock	55.25	55.27	55.01	55.05	3160116.0
2016-03-30 16:00:00	MSFT	Stock	55.05	55.316	55.0	55.08	2046258.0

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

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