PREVIEW / stock_30min / 2014-12-17

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-17.parquet
  size:    1.6 MB
  rows:    85,333
  symbols: 3,562

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
2014-12-17 04:00:00	AAPL	Stock	26.8	26.82	26.8	26.82	1200.0
2014-12-17 04:30:00	AAPL	Stock	26.8025	26.8025	26.775	26.7975	7200.0
2014-12-17 05:00:00	AAPL	Stock	26.7575	26.82	26.7575	26.82	40088.0
2014-12-17 05:30:00	AAPL	Stock	26.82	26.84	26.82	26.8225	25200.0
2014-12-17 06:00:00	AAPL	Stock	26.805	26.8375	26.775	26.7825	31876.0
2014-12-17 06:30:00	AAPL	Stock	26.775	26.945	26.775	26.94	9680.0
2014-12-17 07:00:00	AAPL	Stock	26.925	26.9275	26.8925	26.9075	107004.0
2014-12-17 07:30:00	AAPL	Stock	26.895	26.9125	26.85	26.9125	212764.0
2014-12-17 08:00:00	AAPL	Stock	26.9075	26.95	26.6875	26.8475	923264.0
2014-12-17 08:30:00	AAPL	Stock	26.855	26.89	26.8225	26.8225	279808.0
2014-12-17 09:00:00	AAPL	Stock	26.82	26.82	26.75	26.78	453284.0
2014-12-17 09:30:00	AAPL	Stock	26.78	26.95	26.705	26.9225	22085004.0
2014-12-17 10:00:00	AAPL	Stock	26.9225	26.96	26.76	26.785	13605460.0
2014-12-17 10:30:00	AAPL	Stock	26.78	26.9	26.7225	26.7525	11564668.0
2014-12-17 11:00:00	AAPL	Stock	26.753	26.8775	26.715	26.8225	10740404.0
2014-12-17 11:30:00	AAPL	Stock	26.8225	27.0075	26.7975	27.0052	14151500.0
2014-12-17 12:00:00	AAPL	Stock	27.005	27.0075	26.841	26.8725	9012888.0
2014-12-17 12:30:00	AAPL	Stock	26.875	26.9275	26.825	26.8575	6420944.0
2014-12-17 13:00:00	AAPL	Stock	26.855	26.875	26.78	26.87	6433620.0
2014-12-17 13:30:00	AAPL	Stock	26.8675	26.975	26.85	26.975	6679540.0
2014-12-17 14:00:00	AAPL	Stock	26.9725	27.3	26.94	27.1925	24155340.0
2014-12-17 14:30:00	AAPL	Stock	27.1912	27.3272	27.0875	27.1338	16035240.0
2014-12-17 15:00:00	AAPL	Stock	27.1358	27.2975	27.015	27.2825	14214064.0
2014-12-17 15:30:00	AAPL	Stock	27.2875	27.46	27.2625	27.35	27463448.0
2014-12-17 16:00:00	AAPL	Stock	27.3375	27.375	26.8495	27.3525	877420.0
2014-12-17 16:30:00	AAPL	Stock	26.7392	27.375	26.7392	27.3725	1526292.0
2014-12-17 17:00:00	AAPL	Stock	27.3725	27.3875	27.3525	27.38	148676.0
2014-12-17 17:30:00	AAPL	Stock	27.3775	27.4	27.355	27.3875	123400.0
2014-12-17 18:00:00	AAPL	Stock	27.3875	27.39	27.3825	27.3875	12880.0
2014-12-17 18:30:00	AAPL	Stock	27.3975	27.4075	27.3525	27.395	282208.0
2014-12-17 19:00:00	AAPL	Stock	27.4	27.4	27.3875	27.4	16320.0
2014-12-17 19:30:00	AAPL	Stock	27.405	27.4375	27.3875	27.4375	131276.0
2014-12-17 05:00:00	MSFT	Stock	45.34	45.35	45.34	45.35	1000.0
2014-12-17 06:00:00	MSFT	Stock	45.34	45.34	45.22	45.22	2800.0
2014-12-17 06:30:00	MSFT	Stock	45.29	45.29	45.29	45.29	100.0
2014-12-17 07:00:00	MSFT	Stock	45.37	45.37	45.37	45.37	100.0
2014-12-17 07:30:00	MSFT	Stock	45.36	45.38	45.36	45.38	600.0
2014-12-17 08:00:00	MSFT	Stock	45.43	45.43	45.35	45.38	4340.0
2014-12-17 08:30:00	MSFT	Stock	45.42	45.43	45.35	45.35	12349.0
2014-12-17 09:00:00	MSFT	Stock	45.35	45.35	45.02	45.05	36756.0
2014-12-17 09:30:00	MSFT	Stock	45.05	45.46	44.9	45.18	4135542.0
2014-12-17 10:00:00	MSFT	Stock	45.17	45.27	45.0	45.1	2114983.0
2014-12-17 10:30:00	MSFT	Stock	45.1	45.2	45.05	45.06	1680842.0
2014-12-17 11:00:00	MSFT	Stock	45.06	45.35	45.05	45.25	1395911.0
2014-12-17 11:30:00	MSFT	Stock	45.25	45.67	45.17	45.62	2432999.0
2014-12-17 12:00:00	MSFT	Stock	45.62	45.62	45.325	45.36	1205115.0
2014-12-17 12:30:00	MSFT	Stock	45.36	45.42	45.19	45.36	1262267.0
2014-12-17 13:00:00	MSFT	Stock	45.36	45.405	45.26	45.36	1146833.0
2014-12-17 13:30:00	MSFT	Stock	45.365	45.44	45.295	45.44	941433.0
2014-12-17 14:00:00	MSFT	Stock	45.43	45.92	45.38	45.7	2811413.0

> showing 50 of 85,333 rows — these rows as CSV

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