PREVIEW / stock_30min / 2017-09-29

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-29.parquet
  size:    1.6 MB
  rows:    82,161
  symbols: 2,964

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-09-29 04:00:00	AAPL	Stock	38.3175	38.35	38.3	38.35	11952.0
2017-09-29 04:30:00	AAPL	Stock	38.35	38.35	38.3025	38.3025	1796.0
2017-09-29 05:00:00	AAPL	Stock	38.3025	38.3625	38.3025	38.3625	800.0
2017-09-29 05:30:00	AAPL	Stock	38.3625	38.3625	38.3625	38.3625	400.0
2017-09-29 06:00:00	AAPL	Stock	38.3175	38.325	38.3175	38.325	800.0
2017-09-29 06:30:00	AAPL	Stock	38.3275	38.35	38.3	38.35	7476.0
2017-09-29 07:00:00	AAPL	Stock	38.35	38.4	38.2775	38.28	83676.0
2017-09-29 07:30:00	AAPL	Stock	38.28	38.32	38.28	38.2875	38940.0
2017-09-29 08:00:00	AAPL	Stock	38.3475	38.375	38.225	38.25	197980.0
2017-09-29 08:30:00	AAPL	Stock	38.225	38.27	38.225	38.27	37408.0
2017-09-29 09:00:00	AAPL	Stock	38.27	38.3075	38.25	38.3025	138816.0
2017-09-29 09:30:00	AAPL	Stock	38.3075	38.5	38.0025	38.045	14585580.0
2017-09-29 10:00:00	AAPL	Stock	38.0475	38.16	38.0	38.1225	9331508.0
2017-09-29 10:30:00	AAPL	Stock	38.1225	38.3325	38.1025	38.3225	7573060.0
2017-09-29 11:00:00	AAPL	Stock	38.32	38.438	38.2675	38.3988	7761704.0
2017-09-29 11:30:00	AAPL	Stock	38.3988	38.425	38.34	38.4125	4075960.0
2017-09-29 12:00:00	AAPL	Stock	38.415	38.455	38.3775	38.4475	4624560.0
2017-09-29 12:30:00	AAPL	Stock	38.4475	38.495	38.43	38.456	4352840.0
2017-09-29 13:00:00	AAPL	Stock	38.457	38.4775	38.3975	38.4225	3088884.0
2017-09-29 13:30:00	AAPL	Stock	38.4225	38.455	38.415	38.444	2549512.0
2017-09-29 14:00:00	AAPL	Stock	38.4425	38.4675	38.405	38.4655	3018676.0
2017-09-29 14:30:00	AAPL	Stock	38.4655	38.4825	38.4225	38.44	3162572.0
2017-09-29 15:00:00	AAPL	Stock	38.4362	38.4425	38.37	38.4065	4161608.0
2017-09-29 15:30:00	AAPL	Stock	38.4075	38.5325	38.3725	38.5	14098376.0
2017-09-29 16:00:00	AAPL	Stock	38.53	38.55	38.372	38.53	12000284.0
2017-09-29 16:30:00	AAPL	Stock	38.53	38.53	38.515	38.52	77928.0
2017-09-29 17:00:00	AAPL	Stock	38.52	38.53	38.5175	38.5175	12236.0
2017-09-29 17:30:00	AAPL	Stock	38.53	38.535	38.5125	38.525	244416.0
2017-09-29 18:00:00	AAPL	Stock	38.505	38.53	38.505	38.5275	12400.0
2017-09-29 18:30:00	AAPL	Stock	38.525	38.5375	38.525	38.5375	9600.0
2017-09-29 19:00:00	AAPL	Stock	38.5375	38.5375	38.525	38.525	14148.0
2017-09-29 19:30:00	AAPL	Stock	38.525	38.5375	38.525	38.53	25980.0
2017-09-29 06:30:00	MSFT	Stock	73.96	73.96	73.96	73.96	229.0
2017-09-29 07:00:00	MSFT	Stock	73.96	73.96	73.96	73.96	300.0
2017-09-29 08:00:00	MSFT	Stock	73.94	73.94	73.94	73.94	5100.0
2017-09-29 08:30:00	MSFT	Stock	73.95	73.95	73.95	73.95	200.0
2017-09-29 09:00:00	MSFT	Stock	73.98	74.0	73.92	73.92	5846.0
2017-09-29 09:30:00	MSFT	Stock	73.94	74.228	73.88	74.01	1315044.0
2017-09-29 10:00:00	MSFT	Stock	74.0	74.13	73.95	74.1	811644.0
2017-09-29 10:30:00	MSFT	Stock	74.1	74.24	74.02	74.2	625020.0
2017-09-29 11:00:00	MSFT	Stock	74.2	74.44	74.11	74.338	859422.0
2017-09-29 11:30:00	MSFT	Stock	74.34	74.38	74.26	74.374	526050.0
2017-09-29 12:00:00	MSFT	Stock	74.38	74.39	74.24	74.335	529957.0
2017-09-29 12:30:00	MSFT	Stock	74.33	74.465	74.33	74.45	426279.0
2017-09-29 13:00:00	MSFT	Stock	74.45	74.48	74.33	74.36	393183.0
2017-09-29 13:30:00	MSFT	Stock	74.36	74.39	74.29	74.35	605439.0
2017-09-29 14:00:00	MSFT	Stock	74.35	74.435	74.28	74.404	679704.0
2017-09-29 14:30:00	MSFT	Stock	74.405	74.425	74.27	74.38	496785.0
2017-09-29 15:00:00	MSFT	Stock	74.37	74.4	74.32	74.35	619488.0
2017-09-29 15:30:00	MSFT	Stock	74.36	74.535	74.3	74.45	3318030.0

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

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