PREVIEW / stock_30min / 2012-11-12

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-12.parquet
  size:    1.4 MB
  rows:    73,105
  symbols: 3,447

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
2012-11-12 04:00:00	AAPL	Stock	19.8214	19.8214	19.6429	19.6604	35000.0
2012-11-12 04:30:00	AAPL	Stock	19.6607	19.6607	19.6429	19.6429	30240.0
2012-11-12 05:00:00	AAPL	Stock	19.6429	19.6429	19.6429	19.6429	19600.0
2012-11-12 05:30:00	AAPL	Stock	19.6464	19.6464	19.6464	19.6464	2800.0
2012-11-12 06:00:00	AAPL	Stock	19.6679	19.7071	19.6679	19.7071	46844.0
2012-11-12 06:30:00	AAPL	Stock	19.7054	19.7107	19.7054	19.7107	31080.0
2012-11-12 07:00:00	AAPL	Stock	19.7054	19.7536	19.6964	19.7143	313656.0
2012-11-12 07:30:00	AAPL	Stock	19.6964	19.7321	19.6857	19.6961	276724.0
2012-11-12 08:00:00	AAPL	Stock	19.6964	19.7429	19.6432	19.6686	1273608.0
2012-11-12 08:30:00	AAPL	Stock	19.6689	19.6911	19.6643	19.6711	803264.0
2012-11-12 09:00:00	AAPL	Stock	19.6704	19.8	19.6679	19.7946	2811676.0
2012-11-12 09:30:00	AAPL	Stock	19.7946	19.8036	19.6111	19.6689	71595580.0
2012-11-12 10:00:00	AAPL	Stock	19.6618	19.6768	19.5275	19.5786	36900192.0
2012-11-12 10:30:00	AAPL	Stock	19.5807	19.6139	19.3993	19.4086	38816792.0
2012-11-12 11:00:00	AAPL	Stock	19.4089	19.4461	19.3064	19.3739	48532484.0
2012-11-12 11:30:00	AAPL	Stock	19.3725	19.3725	19.2375	19.2917	45733884.0
2012-11-12 12:00:00	AAPL	Stock	19.2961	19.3864	19.275	19.3754	26477332.0
2012-11-12 12:30:00	AAPL	Stock	19.3718	19.5364	19.3679	19.5325	40682348.0
2012-11-12 13:00:00	AAPL	Stock	19.5325	19.5821	19.5071	19.5252	28845068.0
2012-11-12 13:30:00	AAPL	Stock	19.5282	19.53	19.3493	19.423	38155908.0
2012-11-12 14:00:00	AAPL	Stock	19.4243	19.5	19.375	19.43	20452544.0
2012-11-12 14:30:00	AAPL	Stock	19.4286	19.4343	19.3225	19.3807	23922192.0
2012-11-12 15:00:00	AAPL	Stock	19.3764	19.4643	19.3043	19.4239	31463684.0
2012-11-12 15:30:00	AAPL	Stock	19.4243	19.4704	19.3571	19.3929	39924612.0
2012-11-12 16:00:00	AAPL	Stock	19.3889	19.5936	19.2944	19.395	6989472.0
2012-11-12 16:30:00	AAPL	Stock	19.3896	19.4266	19.3879	19.3907	234192.0
2012-11-12 17:00:00	AAPL	Stock	19.387	19.5607	19.3868	19.3868	816004.0
2012-11-12 17:30:00	AAPL	Stock	19.3943	19.3979	19.3943	19.3957	25200.0
2012-11-12 18:00:00	AAPL	Stock	19.3843	19.3868	19.3596	19.3818	121520.0
2012-11-12 18:30:00	AAPL	Stock	19.3814	19.3839	19.3607	19.3607	62216.0
2012-11-12 19:00:00	AAPL	Stock	19.3707	19.3707	19.3268	19.3418	260540.0
2012-11-12 19:30:00	AAPL	Stock	19.3436	19.3475	19.3304	19.3393	126700.0
2012-11-12 04:00:00	MSFT	Stock	28.83	28.83	28.83	28.83	100.0
2012-11-12 07:00:00	MSFT	Stock	28.9	28.9	28.85	28.85	2500.0
2012-11-12 07:30:00	MSFT	Stock	28.9	28.9	28.83	28.9	11250.0
2012-11-12 08:00:00	MSFT	Stock	28.94	28.97	28.9	28.97	9105.0
2012-11-12 08:30:00	MSFT	Stock	28.95	28.95	28.84	28.85	29726.0
2012-11-12 09:00:00	MSFT	Stock	28.85	28.93	28.84	28.91	41700.0
2012-11-12 09:30:00	MSFT	Stock	28.93	29.01	28.6	28.76	5056173.0
2012-11-12 10:00:00	MSFT	Stock	28.75	28.758	28.56	28.56	3573719.0
2012-11-12 10:30:00	MSFT	Stock	28.57	28.57	28.32	28.325	6987055.0
2012-11-12 11:00:00	MSFT	Stock	28.33	28.33	28.24	28.31	5032814.0
2012-11-12 11:30:00	MSFT	Stock	28.31	28.31	28.25	28.28	3841283.0
2012-11-12 12:00:00	MSFT	Stock	28.285	28.36	28.28	28.36	3600321.0
2012-11-12 12:30:00	MSFT	Stock	28.355	28.5	28.34	28.478	4464415.0
2012-11-12 13:00:00	MSFT	Stock	28.474	28.53	28.43	28.46	2427224.0
2012-11-12 13:30:00	MSFT	Stock	28.46	28.485	28.41	28.435	1969699.0
2012-11-12 14:00:00	MSFT	Stock	28.43	28.438	28.35	28.36	2614446.0
2012-11-12 14:30:00	MSFT	Stock	28.35	28.39	28.27	28.29	4652056.0
2012-11-12 15:00:00	MSFT	Stock	28.29	28.42	28.27	28.31	6244372.0

> showing 50 of 73,105 rows — these rows as CSV

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