PREVIEW / stock_30min / 2007-10-02

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-02.parquet
  size:    1.2 MB
  rows:    68,336
  symbols: 3,114

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
2007-10-02 05:30:00	AAPL	Stock	5.6018	5.6018	5.6018	5.6018	15400.0
2007-10-02 06:00:00	AAPL	Stock	5.6018	5.6154	5.6018	5.6154	9072.0
2007-10-02 06:30:00	AAPL	Stock	5.6154	5.6154	5.6154	5.6154	2800.0
2007-10-02 07:00:00	AAPL	Stock	5.6018	5.6189	5.5929	5.5936	131600.0
2007-10-02 07:30:00	AAPL	Stock	5.5982	5.6125	5.5982	5.6054	140700.0
2007-10-02 08:00:00	AAPL	Stock	5.6071	5.615	5.5964	5.6021	2625868.0
2007-10-02 08:30:00	AAPL	Stock	5.6018	5.6043	5.5736	5.5861	3108980.0
2007-10-02 09:00:00	AAPL	Stock	5.5864	5.6039	5.5786	5.5918	2233924.0
2007-10-02 09:30:00	AAPL	Stock	5.5911	5.6325	5.5761	5.6118	115749648.0
2007-10-02 10:00:00	AAPL	Stock	5.6111	5.6639	5.6068	5.6289	102548488.0
2007-10-02 10:30:00	AAPL	Stock	5.6289	5.6418	5.5893	5.5964	89597536.0
2007-10-02 11:00:00	AAPL	Stock	5.5961	5.6054	5.5675	5.6036	79081184.0
2007-10-02 11:30:00	AAPL	Stock	5.6036	5.6104	5.5886	5.6071	38545948.0
2007-10-02 12:00:00	AAPL	Stock	5.6071	5.6086	5.595	5.5979	23017624.0
2007-10-02 12:30:00	AAPL	Stock	5.5979	5.6004	5.5779	5.5971	28600012.0
2007-10-02 13:00:00	AAPL	Stock	5.5968	5.5993	5.5868	5.59	19523868.0
2007-10-02 13:30:00	AAPL	Stock	5.5904	5.6357	5.59	5.6239	48995520.0
2007-10-02 14:00:00	AAPL	Stock	5.6239	5.6321	5.6146	5.625	33459300.0
2007-10-02 14:30:00	AAPL	Stock	5.625	5.6468	5.6118	5.6393	62638156.0
2007-10-02 15:00:00	AAPL	Stock	5.6396	5.6446	5.6189	5.6218	41078016.0
2007-10-02 15:30:00	AAPL	Stock	5.6214	5.6607	5.615	5.6593	79304372.0
2007-10-02 16:00:00	AAPL	Stock	5.6588	5.66	5.6061	5.6561	9509248.0
2007-10-02 16:30:00	AAPL	Stock	5.6561	5.6589	5.6168	5.655	1053248.0
2007-10-02 17:00:00	AAPL	Stock	5.6546	5.6589	5.6518	5.6554	9831388.0
2007-10-02 17:30:00	AAPL	Stock	5.6546	5.6589	5.6504	5.6589	361004.0
2007-10-02 18:00:00	AAPL	Stock	5.6546	5.6589	5.6418	5.6554	480760.0
2007-10-02 18:30:00	AAPL	Stock	5.6539	5.6554	5.6521	5.6554	92708.0
2007-10-02 19:00:00	AAPL	Stock	5.6554	5.6554	5.6464	5.6464	241864.0
2007-10-02 19:30:00	AAPL	Stock	5.6496	5.6511	5.6471	5.6511	124740.0
2007-10-02 07:00:00	MSFT	Stock	29.73	29.73	29.73	29.73	300.0
2007-10-02 07:30:00	MSFT	Stock	29.75	29.78	29.75	29.78	3200.0
2007-10-02 08:00:00	MSFT	Stock	29.77	29.8	29.76	29.76	8225.0
2007-10-02 08:30:00	MSFT	Stock	29.77	29.77	29.71	29.77	600.0
2007-10-02 09:00:00	MSFT	Stock	29.74	29.82	29.69	29.78	53126.0
2007-10-02 09:30:00	MSFT	Stock	29.77	29.8	29.58	29.601	3110827.0
2007-10-02 10:00:00	MSFT	Stock	29.6	29.72	29.57	29.66	2411705.0
2007-10-02 10:30:00	MSFT	Stock	29.65	29.69	29.62	29.67	2461045.0
2007-10-02 11:00:00	MSFT	Stock	29.66	29.8	29.61	29.791	2318997.0
2007-10-02 11:30:00	MSFT	Stock	29.791	29.85	29.78	29.84	2603152.0
2007-10-02 12:00:00	MSFT	Stock	29.84	29.85	29.77	29.77	1376429.0
2007-10-02 12:30:00	MSFT	Stock	29.78	29.78	29.71	29.76	1626916.0
2007-10-02 13:00:00	MSFT	Stock	29.761	29.82	29.75	29.77	1773125.0
2007-10-02 13:30:00	MSFT	Stock	29.77	29.8	29.69	29.765	2297591.0
2007-10-02 14:00:00	MSFT	Stock	29.77	29.8	29.75	29.76	1851100.0
2007-10-02 14:30:00	MSFT	Stock	29.76	29.76	29.65	29.657	1993117.0
2007-10-02 15:00:00	MSFT	Stock	29.657	29.69	29.59	29.69	3083553.0
2007-10-02 15:30:00	MSFT	Stock	29.69	29.71	29.64	29.7	4169557.0
2007-10-02 16:00:00	MSFT	Stock	29.7	29.809	29.673	29.7	1124341.0
2007-10-02 16:30:00	MSFT	Stock	29.7	29.75	29.7	29.708	183392.0
2007-10-02 17:00:00	MSFT	Stock	29.7	29.7	29.67	29.67	1094400.0

> showing 50 of 68,336 rows — these rows as CSV

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