PREVIEW / stock_30min / 2007-06-28

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-28.parquet
  size:    1.1 MB
  rows:    62,568
  symbols: 3,007

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-06-28 09:30:00	AAPL	Stock	4.37	4.3746	4.3079	4.3136	119683732.0
2007-06-28 10:00:00	AAPL	Stock	4.315	4.315	4.2857	4.2932	104366612.0
2007-06-28 10:30:00	AAPL	Stock	4.2936	4.3129	4.2911	4.3061	53602780.0
2007-06-28 11:00:00	AAPL	Stock	4.3061	4.3107	4.29	4.2954	49232652.0
2007-06-28 11:30:00	AAPL	Stock	4.2954	4.3075	4.2943	4.3011	32473028.0
2007-06-28 12:00:00	AAPL	Stock	4.3011	4.3182	4.2989	4.3172	34769392.0
2007-06-28 12:30:00	AAPL	Stock	4.3175	4.3214	4.3086	4.3151	36231328.0
2007-06-28 13:00:00	AAPL	Stock	4.3154	4.3168	4.3043	4.3132	21840168.0
2007-06-28 13:30:00	AAPL	Stock	4.3132	4.3304	4.3118	4.3275	27851376.0
2007-06-28 14:00:00	AAPL	Stock	4.3279	4.3568	4.3125	4.325	76676488.0
2007-06-28 14:30:00	AAPL	Stock	4.3254	4.3396	4.3064	4.3279	85643628.0
2007-06-28 15:00:00	AAPL	Stock	4.3279	4.3296	4.3089	4.3211	60994248.0
2007-06-28 15:30:00	AAPL	Stock	4.3211	4.3286	4.305	4.3057	74722284.0
2007-06-28 16:00:00	AAPL	Stock	4.3057	4.3057	4.3057	4.3057	22624532.0
2007-06-28 09:30:00	MSFT	Stock	29.86	29.9	29.76	29.85	3593252.0
2007-06-28 10:00:00	MSFT	Stock	29.85	29.91	29.82	29.86	3324753.0
2007-06-28 10:30:00	MSFT	Stock	29.86	29.88	29.78	29.79	2198526.0
2007-06-28 11:00:00	MSFT	Stock	29.8	29.81	29.73	29.742	3083974.0
2007-06-28 11:30:00	MSFT	Stock	29.74	29.82	29.68	29.761	2354579.0
2007-06-28 12:00:00	MSFT	Stock	29.76	29.8	29.72	29.742	2389510.0
2007-06-28 12:30:00	MSFT	Stock	29.75	29.82	29.74	29.82	1795307.0
2007-06-28 13:00:00	MSFT	Stock	29.82	29.82	29.77	29.79	881481.0
2007-06-28 13:30:00	MSFT	Stock	29.79	29.83	29.75	29.81	1187798.0
2007-06-28 14:00:00	MSFT	Stock	29.81	29.91	29.76	29.83	4450299.0
2007-06-28 14:30:00	MSFT	Stock	29.82	29.97	29.78	29.97	4682139.0
2007-06-28 15:00:00	MSFT	Stock	29.96	29.97	29.88	29.93	3186057.0
2007-06-28 15:30:00	MSFT	Stock	29.922	29.96	29.83	29.83	5051578.0
2007-06-28 16:00:00	MSFT	Stock	29.83	29.83	29.83	29.83	1026962.0
2007-06-28 08:00:00	NVDA	Stock	0.6992	0.7025	0.6992	0.7	396000.0
2007-06-28 08:30:00	NVDA	Stock	0.6983	0.6983	0.695	0.6952	368400.0
2007-06-28 09:00:00	NVDA	Stock	0.695	0.6958	0.6933	0.695	1161720.0
2007-06-28 09:30:00	NVDA	Stock	0.6952	0.7053	0.6883	0.7035	71559900.0
2007-06-28 10:00:00	NVDA	Stock	0.7035	0.7068	0.7022	0.7038	46277100.0
2007-06-28 10:30:00	NVDA	Stock	0.704	0.7042	0.699	0.7012	54442020.0
2007-06-28 11:00:00	NVDA	Stock	0.7012	0.7022	0.7002	0.7003	29525400.0
2007-06-28 11:30:00	NVDA	Stock	0.7003	0.705	0.7003	0.7043	22745100.0
2007-06-28 12:00:00	NVDA	Stock	0.7042	0.7073	0.7035	0.705	31272960.0
2007-06-28 12:30:00	NVDA	Stock	0.705	0.7055	0.7035	0.7048	21424320.0
2007-06-28 13:00:00	NVDA	Stock	0.7047	0.7058	0.6992	0.702	64102860.0
2007-06-28 13:30:00	NVDA	Stock	0.702	0.7033	0.7015	0.7023	20803140.0
2007-06-28 14:00:00	NVDA	Stock	0.7023	0.7073	0.7008	0.7018	48317820.0
2007-06-28 14:30:00	NVDA	Stock	0.7017	0.7052	0.6968	0.7022	58394580.0
2007-06-28 15:00:00	NVDA	Stock	0.7022	0.7042	0.6983	0.7035	46858980.0
2007-06-28 15:30:00	NVDA	Stock	0.7033	0.7047	0.6988	0.6993	50164140.0
2007-06-28 16:00:00	NVDA	Stock	0.6993	0.7	0.6983	0.7	5470440.0
2007-06-28 16:30:00	NVDA	Stock	0.7038	0.7038	0.6998	0.7014	3316980.0
2007-06-28 17:00:00	NVDA	Stock	0.7033	0.7033	0.7033	0.7033	24000.0
2007-06-28 17:30:00	NVDA	Stock	0.7005	0.7005	0.7005	0.7005	7140.0
2007-06-28 18:00:00	NVDA	Stock	0.7008	0.7012	0.7008	0.7012	286860.0
2007-06-28 18:30:00	NVDA	Stock	0.7012	0.7012	0.7012	0.7012	120000.0

> showing 50 of 62,568 rows — these rows as CSV

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