PREVIEW / stock_30min / 2008-06-03

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-03.parquet
  size:    1.3 MB
  rows:    72,574
  symbols: 3,312

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
2008-06-03 07:30:00	AAPL	Stock	6.6529	6.6607	6.6529	6.6607	19320.0
2008-06-03 08:00:00	AAPL	Stock	6.6607	6.6825	6.6607	6.6704	1622712.0
2008-06-03 08:30:00	AAPL	Stock	6.6686	6.6743	6.6625	6.6689	688996.0
2008-06-03 09:00:00	AAPL	Stock	6.6696	6.6768	6.6464	6.6746	1476272.0
2008-06-03 09:30:00	AAPL	Stock	6.6736	6.6779	6.6271	6.6668	76108732.0
2008-06-03 10:00:00	AAPL	Stock	6.6671	6.7057	6.6671	6.6761	67925424.0
2008-06-03 10:30:00	AAPL	Stock	6.6757	6.7043	6.6711	6.6961	37938488.0
2008-06-03 11:00:00	AAPL	Stock	6.6957	6.7214	6.6954	6.705	46462948.0
2008-06-03 11:30:00	AAPL	Stock	6.7043	6.7143	6.6907	6.7111	28416724.0
2008-06-03 12:00:00	AAPL	Stock	6.7121	6.7136	6.6786	6.69	26386332.0
2008-06-03 12:30:00	AAPL	Stock	6.6896	6.6996	6.6757	6.6846	28739732.0
2008-06-03 13:00:00	AAPL	Stock	6.6856	6.7036	6.6736	6.6821	26904136.0
2008-06-03 13:30:00	AAPL	Stock	6.6825	6.6825	6.5714	6.5954	86005920.0
2008-06-03 14:00:00	AAPL	Stock	6.5943	6.615	6.5121	6.5143	78540700.0
2008-06-03 14:30:00	AAPL	Stock	6.5139	6.5846	6.512	6.5829	66386740.0
2008-06-03 15:00:00	AAPL	Stock	6.5807	6.6229	6.5604	6.62	71424752.0
2008-06-03 15:30:00	AAPL	Stock	6.6196	6.6675	6.6125	6.6207	90450976.0
2008-06-03 16:00:00	AAPL	Stock	6.6264	6.6464	6.6071	6.6289	7701456.0
2008-06-03 16:30:00	AAPL	Stock	6.6232	6.6392	6.6125	6.6206	879760.0
2008-06-03 17:00:00	AAPL	Stock	6.6154	6.6364	6.61	6.6107	245140.0
2008-06-03 17:30:00	AAPL	Stock	6.6107	6.6204	6.6079	6.6125	171612.0
2008-06-03 18:00:00	AAPL	Stock	6.6107	6.6204	6.6086	6.6086	6400100.0
2008-06-03 18:30:00	AAPL	Stock	6.6086	6.6125	6.6071	6.6089	164080.0
2008-06-03 19:00:00	AAPL	Stock	6.6089	6.6089	6.6061	6.6061	24864.0
2008-06-03 19:30:00	AAPL	Stock	6.6036	6.6071	6.5993	6.5993	167832.0
2008-06-03 07:30:00	MSFT	Stock	27.91	27.91	27.91	27.91	100.0
2008-06-03 08:00:00	MSFT	Stock	27.9	27.91	27.89	27.89	1815.0
2008-06-03 08:30:00	MSFT	Stock	27.89	27.9	27.86	27.9	6001.0
2008-06-03 09:00:00	MSFT	Stock	27.88	27.97	27.86	27.94	25883.0
2008-06-03 09:30:00	MSFT	Stock	27.94	28.08	27.81	28.03	6154004.0
2008-06-03 10:00:00	MSFT	Stock	28.04	28.31	27.93	27.98	5350165.0
2008-06-03 10:30:00	MSFT	Stock	27.97	28.09	27.89	27.982	3736928.0
2008-06-03 11:00:00	MSFT	Stock	27.99	28.06	27.96	27.99	2538298.0
2008-06-03 11:30:00	MSFT	Stock	27.99	28.0	27.9	27.93	3149258.0
2008-06-03 12:00:00	MSFT	Stock	27.93	27.93	27.79	27.8	3104849.0
2008-06-03 12:30:00	MSFT	Stock	27.8	27.83	27.74	27.77	3357572.0
2008-06-03 13:00:00	MSFT	Stock	27.78	27.78	27.61	27.63	5018439.0
2008-06-03 13:30:00	MSFT	Stock	27.62	27.63	27.33	27.45	10785253.0
2008-06-03 14:00:00	MSFT	Stock	27.45	27.48	27.27	27.295	8084718.0
2008-06-03 14:30:00	MSFT	Stock	27.3	27.39	27.27	27.368	6188727.0
2008-06-03 15:00:00	MSFT	Stock	27.37	27.47	27.29	27.44	7983936.0
2008-06-03 15:30:00	MSFT	Stock	27.435	27.49	27.31	27.31	10274916.0
2008-06-03 16:00:00	MSFT	Stock	27.31	27.8	27.3	27.33	6244589.0
2008-06-03 16:30:00	MSFT	Stock	27.32	27.662	27.304	27.34	231539.0
2008-06-03 17:00:00	MSFT	Stock	27.34	27.36	27.31	27.32	35617.0
2008-06-03 17:30:00	MSFT	Stock	27.95	27.95	27.31	27.32	24475.0
2008-06-03 18:00:00	MSFT	Stock	27.34	27.95	27.31	27.33	5009407.0
2008-06-03 18:30:00	MSFT	Stock	27.34	27.34	27.33	27.33	5050.0
2008-06-03 19:00:00	MSFT	Stock	27.33	27.34	27.33	27.34	2310.0
2008-06-03 19:30:00	MSFT	Stock	27.34	27.35	27.34	27.35	7582.0

> showing 50 of 72,574 rows — these rows as CSV

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