PREVIEW / stock_30min / 2009-11-02

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-11-02.parquet
  size:    1.4 MB
  rows:    73,445
  symbols: 3,411

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
2009-11-02 04:00:00	AAPL	Stock	6.7707	6.7707	6.7679	6.7679	30408.0
2009-11-02 05:30:00	AAPL	Stock	6.75	6.7643	6.75	6.7643	5600.0
2009-11-02 06:30:00	AAPL	Stock	6.7821	6.7821	6.7821	6.7821	24360.0
2009-11-02 07:00:00	AAPL	Stock	6.7625	6.7857	6.7625	6.7679	193508.0
2009-11-02 07:30:00	AAPL	Stock	6.7629	6.7818	6.7607	6.7607	147812.0
2009-11-02 08:00:00	AAPL	Stock	6.7714	6.7834	6.7321	6.7771	846440.0
2009-11-02 08:30:00	AAPL	Stock	6.7807	6.7968	6.7807	6.7857	1531656.0
2009-11-02 09:00:00	AAPL	Stock	6.7845	6.79	6.7682	6.7775	910924.0
2009-11-02 09:30:00	AAPL	Stock	6.7782	6.8079	6.6275	6.7404	140281876.0
2009-11-02 10:00:00	AAPL	Stock	6.7404	6.8886	6.7361	6.8471	115169292.0
2009-11-02 10:30:00	AAPL	Stock	6.8471	6.8793	6.8054	6.8125	53821824.0
2009-11-02 11:00:00	AAPL	Stock	6.8137	6.8479	6.8071	6.8143	37697016.0
2009-11-02 11:30:00	AAPL	Stock	6.8143	6.8389	6.7979	6.8232	22746052.0
2009-11-02 12:00:00	AAPL	Stock	6.8246	6.8279	6.78	6.7802	24151652.0
2009-11-02 12:30:00	AAPL	Stock	6.7811	6.7875	6.6864	6.6875	46287332.0
2009-11-02 13:00:00	AAPL	Stock	6.6875	6.7643	6.6821	6.755	46541068.0
2009-11-02 13:30:00	AAPL	Stock	6.7557	6.7561	6.7036	6.7061	29217552.0
2009-11-02 14:00:00	AAPL	Stock	6.7041	6.7587	6.685	6.7568	42345268.0
2009-11-02 14:30:00	AAPL	Stock	6.757	6.7821	6.7414	6.763	33727008.0
2009-11-02 15:00:00	AAPL	Stock	6.7625	6.7786	6.7257	6.7382	31102596.0
2009-11-02 15:30:00	AAPL	Stock	6.7393	6.775	6.7361	6.7604	38816008.0
2009-11-02 16:00:00	AAPL	Stock	6.7604	6.7709	6.7366	6.7621	6204716.0
2009-11-02 16:30:00	AAPL	Stock	6.7657	6.7732	6.7607	6.7625	525756.0
2009-11-02 17:00:00	AAPL	Stock	6.7661	6.7711	6.7439	6.7679	427672.0
2009-11-02 17:30:00	AAPL	Stock	6.7679	6.7711	6.7643	6.7675	113960.0
2009-11-02 18:00:00	AAPL	Stock	6.7611	6.765	6.7596	6.7596	498904.0
2009-11-02 18:30:00	AAPL	Stock	6.7589	6.7639	6.7589	6.7607	175280.0
2009-11-02 19:00:00	AAPL	Stock	6.7607	6.7711	6.7607	6.7711	234724.0
2009-11-02 19:30:00	AAPL	Stock	6.77	6.775	6.7621	6.775	196112.0
2009-11-02 04:00:00	MSFT	Stock	27.68	27.68	27.65	27.65	1000.0
2009-11-02 07:00:00	MSFT	Stock	27.71	27.71	27.71	27.71	200.0
2009-11-02 07:30:00	MSFT	Stock	27.75	27.78	27.75	27.78	1200.0
2009-11-02 08:00:00	MSFT	Stock	27.78	27.88	27.78	27.87	3739.0
2009-11-02 08:30:00	MSFT	Stock	27.87	27.89	27.81	27.83	13964.0
2009-11-02 09:00:00	MSFT	Stock	27.82	27.82	27.6	27.65	160956.0
2009-11-02 09:30:00	MSFT	Stock	27.68	27.88	27.41	27.82	7566909.0
2009-11-02 10:00:00	MSFT	Stock	27.83	27.98	27.71	27.88	7262009.0
2009-11-02 10:30:00	MSFT	Stock	27.88	28.0	27.8	27.87	3849018.0
2009-11-02 11:00:00	MSFT	Stock	27.86	27.95	27.8	27.93	3350790.0
2009-11-02 11:30:00	MSFT	Stock	27.93	28.05	27.89	28.0	2625750.0
2009-11-02 12:00:00	MSFT	Stock	28.0	28.01	27.85	27.903	2172908.0
2009-11-02 12:30:00	MSFT	Stock	27.9	27.94	27.6	27.62	3691837.0
2009-11-02 13:00:00	MSFT	Stock	27.61	27.87	27.59	27.82	5305647.0
2009-11-02 13:30:00	MSFT	Stock	27.81	27.82	27.7	27.74	2557220.0
2009-11-02 14:00:00	MSFT	Stock	27.74	27.91	27.66	27.892	3317551.0
2009-11-02 14:30:00	MSFT	Stock	27.89	28.0	27.84	27.95	3172341.0
2009-11-02 15:00:00	MSFT	Stock	27.952	28.0	27.8	27.88	3880464.0
2009-11-02 15:30:00	MSFT	Stock	27.88	28.01	27.81	27.87	7644407.0
2009-11-02 16:00:00	MSFT	Stock	27.87	27.951	27.814	27.93	4936250.0
2009-11-02 16:30:00	MSFT	Stock	27.88	27.98	27.87	27.87	6400.0

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

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