PREVIEW / stock_30min / 2014-11-18

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-18.parquet
  size:    1.6 MB
  rows:    83,322
  symbols: 3,579

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-11-18 04:00:00	AAPL	Stock	28.4425	28.5425	28.4425	28.49	12400.0
2014-11-18 04:30:00	AAPL	Stock	28.535	28.5375	28.52	28.5275	3600.0
2014-11-18 05:00:00	AAPL	Stock	28.5375	28.5425	28.475	28.475	5828.0
2014-11-18 05:30:00	AAPL	Stock	28.4625	28.4625	28.425	28.4325	6500.0
2014-11-18 06:00:00	AAPL	Stock	28.475	28.475	28.4025	28.4025	18000.0
2014-11-18 06:30:00	AAPL	Stock	28.3975	28.435	28.39	28.435	20200.0
2014-11-18 07:00:00	AAPL	Stock	28.435	28.46	28.4275	28.4275	38520.0
2014-11-18 07:30:00	AAPL	Stock	28.445	28.47	28.4375	28.47	64980.0
2014-11-18 08:00:00	AAPL	Stock	28.47	28.5375	28.375	28.5275	234256.0
2014-11-18 08:30:00	AAPL	Stock	28.525	28.525	28.4825	28.5	196680.0
2014-11-18 09:00:00	AAPL	Stock	28.5	28.5125	28.4625	28.485	265640.0
2014-11-18 09:30:00	AAPL	Stock	28.485	28.66	28.4725	28.6575	20062176.0
2014-11-18 10:00:00	AAPL	Stock	28.6575	28.67	28.6125	28.621	12202264.0
2014-11-18 10:30:00	AAPL	Stock	28.62	28.65	28.58	28.605	8993680.0
2014-11-18 11:00:00	AAPL	Stock	28.6025	28.6375	28.5732	28.6225	8233836.0
2014-11-18 11:30:00	AAPL	Stock	28.6225	28.6975	28.6175	28.69	9170144.0
2014-11-18 12:00:00	AAPL	Stock	28.69	28.8025	28.69	28.7862	15027736.0
2014-11-18 12:30:00	AAPL	Stock	28.7875	28.8075	28.715	28.8	10128500.0
2014-11-18 13:00:00	AAPL	Stock	28.8	28.875	28.7902	28.8725	9135388.0
2014-11-18 13:30:00	AAPL	Stock	28.87	28.875	28.8	28.8492	7172008.0
2014-11-18 14:00:00	AAPL	Stock	28.8475	28.9225	28.8375	28.8718	10835016.0
2014-11-18 14:30:00	AAPL	Stock	28.87	28.9	28.7825	28.82	9455396.0
2014-11-18 15:00:00	AAPL	Stock	28.8225	28.895	28.8175	28.8838	7905364.0
2014-11-18 15:30:00	AAPL	Stock	28.8825	28.9	28.8475	28.87	19723196.0
2014-11-18 16:00:00	AAPL	Stock	28.8675	28.8825	28.6385	28.84	13858744.0
2014-11-18 16:30:00	AAPL	Stock	28.7622	28.8675	28.7622	28.8525	102920.0
2014-11-18 17:00:00	AAPL	Stock	28.8525	28.8675	28.8525	28.855	708676.0
2014-11-18 17:30:00	AAPL	Stock	28.845	28.86	28.8425	28.85	47512.0
2014-11-18 18:00:00	AAPL	Stock	28.8425	28.8675	28.795	28.85	89836.0
2014-11-18 18:30:00	AAPL	Stock	28.85	28.8525	28.83	28.845	23020.0
2014-11-18 19:00:00	AAPL	Stock	28.845	28.8625	28.845	28.8625	33324.0
2014-11-18 19:30:00	AAPL	Stock	28.8525	28.8625	28.8525	28.855	30320.0
2014-11-18 05:30:00	MSFT	Stock	49.3	49.3	49.3	49.3	100.0
2014-11-18 07:00:00	MSFT	Stock	49.35	49.35	49.22	49.22	2500.0
2014-11-18 07:30:00	MSFT	Stock	49.2	49.29	49.2	49.26	3250.0
2014-11-18 08:00:00	MSFT	Stock	49.18	49.26	49.17	49.25	5000.0
2014-11-18 08:30:00	MSFT	Stock	49.2	49.25	49.2	49.25	1000.0
2014-11-18 09:00:00	MSFT	Stock	49.25	49.25	48.99	49.06	20076.0
2014-11-18 09:30:00	MSFT	Stock	49.13	49.325	48.94	49.1	2970848.0
2014-11-18 10:00:00	MSFT	Stock	49.095	49.21	49.06	49.15	2450459.0
2014-11-18 10:30:00	MSFT	Stock	49.14	49.15	48.95	48.95	2108082.0
2014-11-18 11:00:00	MSFT	Stock	48.955	48.99	48.87	48.9	1081551.0
2014-11-18 11:30:00	MSFT	Stock	48.895	49.06	48.89	48.99	1039012.0
2014-11-18 12:00:00	MSFT	Stock	48.99	49.01	48.92	48.96	863395.0
2014-11-18 12:30:00	MSFT	Stock	48.955	48.98	48.82	48.86	1262952.0
2014-11-18 13:00:00	MSFT	Stock	48.86	48.9	48.81	48.895	651070.0
2014-11-18 13:30:00	MSFT	Stock	48.895	48.9	48.78	48.809	884689.0
2014-11-18 14:00:00	MSFT	Stock	48.8	48.905	48.8	48.85	824727.0
2014-11-18 14:30:00	MSFT	Stock	48.85	48.86	48.75	48.795	945178.0
2014-11-18 15:00:00	MSFT	Stock	48.795	48.83	48.73	48.765	1405846.0

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

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