PREVIEW / stock_30min / 2005-07-27

all stock 30-min files

  file:    by_date/stock_30min/2005/2005-07-27.parquet
  size:    831 KB
  rows:    44,755
  symbols: 2,042

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
2005-07-27 07:30:00	AAPL	Stock	1.5564	1.5564	1.5564	1.5564	14000.0
2005-07-27 08:00:00	AAPL	Stock	1.5561	1.5571	1.5561	1.5571	36316.0
2005-07-27 08:30:00	AAPL	Stock	1.5568	1.5607	1.5568	1.5607	194432.0
2005-07-27 09:00:00	AAPL	Stock	1.5607	1.5654	1.5607	1.5654	124180.0
2005-07-27 09:30:00	AAPL	Stock	1.5654	1.5668	1.5368	1.54	36179864.0
2005-07-27 10:00:00	AAPL	Stock	1.54	1.5418	1.5239	1.5354	39605636.0
2005-07-27 10:30:00	AAPL	Stock	1.5354	1.5529	1.535	1.5439	25772768.0
2005-07-27 11:00:00	AAPL	Stock	1.5439	1.5489	1.5439	1.5471	12627132.0
2005-07-27 11:30:00	AAPL	Stock	1.5471	1.5489	1.545	1.5461	7789544.0
2005-07-27 12:00:00	AAPL	Stock	1.5464	1.5529	1.5446	1.5468	19436060.0
2005-07-27 12:30:00	AAPL	Stock	1.5468	1.5518	1.5454	1.55	10430364.0
2005-07-27 13:00:00	AAPL	Stock	1.5504	1.5564	1.5475	1.5546	13561296.0
2005-07-27 13:30:00	AAPL	Stock	1.555	1.5582	1.5525	1.5546	11295536.0
2005-07-27 14:00:00	AAPL	Stock	1.555	1.5693	1.5536	1.5686	25373460.0
2005-07-27 14:30:00	AAPL	Stock	1.5689	1.5739	1.5675	1.5689	28535612.0
2005-07-27 15:00:00	AAPL	Stock	1.5689	1.5718	1.5661	1.5679	18601324.0
2005-07-27 15:30:00	AAPL	Stock	1.5679	1.5711	1.5668	1.5711	28042784.0
2005-07-27 16:00:00	AAPL	Stock	1.5711	1.5711	1.5571	1.5711	383908.0
2005-07-27 16:30:00	AAPL	Stock	1.5711	1.5711	1.5689	1.5711	140028.0
2005-07-27 17:00:00	AAPL	Stock	1.5679	1.57	1.5679	1.5679	57960.0
2005-07-27 17:30:00	AAPL	Stock	1.5679	1.5693	1.5679	1.5693	33600.0
2005-07-27 18:00:00	AAPL	Stock	1.5693	1.5693	1.5693	1.5693	2800.0
2005-07-27 07:30:00	MSFT	Stock	25.6	25.6	25.6	25.6	300.0
2005-07-27 08:00:00	MSFT	Stock	25.59	25.59	25.58	25.59	15089.0
2005-07-27 08:30:00	MSFT	Stock	25.58	25.61	25.55	25.61	21875.0
2005-07-27 09:00:00	MSFT	Stock	25.6	25.63	25.56	25.61	118848.0
2005-07-27 09:30:00	MSFT	Stock	25.61	25.63	25.53	25.56	7376363.0
2005-07-27 10:00:00	MSFT	Stock	25.57	25.71	25.54	25.7	5956692.0
2005-07-27 10:30:00	MSFT	Stock	25.69	25.76	25.66	25.7	5075170.0
2005-07-27 11:00:00	MSFT	Stock	25.7	25.74	25.61	25.66	4109161.0
2005-07-27 11:30:00	MSFT	Stock	25.66	25.69	25.62	25.64	1818707.0
2005-07-27 12:00:00	MSFT	Stock	25.64	25.7	25.62	25.63	2820997.0
2005-07-27 12:30:00	MSFT	Stock	25.62	25.68	25.62	25.67	2261161.0
2005-07-27 13:00:00	MSFT	Stock	25.67	25.69	25.6	25.65	2509280.0
2005-07-27 13:30:00	MSFT	Stock	25.66	25.75	25.649	25.65	3989172.0
2005-07-27 14:00:00	MSFT	Stock	25.65	25.75	25.64	25.7	4039653.0
2005-07-27 14:30:00	MSFT	Stock	25.69	25.76	25.69	25.74	3718240.0
2005-07-27 15:00:00	MSFT	Stock	25.75	25.8	25.68	25.79	2950037.0
2005-07-27 15:30:00	MSFT	Stock	25.79	25.8	25.69	25.72	9560076.0
2005-07-27 16:00:00	MSFT	Stock	25.72	25.76	25.7	25.72	234734.0
2005-07-27 16:30:00	MSFT	Stock	25.72	25.74	25.7	25.72	24118.0
2005-07-27 17:00:00	MSFT	Stock	25.71	25.71	25.7	25.7	2500.0
2005-07-27 17:30:00	MSFT	Stock	25.7	25.7	25.7	25.7	4300.0
2005-07-27 18:00:00	MSFT	Stock	25.72	25.72	25.65	25.65	51146.0
2005-07-27 08:30:00	NVDA	Stock	0.2212	0.2223	0.2212	0.2223	144000.0
2005-07-27 09:00:00	NVDA	Stock	0.2212	0.2215	0.2212	0.2212	444000.0
2005-07-27 09:30:00	NVDA	Stock	0.2213	0.2218	0.2192	0.22	62313360.0
2005-07-27 10:00:00	NVDA	Stock	0.22	0.2202	0.2176	0.218	84592080.0
2005-07-27 10:30:00	NVDA	Stock	0.2183	0.2222	0.2176	0.2217	99379920.0
2005-07-27 11:00:00	NVDA	Stock	0.2217	0.2228	0.2217	0.2223	29833800.0

> showing 50 of 44,755 rows — these rows as CSV

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