PREVIEW / stock_30min / 2007-03-05

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-05.parquet
  size:    1.1 MB
  rows:    61,022
  symbols: 2,539

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-03-05 04:30:00	AAPL	Stock	3.0	3.0	3.0	3.0	14700.0
2007-03-05 06:00:00	AAPL	Stock	2.9921	2.9921	2.9893	2.9893	42000.0
2007-03-05 06:30:00	AAPL	Stock	2.9986	3.0357	2.9986	3.0357	230440.0
2007-03-05 07:00:00	AAPL	Stock	3.035	3.0357	3.0214	3.0286	231896.0
2007-03-05 07:30:00	AAPL	Stock	3.0286	3.0461	3.0286	3.0446	758268.0
2007-03-05 08:00:00	AAPL	Stock	3.04	3.0529	3.0357	3.05	3385340.0
2007-03-05 08:30:00	AAPL	Stock	3.05	3.0804	3.0479	3.0714	3809036.0
2007-03-05 09:00:00	AAPL	Stock	3.0732	3.0796	3.0636	3.0668	3654392.0
2007-03-05 09:30:00	AAPL	Stock	3.0675	3.1661	3.0629	3.1182	136306408.0
2007-03-05 10:00:00	AAPL	Stock	3.1186	3.1282	3.0964	3.1121	109511836.0
2007-03-05 10:30:00	AAPL	Stock	3.1193	3.1193	3.0911	3.0993	72226000.0
2007-03-05 11:00:00	AAPL	Stock	3.0989	3.1186	3.0939	3.1054	55599572.0
2007-03-05 11:30:00	AAPL	Stock	3.1051	3.1064	3.0875	3.0875	46853492.0
2007-03-05 12:00:00	AAPL	Stock	3.0875	3.1018	3.0736	3.0768	49366800.0
2007-03-05 12:30:00	AAPL	Stock	3.0771	3.0889	3.0739	3.0782	40969292.0
2007-03-05 13:00:00	AAPL	Stock	3.0779	3.0893	3.0761	3.0889	37937088.0
2007-03-05 13:30:00	AAPL	Stock	3.0889	3.1036	3.0857	3.1021	47842788.0
2007-03-05 14:00:00	AAPL	Stock	3.1025	3.1114	3.0936	3.0961	49532812.0
2007-03-05 14:30:00	AAPL	Stock	3.0957	3.105	3.0911	3.0989	34174896.0
2007-03-05 15:00:00	AAPL	Stock	3.0989	3.1046	3.0836	3.1007	51582468.0
2007-03-05 15:30:00	AAPL	Stock	3.1007	3.1032	3.0771	3.0814	64986096.0
2007-03-05 16:00:00	AAPL	Stock	3.0811	3.0861	3.0793	3.0829	3224816.0
2007-03-05 16:30:00	AAPL	Stock	3.0829	3.0879	3.0821	3.0879	342804.0
2007-03-05 17:00:00	AAPL	Stock	3.0857	3.1268	3.0651	3.1021	12076708.0
2007-03-05 17:30:00	AAPL	Stock	3.1124	3.1269	3.065	3.0956	3815028.0
2007-03-05 18:00:00	AAPL	Stock	3.0876	3.1267	3.065	3.0871	2873584.0
2007-03-05 18:30:00	AAPL	Stock	3.0875	3.0875	3.0875	3.0875	12600.0
2007-03-05 19:00:00	AAPL	Stock	3.0893	3.1025	3.0893	3.0996	169624.0
2007-03-05 19:30:00	AAPL	Stock	3.0996	3.0996	3.0893	3.0943	98224.0
2007-03-05 04:00:00	MSFT	Stock	27.58	27.59	27.52	27.52	700.0
2007-03-05 05:00:00	MSFT	Stock	27.3	27.3	27.28	27.28	4200.0
2007-03-05 05:30:00	MSFT	Stock	27.27	27.29	27.27	27.29	3000.0
2007-03-05 06:00:00	MSFT	Stock	27.27	27.28	27.27	27.28	14000.0
2007-03-05 06:30:00	MSFT	Stock	27.29	27.29	27.24	27.24	600.0
2007-03-05 07:00:00	MSFT	Stock	27.28	27.46	27.28	27.35	1300.0
2007-03-05 07:30:00	MSFT	Stock	27.35	27.39	27.31	27.39	12257.0
2007-03-05 08:00:00	MSFT	Stock	27.37	27.49	27.37	27.4	45225.0
2007-03-05 08:30:00	MSFT	Stock	27.4	27.76	27.38	27.76	7833941.0
2007-03-05 09:00:00	MSFT	Stock	27.45	27.76	27.43	27.49	1633044.0
2007-03-05 09:30:00	MSFT	Stock	27.49	27.8	27.41	27.75	7908150.0
2007-03-05 10:00:00	MSFT	Stock	27.75	27.9	27.6	27.83	4620037.0
2007-03-05 10:30:00	MSFT	Stock	27.83	27.85	27.71	27.77	1857585.0
2007-03-05 11:00:00	MSFT	Stock	27.78	27.91	27.74	27.81	2275876.0
2007-03-05 11:30:00	MSFT	Stock	27.81	27.81	27.67	27.71	2337608.0
2007-03-05 12:00:00	MSFT	Stock	27.71	27.73	27.63	27.67	2050812.0
2007-03-05 12:30:00	MSFT	Stock	27.67	27.727	27.61	27.65	2009757.0
2007-03-05 13:00:00	MSFT	Stock	27.64	27.69	27.64	27.68	1437258.0
2007-03-05 13:30:00	MSFT	Stock	27.67	27.77	27.67	27.74	1330869.0
2007-03-05 14:00:00	MSFT	Stock	27.75	27.8	27.65	27.67	1844786.0
2007-03-05 14:30:00	MSFT	Stock	27.671	27.74	27.66	27.69	1699927.0

> showing 50 of 61,022 rows — these rows as CSV

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