PREVIEW / stock_30min / 2010-10-28

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-28.parquet
  size:    1.4 MB
  rows:    75,542
  symbols: 3,470

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
2010-10-28 04:00:00	AAPL	Stock	10.93	10.93	10.93	10.93	2800.0
2010-10-28 05:00:00	AAPL	Stock	10.9657	10.9657	10.9657	10.9657	2800.0
2010-10-28 05:30:00	AAPL	Stock	10.9596	10.9643	10.9596	10.9643	8400.0
2010-10-28 06:30:00	AAPL	Stock	10.9643	10.9643	10.9643	10.9643	2800.0
2010-10-28 07:00:00	AAPL	Stock	10.9286	10.9625	10.9286	10.9536	22400.0
2010-10-28 07:30:00	AAPL	Stock	10.955	10.955	10.9375	10.95	497280.0
2010-10-28 08:00:00	AAPL	Stock	10.9518	10.9643	10.9329	10.9579	1988812.0
2010-10-28 08:30:00	AAPL	Stock	10.9589	11.0071	10.9518	10.9914	5417356.0
2010-10-28 09:00:00	AAPL	Stock	10.9921	11.0175	10.9811	10.9993	1592640.0
2010-10-28 09:30:00	AAPL	Stock	11.0004	11.0004	10.9082	10.9229	67515896.0
2010-10-28 10:00:00	AAPL	Stock	10.9246	10.9579	10.8589	10.8668	57340444.0
2010-10-28 10:30:00	AAPL	Stock	10.8682	10.8814	10.8364	10.8511	50476328.0
2010-10-28 11:00:00	AAPL	Stock	10.8497	10.8864	10.8439	10.8773	26852000.0
2010-10-28 11:30:00	AAPL	Stock	10.8754	10.8764	10.8514	10.8536	15424668.0
2010-10-28 12:00:00	AAPL	Stock	10.8525	10.8529	10.8082	10.8189	29509480.0
2010-10-28 12:30:00	AAPL	Stock	10.8182	10.82	10.7636	10.7654	39142236.0
2010-10-28 13:00:00	AAPL	Stock	10.7639	10.8482	10.7464	10.835	57642648.0
2010-10-28 13:30:00	AAPL	Stock	10.8336	10.8571	10.8232	10.8393	23514400.0
2010-10-28 14:00:00	AAPL	Stock	10.8382	10.8886	10.8361	10.8789	31232292.0
2010-10-28 14:30:00	AAPL	Stock	10.8798	10.9075	10.8725	10.8864	31626196.0
2010-10-28 15:00:00	AAPL	Stock	10.8864	10.9154	10.8732	10.9011	37476796.0
2010-10-28 15:30:00	AAPL	Stock	10.9029	10.9443	10.8886	10.9011	60574892.0
2010-10-28 16:00:00	AAPL	Stock	10.9014	10.9179	10.8761	10.9004	8158052.0
2010-10-28 16:30:00	AAPL	Stock	10.9036	10.9334	10.9036	10.9139	588196.0
2010-10-28 17:00:00	AAPL	Stock	10.9132	10.9161	10.8979	10.9018	365400.0
2010-10-28 17:30:00	AAPL	Stock	10.9046	10.9068	10.8996	10.9011	310912.0
2010-10-28 18:00:00	AAPL	Stock	10.9	10.9014	10.8946	10.8979	183008.0
2010-10-28 18:30:00	AAPL	Stock	10.8946	10.8946	10.8825	10.8871	232428.0
2010-10-28 19:00:00	AAPL	Stock	10.8871	10.8939	10.8768	10.8804	610036.0
2010-10-28 19:30:00	AAPL	Stock	10.8789	10.89	10.8629	10.89	1228724.0
2010-10-28 05:00:00	MSFT	Stock	26.15	26.15	26.15	26.15	100.0
2010-10-28 07:00:00	MSFT	Stock	26.13	26.13	26.01	26.11	2100.0
2010-10-28 08:00:00	MSFT	Stock	26.1	26.18	25.96	26.18	30080.0
2010-10-28 08:30:00	MSFT	Stock	26.16	26.21	26.14	26.17	50897.0
2010-10-28 09:00:00	MSFT	Stock	26.16	26.21	26.16	26.21	103416.0
2010-10-28 09:30:00	MSFT	Stock	26.21	26.25	26.1	26.21	6931325.0
2010-10-28 10:00:00	MSFT	Stock	26.21	26.32	26.11	26.13	6569929.0
2010-10-28 10:30:00	MSFT	Stock	26.13	26.15	26.01	26.064	3230784.0
2010-10-28 11:00:00	MSFT	Stock	26.06	26.18	26.04	26.113	3360597.0
2010-10-28 11:30:00	MSFT	Stock	26.115	26.12	25.95	25.97	2758128.0
2010-10-28 12:00:00	MSFT	Stock	25.97	26.03	25.92	26.018	3143231.0
2010-10-28 12:30:00	MSFT	Stock	26.01	26.12	25.98	26.09	3339071.0
2010-10-28 13:00:00	MSFT	Stock	26.09	26.24	26.05	26.21	3633971.0
2010-10-28 13:30:00	MSFT	Stock	26.201	26.25	26.18	26.21	3192045.0
2010-10-28 14:00:00	MSFT	Stock	26.21	26.3	26.2	26.29	4041526.0
2010-10-28 14:30:00	MSFT	Stock	26.295	26.38	26.25	26.3	6724109.0
2010-10-28 15:00:00	MSFT	Stock	26.3	26.31	26.16	26.19	4704611.0
2010-10-28 15:30:00	MSFT	Stock	26.195	26.37	26.19	26.27	13955126.0
2010-10-28 16:00:00	MSFT	Stock	26.27	27.12	26.207	26.61	9007989.0
2010-10-28 16:30:00	MSFT	Stock	26.6	27.23	26.195	27.18	1900209.0

> showing 50 of 75,542 rows — these rows as CSV

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