PREVIEW / stock_5min / 2017-03-03

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-03-03.parquet
  size:    5.3 MB
  rows:    346,775
  symbols: 3,065

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-03-03 05:55:00	AAPL	Stock	34.72	34.72	34.72	34.72	604.0
2017-03-03 06:15:00	AAPL	Stock	34.7175	34.745	34.7175	34.745	4000.0
2017-03-03 06:30:00	AAPL	Stock	34.7225	34.7225	34.7225	34.7225	400.0
2017-03-03 06:40:00	AAPL	Stock	34.7225	34.7225	34.7225	34.7225	800.0
2017-03-03 06:50:00	AAPL	Stock	34.7225	34.7225	34.7225	34.7225	400.0
2017-03-03 06:55:00	AAPL	Stock	34.7125	34.7125	34.7125	34.7125	584.0
2017-03-03 07:00:00	AAPL	Stock	34.7125	34.7125	34.7125	34.7125	2000.0
2017-03-03 07:05:00	AAPL	Stock	34.7	34.7125	34.7	34.7125	3200.0
2017-03-03 07:10:00	AAPL	Stock	34.725	34.725	34.725	34.725	3600.0
2017-03-03 07:15:00	AAPL	Stock	34.7125	34.7125	34.7125	34.7125	2000.0
2017-03-03 07:35:00	AAPL	Stock	34.705	34.705	34.7025	34.7025	1796.0
2017-03-03 07:40:00	AAPL	Stock	34.6875	34.69	34.6775	34.6775	10200.0
2017-03-03 07:45:00	AAPL	Stock	34.675	34.675	34.65	34.65	12820.0
2017-03-03 07:50:00	AAPL	Stock	34.65	34.655	34.6375	34.655	9656.0
2017-03-03 07:55:00	AAPL	Stock	34.655	34.6575	34.655	34.6575	9360.0
2017-03-03 08:00:00	AAPL	Stock	34.725	34.7375	34.65	34.6575	36460.0
2017-03-03 08:05:00	AAPL	Stock	34.6575	34.6575	34.6525	34.6575	11460.0
2017-03-03 08:10:00	AAPL	Stock	34.6625	34.67	34.655	34.655	9112.0
2017-03-03 08:15:00	AAPL	Stock	34.6575	34.67	34.6575	34.67	10400.0
2017-03-03 08:20:00	AAPL	Stock	34.67	34.67	34.6675	34.67	5200.0
2017-03-03 08:25:00	AAPL	Stock	34.6725	34.6725	34.665	34.67	9596.0
2017-03-03 08:30:00	AAPL	Stock	34.665	34.6725	34.665	34.6725	7660.0
2017-03-03 08:35:00	AAPL	Stock	34.665	34.665	34.655	34.66	17796.0
2017-03-03 08:40:00	AAPL	Stock	34.655	34.655	34.65	34.65	8156.0
2017-03-03 08:45:00	AAPL	Stock	34.6475	34.6475	34.645	34.645	4248.0
2017-03-03 08:50:00	AAPL	Stock	34.645	34.6625	34.645	34.65	39580.0
2017-03-03 08:55:00	AAPL	Stock	34.665	34.665	34.65	34.6575	4056.0
2017-03-03 09:00:00	AAPL	Stock	34.6575	34.6575	34.6575	34.6575	400.0
2017-03-03 09:05:00	AAPL	Stock	34.665	34.6725	34.665	34.6675	16924.0
2017-03-03 09:10:00	AAPL	Stock	34.6525	34.655	34.6475	34.6475	18264.0
2017-03-03 09:15:00	AAPL	Stock	34.6575	34.6825	34.65	34.6725	32552.0
2017-03-03 09:20:00	AAPL	Stock	34.6725	34.6725	34.665	34.665	5996.0
2017-03-03 09:25:00	AAPL	Stock	34.65	34.6975	34.65	34.6925	19272.0
2017-03-03 09:30:00	AAPL	Stock	34.69	34.8175	34.6475	34.785	3996588.0
2017-03-03 09:35:00	AAPL	Stock	34.7825	34.82	34.7425	34.7565	2152856.0
2017-03-03 09:40:00	AAPL	Stock	34.7575	34.8075	34.7375	34.7975	1340644.0
2017-03-03 09:45:00	AAPL	Stock	34.7975	34.8125	34.7625	34.7875	1319388.0
2017-03-03 09:50:00	AAPL	Stock	34.7875	34.835	34.7688	34.7715	1560792.0
2017-03-03 09:55:00	AAPL	Stock	34.77	34.7912	34.755	34.783	940232.0
2017-03-03 10:00:00	AAPL	Stock	34.785	34.805	34.7675	34.795	888496.0
2017-03-03 10:05:00	AAPL	Stock	34.7925	34.7998	34.76	34.7675	771916.0
2017-03-03 10:10:00	AAPL	Stock	34.77	34.8375	34.7675	34.8212	1053592.0
2017-03-03 10:15:00	AAPL	Stock	34.8222	34.835	34.8075	34.8125	903176.0
2017-03-03 10:20:00	AAPL	Stock	34.81	34.81	34.7612	34.7725	1177552.0
2017-03-03 10:25:00	AAPL	Stock	34.775	34.775	34.73	34.7725	839644.0
2017-03-03 10:30:00	AAPL	Stock	34.775	34.7775	34.715	34.7275	770032.0
2017-03-03 10:35:00	AAPL	Stock	34.7275	34.745	34.725	34.74	554120.0
2017-03-03 10:40:00	AAPL	Stock	34.74	34.7525	34.7225	34.7525	725944.0
2017-03-03 10:45:00	AAPL	Stock	34.75	34.775	34.7425	34.7567	1011992.0
2017-03-03 10:50:00	AAPL	Stock	34.755	34.775	34.75	34.7712	519036.0

> showing 50 of 346,775 rows — these rows as CSV

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