PREVIEW / stock_30min / 2015-06-18

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-18.parquet
  size:    1.6 MB
  rows:    83,140
  symbols: 3,520

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
2015-06-18 04:30:00	AAPL	Stock	31.78	31.78	31.75	31.7525	18044.0
2015-06-18 05:00:00	AAPL	Stock	31.735	31.7375	31.735	31.7375	5640.0
2015-06-18 05:30:00	AAPL	Stock	31.7375	31.78	31.735	31.78	18152.0
2015-06-18 06:00:00	AAPL	Stock	31.81	31.8325	31.795	31.8325	72776.0
2015-06-18 06:30:00	AAPL	Stock	31.835	31.8425	31.8225	31.825	38632.0
2015-06-18 07:00:00	AAPL	Stock	31.8125	31.85	31.8	31.85	53264.0
2015-06-18 07:30:00	AAPL	Stock	31.8575	31.87	31.83	31.84	38752.0
2015-06-18 08:00:00	AAPL	Stock	31.8375	31.8575	31.805	31.82	121184.0
2015-06-18 08:30:00	AAPL	Stock	31.8225	31.8475	31.8175	31.825	234584.0
2015-06-18 09:00:00	AAPL	Stock	31.815	31.8425	31.7725	31.8075	436436.0
2015-06-18 09:30:00	AAPL	Stock	31.8175	32.0525	31.805	32.0175	24216500.0
2015-06-18 10:00:00	AAPL	Stock	32.0175	32.0775	32.0025	32.045	12229080.0
2015-06-18 10:30:00	AAPL	Stock	32.0425	32.0775	32.01	32.0325	10007192.0
2015-06-18 11:00:00	AAPL	Stock	32.0325	32.075	32.0125	32.0275	9399044.0
2015-06-18 11:30:00	AAPL	Stock	32.0275	32.0325	31.96	31.965	8877480.0
2015-06-18 12:00:00	AAPL	Stock	31.9625	32.0075	31.945	32.005	7427692.0
2015-06-18 12:30:00	AAPL	Stock	32.005	32.04	31.97	31.975	7343560.0
2015-06-18 13:00:00	AAPL	Stock	31.9775	32.0	31.91	31.9325	6802148.0
2015-06-18 13:30:00	AAPL	Stock	31.9338	31.95	31.91	31.92	5249784.0
2015-06-18 14:00:00	AAPL	Stock	31.9188	31.9775	31.9162	31.95	6150472.0
2015-06-18 14:30:00	AAPL	Stock	31.95	32.0325	31.9462	32.0312	6886312.0
2015-06-18 15:00:00	AAPL	Stock	32.0325	32.0375	31.9775	32.035	8011280.0
2015-06-18 15:30:00	AAPL	Stock	32.0362	32.045	31.9375	31.96	14524456.0
2015-06-18 16:00:00	AAPL	Stock	31.97	32.0127	31.9425	31.97	5598048.0
2015-06-18 16:30:00	AAPL	Stock	31.97	31.98	31.97	31.9725	35832.0
2015-06-18 17:00:00	AAPL	Stock	31.9675	31.98	31.96	31.97	396604.0
2015-06-18 17:30:00	AAPL	Stock	31.975	31.9775	31.9725	31.975	6600.0
2015-06-18 18:00:00	AAPL	Stock	31.9725	31.975	31.97	31.97	43380.0
2015-06-18 18:30:00	AAPL	Stock	31.97	31.9725	31.96	31.96	15384.0
2015-06-18 19:00:00	AAPL	Stock	31.9575	31.96	31.9425	31.9425	20428.0
2015-06-18 19:30:00	AAPL	Stock	31.9275	31.95	31.9275	31.95	13540.0
2015-06-18 04:30:00	MSFT	Stock	45.85	45.85	45.85	45.85	900.0
2015-06-18 05:30:00	MSFT	Stock	45.92	45.92	45.92	45.92	900.0
2015-06-18 06:00:00	MSFT	Stock	45.92	45.95	45.92	45.95	4696.0
2015-06-18 06:30:00	MSFT	Stock	45.98	46.05	45.97	45.97	2000.0
2015-06-18 07:00:00	MSFT	Stock	46.02	46.04	46.02	46.04	1150.0
2015-06-18 07:30:00	MSFT	Stock	45.97	45.97	45.95	45.97	3400.0
2015-06-18 08:00:00	MSFT	Stock	45.99	46.05	45.99	46.05	2850.0
2015-06-18 08:30:00	MSFT	Stock	46.02	46.13	46.01	46.13	7080.0
2015-06-18 09:00:00	MSFT	Stock	46.09	46.21	46.07	46.21	8363.0
2015-06-18 09:30:00	MSFT	Stock	46.21	46.5	46.16	46.34	4357249.0
2015-06-18 10:00:00	MSFT	Stock	46.33	46.51	46.23	46.23	2844894.0
2015-06-18 10:30:00	MSFT	Stock	46.23	46.52	46.18	46.515	2329264.0
2015-06-18 11:00:00	MSFT	Stock	46.52	46.62	46.38	46.57	2413914.0
2015-06-18 11:30:00	MSFT	Stock	46.56	46.67	46.515	46.63	1511816.0
2015-06-18 12:00:00	MSFT	Stock	46.63	46.73	46.55	46.69	1434039.0
2015-06-18 12:30:00	MSFT	Stock	46.685	46.8	46.61	46.645	1396242.0
2015-06-18 13:00:00	MSFT	Stock	46.65	46.7	46.56	46.624	1186054.0
2015-06-18 13:30:00	MSFT	Stock	46.62	46.65	46.55	46.57	1066801.0
2015-06-18 14:00:00	MSFT	Stock	46.57	46.675	46.54	46.62	1279371.0

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

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