PREVIEW / stock_30min / 2014-03-06

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-06.parquet
  size:    1.6 MB
  rows:    82,693
  symbols: 3,525

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-03-06 04:00:00	AAPL	Stock	19.0525	19.0532	19.0525	19.0532	14000.0
2014-03-06 06:00:00	AAPL	Stock	19.0407	19.0407	19.0407	19.0407	5600.0
2014-03-06 06:30:00	AAPL	Stock	19.0357	19.0357	19.0357	19.0357	5600.0
2014-03-06 07:00:00	AAPL	Stock	19.0321	19.0443	19.0321	19.0396	58380.0
2014-03-06 07:30:00	AAPL	Stock	19.0393	19.0393	19.0286	19.0375	46760.0
2014-03-06 08:00:00	AAPL	Stock	19.0357	19.0529	19.0257	19.045	283640.0
2014-03-06 08:30:00	AAPL	Stock	19.05	19.0521	19.0418	19.0464	175560.0
2014-03-06 09:00:00	AAPL	Stock	19.0429	19.05	19.0257	19.0286	493584.0
2014-03-06 09:30:00	AAPL	Stock	19.02	19.0871	18.9643	18.9679	26507376.0
2014-03-06 10:00:00	AAPL	Stock	18.9679	19.0357	18.9546	19.0357	13103216.0
2014-03-06 10:30:00	AAPL	Stock	19.0354	19.0593	18.9871	19.0132	9600472.0
2014-03-06 11:00:00	AAPL	Stock	19.0125	19.0282	18.9946	19.0154	6219808.0
2014-03-06 11:30:00	AAPL	Stock	19.0093	19.0154	18.9786	18.9905	6088628.0
2014-03-06 12:00:00	AAPL	Stock	18.9904	19.0064	18.9643	18.9835	6469372.0
2014-03-06 12:30:00	AAPL	Stock	18.9825	19.0	18.9721	18.9889	6137236.0
2014-03-06 13:00:00	AAPL	Stock	18.9864	18.9911	18.9421	18.9468	6648208.0
2014-03-06 13:30:00	AAPL	Stock	18.9432	18.9468	18.8936	18.8975	11969160.0
2014-03-06 14:00:00	AAPL	Stock	18.895	18.9518	18.8607	18.9489	9338616.0
2014-03-06 14:30:00	AAPL	Stock	18.9489	18.9514	18.9107	18.9404	6940668.0
2014-03-06 15:00:00	AAPL	Stock	18.9404	18.9511	18.9204	18.9475	5620132.0
2014-03-06 15:30:00	AAPL	Stock	18.9475	18.9696	18.9164	18.9579	17029152.0
2014-03-06 16:00:00	AAPL	Stock	18.9554	18.9757	18.9311	18.9554	12592076.0
2014-03-06 16:30:00	AAPL	Stock	18.9554	18.9554	18.9554	18.9554	65604.0
2014-03-06 17:00:00	AAPL	Stock	18.9375	18.9591	18.9375	18.9461	40292.0
2014-03-06 17:30:00	AAPL	Stock	18.9464	18.95	18.9414	18.95	17892.0
2014-03-06 18:00:00	AAPL	Stock	18.95	18.95	18.9404	18.9404	8400.0
2014-03-06 18:30:00	AAPL	Stock	18.9375	18.9375	18.9375	18.9375	5600.0
2014-03-06 19:00:00	AAPL	Stock	18.9554	18.9589	18.945	18.9589	61152.0
2014-03-06 19:30:00	AAPL	Stock	18.9518	18.9518	18.9343	18.9375	62496.0
2014-03-06 08:00:00	MSFT	Stock	38.11	38.16	38.11	38.11	3300.0
2014-03-06 08:30:00	MSFT	Stock	38.24	38.24	38.2	38.2	4526.0
2014-03-06 09:00:00	MSFT	Stock	38.15	38.19	37.78	38.14	11900.0
2014-03-06 09:30:00	MSFT	Stock	38.14	38.18	37.97	38.03	2627127.0
2014-03-06 10:00:00	MSFT	Stock	38.03	38.06	37.96	38.05	1351575.0
2014-03-06 10:30:00	MSFT	Stock	38.043	38.08	37.99	38.0	1249130.0
2014-03-06 11:00:00	MSFT	Stock	38.0	38.04	37.89	38.02	1736815.0
2014-03-06 11:30:00	MSFT	Stock	38.02	38.11	38.013	38.105	669762.0
2014-03-06 12:00:00	MSFT	Stock	38.1	38.12	38.05	38.07	578510.0
2014-03-06 12:30:00	MSFT	Stock	38.072	38.1	38.05	38.06	614090.0
2014-03-06 13:00:00	MSFT	Stock	38.055	38.06	37.97	37.995	842980.0
2014-03-06 13:30:00	MSFT	Stock	37.991	38.03	37.962	37.986	1256120.0
2014-03-06 14:00:00	MSFT	Stock	37.98	38.1	37.98	38.1	1201817.0
2014-03-06 14:30:00	MSFT	Stock	38.095	38.15	38.07	38.15	1132676.0
2014-03-06 15:00:00	MSFT	Stock	38.145	38.24	38.09	38.125	2076084.0
2014-03-06 15:30:00	MSFT	Stock	38.125	38.18	38.02	38.15	4629020.0
2014-03-06 16:00:00	MSFT	Stock	38.14	38.16	38.026	38.14	2375051.0
2014-03-06 16:30:00	MSFT	Stock	38.12	38.14	38.104	38.14	33238.0
2014-03-06 17:00:00	MSFT	Stock	38.14	38.148	38.14	38.148	8374.0
2014-03-06 17:30:00	MSFT	Stock	38.12	38.12	38.12	38.12	100.0
2014-03-06 18:00:00	MSFT	Stock	38.12	38.12	38.12	38.12	200.0

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

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