PREVIEW / stock_30min / 2012-11-02

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-02.parquet
  size:    1.4 MB
  rows:    74,834
  symbols: 3,453

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-02 04:00:00	AAPL	Stock	21.3214	21.3214	21.2525	21.2857	14000.0
2012-11-02 05:00:00	AAPL	Stock	21.2857	21.2857	21.2857	21.2857	2800.0
2012-11-02 05:30:00	AAPL	Stock	21.3468	21.3468	21.3468	21.3468	2800.0
2012-11-02 06:00:00	AAPL	Stock	21.3468	21.3468	21.3468	21.3468	2800.0
2012-11-02 06:30:00	AAPL	Stock	21.3457	21.3457	21.3143	21.3357	9016.0
2012-11-02 07:00:00	AAPL	Stock	21.3214	21.3214	21.2929	21.3014	44800.0
2012-11-02 07:30:00	AAPL	Stock	21.295	21.295	21.2679	21.2732	233044.0
2012-11-02 08:00:00	AAPL	Stock	21.2821	21.2886	21.2054	21.2821	668752.0
2012-11-02 08:30:00	AAPL	Stock	21.2857	21.3457	21.2679	21.2864	1931524.0
2012-11-02 09:00:00	AAPL	Stock	21.285	21.2993	21.2182	21.2954	1368276.0
2012-11-02 09:30:00	AAPL	Stock	21.295	21.3196	21.1139	21.1734	48912388.0
2012-11-02 10:00:00	AAPL	Stock	21.1768	21.1786	21.0596	21.0911	38899560.0
2012-11-02 10:30:00	AAPL	Stock	21.0861	21.1607	21.0714	21.1325	26862500.0
2012-11-02 11:00:00	AAPL	Stock	21.1268	21.2107	21.115	21.1614	20176604.0
2012-11-02 11:30:00	AAPL	Stock	21.1611	21.165	21.0464	21.0961	25841396.0
2012-11-02 12:00:00	AAPL	Stock	21.0896	21.0959	21.04	21.0732	18387852.0
2012-11-02 12:30:00	AAPL	Stock	21.0675	21.1093	21.0539	21.0718	16822344.0
2012-11-02 13:00:00	AAPL	Stock	21.0702	21.0857	20.9557	20.9702	32954880.0
2012-11-02 13:30:00	AAPL	Stock	20.9723	21.0132	20.9029	20.9293	40213936.0
2012-11-02 14:00:00	AAPL	Stock	20.9293	20.9321	20.7875	20.7954	51738176.0
2012-11-02 14:30:00	AAPL	Stock	20.7882	20.8036	20.7193	20.7861	69950468.0
2012-11-02 15:00:00	AAPL	Stock	20.7843	20.8268	20.6725	20.68	62082608.0
2012-11-02 15:30:00	AAPL	Stock	20.68	20.6879	20.5268	20.605	118563620.0
2012-11-02 16:00:00	AAPL	Stock	20.6064	20.8889	20.558	20.6429	13337716.0
2012-11-02 16:30:00	AAPL	Stock	20.6429	21.287	20.5725	20.6071	1423716.0
2012-11-02 17:00:00	AAPL	Stock	20.6071	20.6175	20.6021	20.6064	149632.0
2012-11-02 17:30:00	AAPL	Stock	20.6054	20.6068	20.6	20.6036	50316.0
2012-11-02 18:00:00	AAPL	Stock	20.6036	20.6161	20.5961	20.6046	127176.0
2012-11-02 18:30:00	AAPL	Stock	20.6068	20.6179	20.6014	20.6164	54348.0
2012-11-02 19:00:00	AAPL	Stock	20.6161	20.6164	20.5893	20.6021	38556.0
2012-11-02 19:30:00	AAPL	Stock	20.6	20.6071	20.5943	20.6071	201124.0
2012-11-02 06:00:00	MSFT	Stock	29.57	29.57	29.57	29.57	213.0
2012-11-02 06:30:00	MSFT	Stock	29.57	29.57	29.57	29.57	500.0
2012-11-02 07:00:00	MSFT	Stock	29.57	29.57	29.53	29.57	3950.0
2012-11-02 07:30:00	MSFT	Stock	29.52	29.56	29.51	29.56	2690.0
2012-11-02 08:00:00	MSFT	Stock	29.56	29.6	29.54	29.55	8600.0
2012-11-02 08:30:00	MSFT	Stock	29.64	29.73	29.56	29.57	60792.0
2012-11-02 09:00:00	MSFT	Stock	29.57	29.67	29.57	29.67	81284.0
2012-11-02 09:30:00	MSFT	Stock	29.64	29.67	29.49	29.577	6697977.0
2012-11-02 10:00:00	MSFT	Stock	29.58	29.6	29.34	29.34	3749068.0
2012-11-02 10:30:00	MSFT	Stock	29.345	29.5	29.33	29.485	4632424.0
2012-11-02 11:00:00	MSFT	Stock	29.485	29.51	29.44	29.5	3183913.0
2012-11-02 11:30:00	MSFT	Stock	29.49	29.62	29.45	29.62	3639309.0
2012-11-02 12:00:00	MSFT	Stock	29.61	29.62	29.56	29.57	2761100.0
2012-11-02 12:30:00	MSFT	Stock	29.58	29.63	29.57	29.59	2220882.0
2012-11-02 13:00:00	MSFT	Stock	29.59	29.595	29.53	29.54	1779624.0
2012-11-02 13:30:00	MSFT	Stock	29.55	29.77	29.54	29.63	4962215.0
2012-11-02 14:00:00	MSFT	Stock	29.63	29.675	29.55	29.67	2915219.0
2012-11-02 14:30:00	MSFT	Stock	29.67	29.74	29.52	29.615	4479739.0
2012-11-02 15:00:00	MSFT	Stock	29.615	29.69	29.58	29.65	4388339.0

> showing 50 of 74,834 rows — these rows as CSV

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